xls to csv conversion
  Home FAQ Contact Sign in
microsoft.public.excel.programming only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... programming Profile…
 Up
xls to csv conversion         


Author: Stanley
Date: Nov 7, 2007 00:25

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 Comments
RE: xls to csv conversion         


Author: eAlchemist
Date: Nov 7, 2007 03:10

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:
Show full article (1.03Kb)
no comments
Re: xls to csv conversion         


Author: Stanley
Date: Nov 11, 2007 23:35

On Nov 7, 3:10 am, eAlchemist discussions.microsoft.com>
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: ...
Show full article (1.31Kb)
no comments