xls to csv conversion

  • Thread starter Thread starter Stanley
  • Start date Start date
S

Stanley

I'm trying to mock a sample csv file that I'm processing. I came
across an online conversion tool that converts excel spreadsheets into
csv files. However, I'm coming across in the converted csv file that I
have 5 commas in the end. Is there anything I can do about that? Does
anyone know why that would be?
 
Stanley,

I suspect that at some point you had data in those five columns. When you
hit the delete button, the contents of the cell are cleared, but Excel still
sees those cells as being in the used range. When your utility exports the
file, it includes everything in the used range, and thus those last five
columns.
The best way is to delete via Alt->E->D. You may even have to save the file
before you run your utility. You should be able to see what the Excel sees
as the used range by selecting cell A1 and then hitting Ctl+End. This will
take you to the last used cell in the worksheet.
Hope this helps...
 
Stanley,

I suspect that at some point you had data in those five columns. When you
hit the delete button, the contents of the cell are cleared, but Excel still
sees those cells as being in the used range. When your utility exports the
file, it includes everything in the used range, and thus those last five
columns.
The best way is to delete via Alt->E->D. You may even have to save the file
before you run your utility. You should be able to see what the Excel sees
as the used range by selecting cell A1 and then hitting Ctl+End. This will
take you to the last used cell in the worksheet.
Hope this helps...
Click to expand...

Hey Chris,

Thanks for your explanation. I've managed to save the file properly in
a separate routine using a macro that saves the spreadsheet in proper
csv format.

Stanley
 
Back
Top