Workbook.save To CSV file

Aspose.Cells Product Family
1

Issue Detail)
While save workbook to CSV file with SaveOption, Cell displayed value is exported to CSV file like 1,000 not actual value 1000. Is there any way to save CSV file with actual value in cells? Aspose.Cell ver.8.7.1

Thanks

2

@canus,

Thanks for providing us details.

Please try our latest version/fix: Aspose.Cells for .NET v18.3.x.

If you still find the issue with v18.3, kindly do provide your sample code (runnable) with template file(s) to reproduce the issue, we will check it soon.

3

@canus

For your requirement, please try the following option. It should fix your issue.

Java

TxtSaveOptions..setFormatStrategy(CellValueFormatStrategy.NONE);

C#

TxtSaveOptions.FormatStrategy = CellValueFormatStrategy.None;
4

thanks, @Amjad_Sahi, the behavior is same when use latest ver.

5

@shakeel.faiz, thanks for reply.

that interface ‘setFormatStrategy’ works well as I expected, unfortunately, current my version 8.7.1 aspose.cell java doesn’t have that interface ‘setFormatStrategy’

6

@canus,

I am afraid, there is no other alternative but to upgrade to latest version of the product if you need to use that interface attribute. So, you have to upgrade to and use latest version of the product.