Except for Fn’LibXL’CreateBook, which returns a handle to an instance of the Book class, all the other functions take a Book handle. (However, if the handle is not specified, it defaults to the current workbook, so in the typical single workbook situation, you can effectively ignore the workbook handle and just let the libxl.bsi class wrapper handle it.)
Function / Procedure |
Description |
---|---|
Fn'LibXL'CreateBook |
Create an instance of the Book class |
Fn'LibXL'LoadBook |
Load workbook from file |
Fn'LibXL'SaveBook |
Save workbook to file |
Fn'LibXL'AddSheet |
Add a sheet to workbook |
Fn'LibXL'DelSheet |
Delete sheet from workbook |
Fn'LibXL'InsertSheet |
Insert a sheet |
Fn'LibXL'GetSheet |
Return handle to sheet by index # |
Fn'LibXL'GetActiveSheet |
Return handle to active sheet |
LibXL'SetActiveSheet |
Set active sheet |
Fn'LibXL'AddFormat |
Add a format instance to the workbook |
Fn'LibXL'GetFormatCount |
Return number of formats defined |
Fn'LibXL'GetFormat |
Return handle to format by index # |
Fn'LibXL'AddCustomNumFmt |
Add a custom format |
Fn'LibXL'GetCustomNumFmt$ |
Return format handle for custom format by index # |
Fn'LibXL'AddFont |
Add a font instance to the workbook |
Fn'LibXL'GetFontCount |
Return number of font instances in workbook |
Fn'LibXL'GetFont |
Return font handle by index # |
Fn'LibXL'GetDefaultFont$ |
Return attributes of default font (name, size, …) |
LibXL'SetDefaultFont |
Establish default font |
Fn'LibXL'DatePack |
Pack separate date/time fields into internal date format |
Fn'LibXL'DateUnpack |
Unpack internal date format into separated date/time fields |
Fn'LibXL'AddPicture |
Add a picture to the workbook |
Fn'LibXL'GetPictureCount |
Return count of pictures in the workbook |
Fn'LibXL'GetErrorMessage$ |
Get message associated with error # |
Fn'LibXL'GetBiffVersion |
Get BIFF version of binary XLS file |
Fn'LibXL'GetRC1RefMode |
Return TRUE if R1C1 reference mode set |
LibXL'SetR1C1RefMode |
Set or reset R1C1 reference mode |