I have an Excel file with 30 columns, of which, the last 10 have no data. When saving to .csv file, the first 17 rows have commas to show the blank 10 columns, but all rows after that do not pick up the commas. Any ideas why not?
I have an Excel file with 30 columns, of which, the last 10 have no data. When saving to .csv file, the first 17 rows have commas to show the blank 10 columns, but all rows after that do not pick up the commas. Any ideas why not?
Excel is a little too relaxed in it's version of csv files.
Only way to force the comma field holders is to include a dummy field or last record. Which ever you choose it must have some data in order to make excel output commas for all empty trailing fields.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks