Jump to content

finding the last line of data in excel file

Recommended Posts

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 !!!

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 :)

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
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...