How is Excel Changing CSV File?

[Guest]

Hi folks...

I know this is not a development forum but I need some Excel help...

I am developing a application ("Application Out" we will call it) which
generates a CSV file (Gameplan.csv) from an SQL query. This CSV file is then
being taken in by another application ("Application In" we will call it)
which then uses it as its starting data, but that application is functioning
normally.

If we try to load the CSV straight from my app("Application Out") into the
other application("Application In" ), it will not accept it. But if we open
the CSV in Excel and change nothing (literally open and close it again) we
get the following error/save prompt -

"Gameplan.csv may contain features that are not compatible with CSV (Comma
delimited). Do you want to keep the workbook in this format?"

And we are prompted to save. If you then save this file as "GameplanNew.csv"
for example and then go on to the second application, it will load without
any error what so ever.

I have been experimenting with different encoding types but nothing seems to
be working?

What could Excel be doing that is changing the file?

When I run a binary comparison, the file has significantly changed, so Excel
is changing alot. But when the file is viewed in Excel or notepad, the file
looks identical.

Can anyone offer any thoughts or where I should go to get more help?

Any help would be appeciated.

Many Thanks

 

[Guest]

Open the file with Notepad. the save the file to a new name and see if the
same thing happens. Notepad will remove special characters in the file.

If Notepad doesn't fix the problem then copy and paste a number of rows
(from notepad) so I can t look at the file. It could be something like
changing C/R to line feeds. Removing special characters. Remving spaces.