Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SDETERS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

reading/convertin EXCEL files

Status
Not open for further replies.

nbucska

Electrical
Jun 1, 2000
2,191
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
 
Replies continue below

Recommended for you

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



 
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
 
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"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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

TTFN



 
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor