02-19-2007 07:22 PM
Hi Joe,
What I am trying to do is decypher Michael notation.
For the time being (and probably permanently ) I will write a field to the sheet that records the last row that has data. I can read that fast enough.
What I am trying to do is open an arbitrary spreadsheet and figure out where (which row) the next line of log file that should be updated.
Ben
02-20-2007 02:15 AM
04-19-2007 05:03 PM
When appending data to an existing Excel file, here are three VIs I use to find where the current block of data ends. Both the End(xlDown) and UsedRange options can return the location of the last row, but the UsedRange does not need a starting point and will ignore blank cells. The Get Next Available Row.vi is the implementation of the VBA code that I described earlier in this post.
Excel Tip: If you look at the diagram of my Get Next Available Row.vi, you will see how it is possible to eliminate the use of the conversion from row and column index to A1 notation.
04-20-2007 08:02 AM
I love it.
Thanks Mike
04-20-2007 08:05 AM
Thank you Michael!
The project I needed that for shipped two months ago but I am sure I will be asked this again.
Ben
10-04-2012 03:30 AM
Hi all,
This is an oldish thread but perhaps someone may pick up on it. The code looks like it calls out what it is referring to as Worksheets. Is this the separate sheets within an Excel Workbook or when you say Worksheets, do you mean the entire Workbook?
10-04-2012 05:36 AM
That means the worksheet within the workbook.