|
-
Dec 13th, 2006, 11:48 PM
#1
Thread Starter
Frenzied Member
Read Excel in Known Format
Hi,
I want to create something that open and read an excel spreadsheet (that part seems easy).
Also to read in the 5 different sheets that should be present is easy.
I know in advance how many columns I will be looking at, and what to expect in each column.
I just dont know know how many rows there will be...first blank one will be the end.
Some code i tired keep running for 65,000 rows.....messing performance up completely.
So simply want some thing that let me read the value in columns say A - X in each row, until column a's value in a certain row is nothing.
I can write it myself if playing around I guess, but really out of time, and the person I hoped was going to do this project (from VBF!!!) seems to have disapeared.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|