Please enable JavaScript to view this site.

A-Shell Reference

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