Please enable JavaScript to view this site.

A-Shell 6.5 Development Notes

LIBXL.BSI [131] includes several fixes, refinements, and enhancements:

Increase the stack size (needed for libxl.dll 3.8.5+)
Support changes to the calling signatures of some existing functions.
Add sheet parameter default to definition of several Sheet-related functions so it can be omitted in case of a single sheet workbook.
Add tempfile$ parameter to LoadBook and SaveBook function (may reduce memory requirements for very large files).
Add optional sheetindex, firstrow and lastrow params to the LoadBook() function to allow loading a partial file
Add SheetSetTabColor()
Add lastrow option to SheetSetRow() to operate on a range of rows.
Add password and enhanced options to SheetSetProtect()
Add NamedRange functions
Add option to GetColWidth() and GetRowHeight() to return size in pixels.
Fix problems with the fit-to-cell scaling option in SheetSetPicture() and SheetSetPicture2().