45. Excel capabilities in WOW

Excel capabilities in WOW

WOW allows the user to perform the following using Excel spreadsheets:

A) simple download - when you create an Operation, you will have the Excel icon on the left side, above the Operation, that once you click that icon, it will download the page information into an Excel format.

B) export into existing - if you already have an existing format within your Excel spreadsheet, you can export information into that existing spreadsheet so that the formula's that are already set up, will now render the desired results with the new data.

C) web query - you can have a WOW Application that might have some important information in a table of some sort and you can let WOW grab that information from the Application and plug that data into the spreadsheet.

Note:

- Excel (.xls) untill version 2003 has limitation of 65k records in single sheet. That comes out to 65,536 rows per worksheet.

But with version 2007 (.xlsx) and above you can have ~250k records in single sheet. That comes out to 1,048,576 rows.