ExcelFormat - Name of Worksheet

Mirko Pepa mirko.pepa at profile.ch
Tue Mar 22 07:57:43 UTC 2022

Hi Kelly

Oh yes, this looks good. I'll give it a try!

Thank You very much!


Am 21.3.22, 14:08 schrieb "omnisdev-en im Auftrag von Kelly Burgess" <omnisdev-en-bounces at lists.omnis-dev.com im Auftrag von kellyb at montana.com>:

    Hi Mirko,

    >I am trying to get the name of a worksheet using Excelformat.dll (xcomp).
    >Does anyone have an Idea, how to find out the name of a worksheet of a given workbook? I do not want to change the name.

    Per the ReadMe.txt file, some newer versions have additional features.  Have a look at workbook.$gettoc(path).

    v3.8.8 has a new book.$gettoc(path) method that returns a list of worksheet names in a given Excel workbook.  There are new sheet.$rowPixHeight(row) and sheet.$colPixWidth(col) methods that return those dimensions in pixels for a given row or column.  And there is an optional sheetIndex parameter added to book.$populateWithList(), to allow inserting data into sheets other than the first one.

    v3.9.4 has four new worksheet properties: $firstFilledRow, $lastFilledRow, $firstFilledCol and $lastFilledCol.  These return columns containing values, ignoring empty columns that only contain formulas.

    Manage your list subscriptions at https://lists.omnis-dev.com
    Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

More information about the omnisdev-en mailing list