LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

Get list of sheet names in Excel file

  • 1.  Get list of sheet names in Excel file

    Employee
    Posted 09-07-2016 12:05

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mlam

    Is there an "easy" way to get a list of the sheet names/ number of sheets in an Excel workbook where data doesn't start in cell A1?
    I would normally use the MetadataOutputPin but this doesn't work when there are worksheets where the data does not start in cell A1.
    I can see that there are ways to do this in Java or using Python package but looking to see if anyone has already got a way around this. Thanks.