Exporting to CSV
Hi, I have a problem with exporting my report to CSV.
Everything seems to work fine, but the problem is that the csv isn't exact csv file. It is created in a wrong way. Visual way rather than data. I mean Excel shows it very similar to my application, but still this isn't csv file.
I hope you know what I mean. My version is 4.7.138. In the earlier ones everything was ok.
For example, I've got 2 columns. My version of FastReport exports it like that
column1;;;;;;;;;;;column2
(because in my report there is a big space between those 2 values)
and it should:
column1;column2
Is there any way to change it?
Everything seems to work fine, but the problem is that the csv isn't exact csv file. It is created in a wrong way. Visual way rather than data. I mean Excel shows it very similar to my application, but still this isn't csv file.
I hope you know what I mean. My version is 4.7.138. In the earlier ones everything was ok.
For example, I've got 2 columns. My version of FastReport exports it like that
column1;;;;;;;;;;;column2
(because in my report there is a big space between those 2 values)
and it should:
column1;column2
Is there any way to change it?
Comments
I have 4.8.7, and I am having problems, too.
My report data do not appear in the correct columns when exported as CSV.
Try exporting a table as a FastReport CSV file, then import it into Excel. Does it look good to you?
Wikipedia has a good article describing the CSV format
Thanks.