extracted data in same excel,but new page, with each loop

Discussions and Tech Support related to website data extraction, screen scraping and data mining using iMacros.
Forum rules
iMacros EOL - Attention!

The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.

Thank you again for your business and support.

Sincerely,
The Progress Team

Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
Post Reply
pratiksha27.jain
Posts: 20
Joined: Wed Dec 28, 2016 7:24 am

extracted data in same excel,but new page, with each loop

Post by pratiksha27.jain » Thu Feb 02, 2017 1:02 pm

Browser : Internet explorer 11.0
Os : windows 7 enterprise
I MAcro :11.1.495.5175

---------------

hi,

I am trying to loop my macro code to extract the data from different tabs of a weboage to a csv file.

Is there any way by which i can extract the data of every tab (in every loop) in a new page of the same csv/excel file.

the basic idea is to avoid complications of creating so many files. and saving the data in same file but different tabs.

Perhaps we can't extract data in excel with imacro.

but still looking forward to see a solution to it.

Please help...

Thank you.
chivracq
Posts: 10301
Joined: Sat Apr 13, 2013 1:07 pm
Location: Amsterdam (NL)

Re: extracted data in same excel,but new page, with each loo

Post by chivracq » Thu Feb 02, 2017 4:23 pm

pratiksha27.jain wrote:

Code: Select all

Browser : Internet explorer 11.0
Os : windows 7 enterprise 
I MAcro :11.1.495.5175
---------------

hi,

I am trying to loop my macro code to extract the data from different tabs of a weboage to a csv file.

Is there any way by which i can extract the data of every tab (in every loop) in a new page of the same csv/excel file.

the basic idea is to avoid complications of creating so many files. and saving the data in same file but different tabs.

Perhaps we can't extract data in excel with imacro.

but still looking forward to see a solution to it.

Please help...

Thank you.
Nope, not possible, afaik, that's the "Principle" of a '.CSV' File.
Even from Excel if you try to save a Workbook as '.CSV', I think only the Active Sheet gets saved (or maybe you get several '.CSV' Files, one per Sheet with Data).

I guess you will need to save your Data with iMacros in separate '.CSV' Files and import them manually into your Excel File, but that Process can probably be automated from some VB Macro from within Excel or with VB/VBS.

Or maybe Excel has some Command Line Commands that would allow you to add/convert several '.CSV' Files into one '.XLS' File from a '.BAT' File.

And I guess that can probably be done directly from iMacros with the Enterprise Edition by using the Scripting Interface with some VBS Script that would govern the iMacros Script + the Excel part..., but pfff..., that's a bit "High Level" technically I would think... :oops:
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
Post Reply