Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
If I have multiple tables on one web page in same format with same dimensions, then how can I load them all in one go? There is no option to load all tables in one go from one web page in Script Editor>Web Files.
BR,
SAK
You mean you don't want to multiply loading script for each table (becouse there might be dozen ot tables)? Am I right?
Yep! There are dozens of table and will keep increasing every week. So I want one single code to load all tables on ONE web page with a single script. The solution may be to loop for number of tables, if possible, or something else. I am new and dont know how to do it. I searched also but could not get any such thing.
SAK
what is this page adress?
Saved on disk.
Since its secured (two factor authenticated session) and very short period session to bank online secured system. I save the pages. There is no other option in bank online system to get report in excel/csv format. This file can be opened with excel and comes up with very good formatting. But I do not want as manager/GM will not rely excel data that it can be altered.
BR,
SAK
is the list of tables constans?
for i=5 to 96
LOAD Balance,
Credit,
Debit,
Description,
Date
FROM
[file:///C:/Users/pari.PariPari_vaio/Downloads/March%20to%20Oct%202012.htm]
(html, codepage is 1250, embedded labels, table is @$(i));
i=i+3
next i;
Tables will keep adding up. I noted that it starts from 5th table and then every 4th table is the data I need. This way one table should be 97th but Table 97 not found, and then needed data is on 98th table.