xls to csv conversion

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?
 
E

eAlchemist

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...
 
S

Stanley

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...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top