Step-by-step guide:
Полный код
using SautinSoft.Excel;
using System.IO;
namespace Example
{
class Program
{
static void Main(string[] args)
{
// Get your free key here:
// https://sautinsoft.com/start-for-free/
ConvertFromFile();
ConvertFromStream();
}
/// <summary>
/// Convert XLS to CSV (file to file).
/// </summary>
/// <remarks>
/// Details: https://sautinsoft.com/products/excel/help/net/developer-guide/convert-xls-to-csv-in-csharp-vb.php
/// </remarks>
static void ConvertFromFile()
{
string inpFile = @"..\..\..\Example.xls";
string outFile = @"..\..\..\Result.csv";
ExcelDocument excelDocument = ExcelDocument.Load(inpFile);
excelDocument.Save(outFile, new CsvSaveOptions());
// Important for Linux: Install MS Fonts
// sudo apt install ttf-mscorefonts-installer -y
// Open the result for demonstration purposes.
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(outFile) { UseShellExecute = true });
}
/// <summary>
/// Convert XLS to CSV (using Stream).
/// </summary>
/// <remarks>
/// Details: https://sautinsoft.com/products/excel/help/net/developer-guide/convert-xls-to-csv-in-csharp-vb.php
/// </remarks>
static void ConvertFromStream()
{
// We need files only for demonstration purposes.
// The conversion process will be done completely in memory.
string inpFile = @"..\..\..\Example.xls";
string outFile = @"..\..\..\ResultStream.csv";
byte[] inpData = File.ReadAllBytes(inpFile);
byte[] outData = null;
using (MemoryStream msInp = new MemoryStream(inpData))
{
// Load a document.
ExcelDocument excelDocument = ExcelDocument.Load(inpFile);
// Save the excel document to csv format.
using (MemoryStream outMs = new MemoryStream())
{
excelDocument.Save(outMs, new CsvSaveOptions());
outData = outMs.ToArray();
}
// Show the result for demonstration purposes.
if (outData != null)
{
File.WriteAllBytes(outFile, outData);
// Important for Linux: Install MS Fonts
// sudo apt install ttf-mscorefonts-installer -y
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(outFile) { UseShellExecute = true });
}
}
}
}
}
Если вам нужен пример кода или у вас есть вопрос: напишите нам по адресу support@sautinsoft.ru или спросите в онлайн-чате (правый нижний угол этой страницы) или используйте форму ниже: