INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Member Login

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips now!

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!

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

LINK TO THIS FORUM!

Eng-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I always seem to find what I need in previous threads without starting my own. I have started a couple but that's it..."

More...

Geography

Where in the world do Eng-Tips members come from?

Click Here To Find Out!

Eng-Tips Shirts!

Get your
Eng-Tips Forums
SWAG here!

Home > Forums > Computer Engineers > Activities > Computer engineering other topics Forum

reading/convertin EXCEL files

Read More Threads Like This One

nbucska (Electrical)

22 Feb 06 11:57

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

22 Feb 06 12:01

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

22 Feb 06 12:51

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

22 Feb 06 13:16

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

22 Feb 06 13:29

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

TTFN

WHRVSC (Marine/Ocean)

7 Jul 06 11:40

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

23 Aug 06 10:05

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.

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!

Back To Forum

Back To Computer engineering other topics