Missing Single Quote When Opening .CSV

Aspose.Cells Product Family
1

I am currently using Aspose 7.2.

I am just trying to open a .CSV file. It is a .CSV file where the first column has a string value that starts and ends with single quotes (‘004403AF’). However, when I open it with Aspose, the value of the Cell doesn’t have the leading quote. Am I doing something wrong?

When I use the code below, the Value of the Cell and the output to the console is (004403AF’) (i.e. missing the leading quote)

LoadOptions loadOptions = new LoadOptions(LoadFormat.CSV);

Workbook wb = new Workbook(@"…\Example Files\Sample 1.csv", loadOptions);

Worksheet ws = wb.Worksheets[0];

cell = ws.Cells[1, 0];
Console.WriteLine(cell.Value.ToString());

2

Hi,

Thanks for your posting and using Aspose.Cells.

Please download and try the latest version:
Aspose.Cells
for .NET v7.3.0.6. It will fix this issue.

Let us know your feedback.

3

That seems to fix the issue.

Will this fix be included in the next release then?

4

Hi,

Thanks for your posting.

Yes, this fix is now included in the latest official release (major version).

Please download and use it:

Aspose.Cells for .NET 7.3.1