CSV File Generation

Aspose.Cells Product Family
1

Hi all,

I am tring to generated the CSV From my DataSet but the when I open the file in the Excel it show all the data in the come separted value in single column

Below is the code. Kindly let me know if in more information.

Code

Workbook workbook = new Workbook();

License Lic = new License();

Lic.SetLicense(@"C:\Windows\ITSM\Aspose.Cells.lic");

Aspose.Cells.Worksheet worksheet = workbook.Worksheets[0];

worksheet.Name = Filename;

worksheet.Cells.ImportDataTable(FinalLoad.Tables[Filename], true, "A1");

workbook.Save(@"C:\Windows\ITSM\CSV Files\" + Filename + ".csv", FileFormatType.CSV);

Please help me.

Thanks & Regards,

Naveen T

2

Hi Naveen, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Well, I tested you scenario with the attached latest version and it works fine. Please try the attached latest version and if you still face any problem, please create a sample application with your data and post it here. We will check it soon.

Thank You & Best Regards,