Excel Excel 2007 CSV Format and blank rows

[Karl427]

Hi
I have an application that exports CSV data in the format something like:

Header1,Header2,Header3

20,30
22,33,1


If I read it into Excel 2003, then save it in CSV format it stays prety much in the same format and I can reinput it into the originating program. If however I read it into Excel 2007 and then save in CSV format it saves as:

Header1,Header2,Header3
,,,
20,30,
22,33,1

Inputing this to the originating program cuses it to error, specifically on the blank (now ,,,) line.

Is there a switch that can modify this behaviour so that 2007 saves CSV files in the same way as 2003?

Many thanks in anticipation.

 

[Waynos_Face]

Can you not just click on the Office icon, then click save-as then click save-as 1997 - 2003???

We do this in my office as i have Vista at home and we still have XP at the Office.

Or we used this

http://www.microsoft.com/downloads/...70-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en

 

[Karl427]

Thanks Waynos, but the output must be a csv file as it needs to be input to another (non-windows) system.

 

[Alex Sasser]

I too have the same issue as Karl427, using Excel 2007. Any other thoughts?

Thanks in advance!

--Alex Sasser

Hi
I have an application that exports CSV data in the format something like:

Header1,Header2,Header3

20,30
22,33,1


If I read it into Excel 2003, then save it in CSV format it stays prety much in the same format and I can reinput it into the originating program. If however I read it into Excel 2007 and then save in CSV format it saves as:

Header1,Header2,Header3
,,,
20,30,
22,33,1

Inputing this to the originating program cuses it to error, specifically on the blank (now ,,,) line.

Is there a switch that can modify this behaviour so that 2007 saves CSV files in the same way as 2003?

Many thanks in anticipation.

 

[bmfb1980]

CSV opens fine with 2007, but 2003 corrupts the data

Hi
I have an application that exports CSV data in the format something like:
Header1,Header2,Header3
(blank line)
20,30
22,33,1

If I read it into Excel 2003, then save it in CSV format it stays prety much in the same format and I can reinput it into the originating program. If however I read it into Excel 2007 and then save in CSV format it saves as:
Header1,Header2,Header3
,,,
20,30,
22,33,1

Inputing this to the originating program cuses it to error, specifically on the blank (now ,,,) line.
Is there a switch that can modify this behaviour so that 2007 saves CSV files in the same way as 2003?

I have the backwards problem... anyone know why this happens? I have a file created as a CSV file from a JAVA application. It opens fine in 2007. BUT If that file is opened in 2003, the data is corrupted (repeating commas are deleted, etc).

Any suggestions?