reading/convertin EXCEL files

[nbucska]

I have to write a program which extraxts alphanumeric info
from one or more single or multipage EXCEL files and convert them to ASCII format for further processing.

Any help is welcome.


<nbucska@pc33peripherals.com> omit 33 Use subj: ENG-TIPS
Plesae read FAQ240-1032

 

[IRstuff]

not sure I follow. Excel can save to comma delimited format (CSV) files.

The other brute force approach is to copy/paste into Notepad.

TTFN

 

[nbucska]

Comma delimited won't work - the text may contain comma

Tab delimited can't convert multiple pages -- must do manually.

Neither one can convert multiple files


<nbucska@pc33peripherals.com> omit 33 Use subj: ENG-TIPS
Plesae read FAQ240-1032

 

[analogkid2digitalman]

Sounds like a potential application for Excel's internal Visual Basic for Applications programming language. I know it has functions for iterating through "Each Workbook in folder xxx" and "Each Sheet in Workbook" and also funtions to identify each nonblank cell in a sheet.

A google search might even turn up an almost ready made solution.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"It's the questions that drive us"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

[IRstuff]

Then copy/paste is the only approach, wrapped by a VBA macro

TTFN

 

[WHRVSC]

I'm afraid this is a little late, but I just saw your post. Have you tried using the Data/Import External Data/New Database Query. It uses MSQuery to pull the data from a database. It can be setup to use an Excel Database as its source. The Queries can be refreshed either at document open, via a macro or manually. Hope it helps.

 

[ROBERTDION]

i have a programming software that can do the kind of thing you want to do. It's Windev from Pcsoft. It's very easy to manipulate xls files.