×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

reading/convertin EXCEL files

reading/convertin EXCEL files

reading/convertin EXCEL files

(OP)
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

RE: reading/convertin EXCEL files

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



RE: reading/convertin EXCEL files

(OP)
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

RE: reading/convertin EXCEL files

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

RE: reading/convertin EXCEL files

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

TTFN



RE: reading/convertin EXCEL files

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.

RE: reading/convertin EXCEL files

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources