Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xls to csv conversion
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
xls to csv conversion
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... -- Chris Farkas Excel/Access Developer http://www.eAlchemy.biz "Stanley" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
xls to csv conversion
On Nov 7, 3:10 am, eAlchemist
wrote: 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... -- Chris Farkas Excel/Access Developerhttp://www.eAlchemy.biz "Stanley" wrote: 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? 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help on conversion | Excel Discussion (Misc queries) | |||
dec 2 bin conversion | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
ESN conversion | Excel Worksheet Functions | |||
RFT conversion | Excel Programming |