Convert Excel Worksheet into CSV file

[justinx1016]

Hi Experts,

I need load my excel data into my website, but my application only allow me use CSV file. And the data is very large. So, I want to use your Spire.XLS for .NET to help me directly concert my excel workbook into CSV. Could you please tell me how to do it?

thanks

[iceblue support]

hi justin,

You may write your data one by one with a comma as the separator. And use the SaveToFile method to specify the CSV format to save it. For example: Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
sheet.Range[""A2""].Text = ""hello"";
workbook.SaveToFile(""Sample.csv"","","");"

[docged]

Hello,

I tried to convert a workbook, for example DatatableSample.xls, to CSV with V6.0.8.4.
For each conversion, my result is wrong because many special characters parasites the final vue (ý ý ½ È=A ...) 

This is what i do :

Code: Select all

            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"C:\SpireXls\bin\DatatableSample.xls");
            workbook.SaveToFile("DatatableSample.csv", ExcelVersion.Version97to2003);


Is it a bug ?
Thank you.

[harry.support]

Hi justin,

If you want to convert excel worksheet into a csv file, you need a license first.
And then, call SaveToFile/SaveToStream method with a specified separator, for example ,/;/\t etc. Considering internationalization, the result file is saved with Unicode encoding. But different MS-Excel supports different separator and MS-Excel does not support Unicode encoding. So you need do something different.
For Excel 2003:

Code: Select all

Workbook workbook = new Workbook();
workbook.LoadFromFile(@"DatatableSample.xls");
using (MemoryStream buffer = new MemoryStream())
{
      //save to unicode
    workbook.SaveToStream(buffer, ",");
   
    buffer.Position = 0;
   
    //convert to ascii
    using (StreamReader reader = new StreamReader(buffer))
    {
        using (StreamWriter writer = File.CreateText("DatatableSample.csv"))
        {
            String line = null;
            while ((line = reader.ReadLine()) != null)
            {
                writer.WriteLine(line);
            }
        }
    }
}


and for Excel 2010:

Code: Select all

Workbook workbook = new Workbook();
workbook.LoadFromFile(@"DatatableSample.xls");
using (MemoryStream buffer = new MemoryStream())
{
      //save to unicode
    workbook.SaveToStream(buffer, ";");
   
    buffer.Position = 0;
   
    //convert to ascii
    using (StreamReader reader = new StreamReader(buffer))
    {
        using (StreamWriter writer = File.CreateText("DatatableSample.csv"))
        {
            String line = null;
            while ((line = reader.ReadLine()) != null)
            {
                writer.WriteLine(line);
            }
        }
    }
}


and for Excel 2003 & Excel 2010 with multiple languages:

Code: Select all

Workbook workbook = new Workbook();
workbook.LoadFromFile(@"DatatableSample.xls");
workbook.SaveToFile("DatatableSample3.csv", "\t");

[erqvu]

I got round this by specifying the encoding I needed.
.SaveToFile(sOutputPAthFileName, sDelimeter, Encoding.Unicode)
Seems to work fine

[burning.liu]

Dear erqvu,

Glad to hear that your problem has been resolved.
Please feel free to contact us if you have any problems.