when I export a file to a CSV Format, I got a problem when an cell has a Comma in the data. Is there a property where I can set Coumns to “Text”-Format?
CSV stands for Comma Separated Values. If your data has a comma in it then the values on either side of the embedded comma become separate values.
Thanks for explanation. I know that, but you can normally put that into Quotes.
If a comma is in the data the application which will import that file will ignore that comma.
I am not clear about your problem. Could you elaborate it?
If a cell has a comma in the text, the result CSV file will add quotes to this string. That’s the routine of CSV format.
> I am not clear about your problem. Could you elaborate it?
In one DataColumn I have data of dbtype nvarchar. Inside this data are commas.
> If a cell has a comma in the text, the result CSV file will add quotes to this
> string. That’s the routine of CSV format.
That should be the way it works…but it doesn’t.
I have to check the datatypes in my DataTable and will try it again.
Do you mean you create a datatable and export the data to an csv file using Aspose.Excel? And you find a string including comma doesn’t work in the result file?
Please try to save the file in excel format and see if it works fine.
> Do you mean you create a datatable and export the data to an csv file using
> Aspose.Excel? And you find a string including comma doesn’t work in the result
That is exact my problem!
Import to an Excel file work.
Could you send me the created CSV file and Excel file with same data? I will check what caused this problem. Thanks.
Sure I will do that.
Right now I#m testing within datatypes and datatable.
ASAP I will create the files.
To which eMail Address you want to have the files?
Any extra subject?
Please send them to
I will contact you if I need extra information.
you can surround each field with double quotes
“Varun.P, Reubro Intl, Kochin”,“Male”,"26"
I hope it will help u