ReadExcel file size?

Getting started -basics for starting with WinTask

ReadExcel file size?

Postby Kerm on Fri Dec 12, 2014 11:36 am

I am evaluating x64 version of WinTask and it is very powerful automation software. I am considering to buy it after trial period, however when I have concerns regarding file size. When I am trying to populate web form from excel, ReadExcel method gives an error if excel file contains more that 100 rows.

Error is: TaskExec: index too long (102 > 101).

Does this mean I can't process excel file containing more that 100 rows?
Kerm
 
Posts: 27
Joined: Tue Oct 18, 2005 4:27 pm

Re: ReadExcel file size?

Postby TechSupport on Tue Dec 16, 2014 8:46 am

Hello,

When you use ReadExcel or CaptureHTMLTable wizards, the wizard generates a Dim line at the beginning of the script with a default size of 100 (for example Dim data$(100)).

You can change this 100 value to read more data, for example
Dim data$(1000)
and you can process 1000 values read from an Excel file.

Regards.
WinTask Tech Support
TechSupport
 
Posts: 805
Joined: Thu Nov 16, 2006 9:58 am


Return to Getting started

Who is online

Users browsing this forum: No registered users and 4 guests

cron