the software that grows
with you
|
V32Brw2Excel() |
||||
| Displays a browser's contents as an Excel Sheet. | ||||
|
Syntax |
||||
| V32Bew2Excel( <oBrw>, [cPath] ) | ||||
|
Arguments |
||||
|
||||
|
Returns |
||||
| NIL | ||||
|
Description |
||||
| V32Brw2Excel() sends the
contents of <oBrw> to MS Excel. Excel is invoked and columns and
rows appear as cells of the current sheet. Column headings of <oBrw>
becoms the column headings of the Excel sheet. This function exploits the
inherent strength of TBrowse() class. Brwoser's column block is used to
retrieve the data. The columns in Excel appear exactly in the same order
as these appear in <oBrw>.
There is no size limit to send data, but large browsers may take some time. V32Brw2Excel() moves the browser from top to bottom. User can press <ESC> anytime to interrupt the operation. But please note that <ESC> only causes to stop more data to be submitted to Excel. Whatever data has been sent by the <oBrw> prior to pressing <ESC> will still appear in the Excel sheet. To use this function you need to MS Office installed on your system. Any version will do, though it has been tested for 97-2000-XP versions. |
||||
|
Usage |
||||
| Please see how a browser's stabilization loop can be confgured to use this function in V32Brw2Graph() function in this reference. | ||||
|
Tips |
||||
| 'Vouch', my flagship product
expresses every report in a browser form. I have configured a key ALT_F10
to submit the browser in question to MS Excel. My clients are using this
feature whenever they need to transmit data in a commonly acceptable
format to their customers, vendors, bankers, etc.
I feel that this utility alone will prove this library worth its cause. |