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 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(). |