Free Support Forum - aspose.com

Double quotes being enclosed by double quotes while generating CSV

Hi,

We are using Aspose Cell 5.0 to generate CSV files based on an Excel template. This Excel template contains values surrounded by double quotes.

When the CSV file is generated, values which contained double quotes are being again enclosed with double quotes.

Example:
Value found in Excel template is: “First Name"
Value being generated in output CSV file is: “”“First Name””"

Is there any way to avoid this problem of having redundant double quotes being added to my output CSV ?

Thanks in advance for your reply

Shah

Hi Shah,

We are able to reproduce the issue. The issue has been logged into our Issue Tracking System with ID CELLSNET-19571. We will update you as soon as possible.

Thanks,

Hi Shah,

We have further investigated the issue. It is observed that default behavior of MS Excel is saving string with inverted quotes in to inverted quotes. So, this cannot be avoided.

Thanks,