Free Support Forum - aspose.com

SaveToCSV

In Version 4.8.2.0 there was a method called SaveToCSV that recognized headers and trailers in a file and did not create extra field delimiters on those rows. Is there an equivalent method in Version 18.10?

@PamTech,

Thanks for your query.

Aspose.Cells (latest version) follows MS Excel standards and specifications in rendering CSV files. Since you are using/referring to a method in an older version (v4.8.2) of the APIs for which we are not sure about it. Please provide your template file (if any), output CSV file and paste your sample code (runnable) using Aspose.Cells v18.10, we will check it and help you though. Also provide your expected CSV file which you may manually create/update or save it in MS Excel (manually). This will help us really to evaluate your requirements precisely to figure it out soon.

SaveAsCSVBug.zip (61.5 KB)

I have added the requested files. Thanks for looking into this.

@PamTech,

Thanks for providing the sample files, however we need more information. Please send us following files:

  1. Source Excel file which is required to be converted to CSV
  2. A console application (runnable) which can be used to observe the issue. It should compile and run without any error and no reference shall be missing
  3. Output of the program in your environment
  4. Expected output CSV file which is actually required or expected using Aspose.Cells (It can be created using some editor etc. and not created using Aspose.Cells)

@PamTech,

By the way, could you try to remove blank rows and columns (via using Worksheet.Cells.DeleteBlankRows() and Worksheet.Cells.DeleteBlankColumns()) just before rendering to CSV file format if it makes any difference.

If you still find the issue, kindly do the needful as requested by Ahsan Iqbal. We will check it soon.