|

the software that grows
with you
| |
|
V32Db2Excel()
|
| Opens a .DBF file as an Excel Sheet. |
|
Syntax
|
| V32Db2Excel( <cFileDbf> ) |
|
Arguments
|
| cFileDbf |
Character string to represent database file ( .Dbf )
with full drive and path attributes. |
|
|
Returns
|
| NIL |
|
Description
|
| This function belongs to the family of
Excel functions, such as, V32Brw2Excel(), V32Excel() and V32ExcelScript().
It opens a database file as an Excel sheet through Excel active-x
component.
Note that this function does not delete the file submitted to
Excel neither its format is changed, so can be freely used to view
contents of a database as an Excel sheet.
It is extremely fast.
|
|
Usage
|
| V32Db2Excel( CurDir()+'\vouch32.dbf' ) |
|
Tips
|
| As there was an error in V32Excel()
function when data of type 'Date' is furnished in array submitted to
Excel, this function allows you to create a temporary database from the
array and then submit that database with V32Db2Excel(). |
|