View Single Post
  #1 (permalink)  
Old 08-08-2009, 12:02 PM
newtronsols newtronsols is offline
Junior Member
 
Join Date: Aug 2009
Posts: 2
Default Excel start/end cells

Is there any way to use an excel file without having to provide the start/end cells.

Otherwise I have to rewrite the AA task when the number of rows change and I wanted to run it as an exe.

Unless I use A1, Z9999 and then check for a blank cell at the start of a row.

With .csv you don't have to tell it how many rows of data there are. But AA runs more slowly and it seems to fail when presented with a larger file of only 69 rows of 5 columns data.
Reply With Quote