Sign in to follow this  
Followers 0
roofninja

finding the last line of data in excel file

3 posts in this topic

I am having trouble finding the last line of an excel file that has data on it. I have searched the help files and forum topics, but can't find what I am looking for.

I can read my file into an array. I think I can strip out the spacer. I know how to write an excel cell, but I can't find a way to not over write my current data in the file.


RUN . . . Slide . . . TAG . . . Your out . . . PAINTBALL !!!

Share this post


Link to post
Share on other sites



Quote from help: _ExcelReadSheetToArray -> Remarks

Returned array has row count in [0][0] and column count in [0][1].

Except for the counts above, row 0 and col 0 of the returned array are empty, as actual

cell data starts at [1][1] to match R1C1 numbers.

By default the entire sheet is returned.

If the sheet is empty [0][0] and [0][1] both = 0.


SNMP_UDF ... for SNMPv1 and v2c so far, GetBulk and a new example script

wannabe "Unbeatable" Tic-Tac-Toe

Paper-Scissor-Rock ... try to beat it anyway :)

Share this post


Link to post
Share on other sites

Thanks that was it. I can now finish the program. I think it was the last peace of the puzzle.


RUN . . . Slide . . . TAG . . . Your out . . . PAINTBALL !!!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0