Skip to main content
parthasarathym6661
parthasarathym6661
December 23, 2024
Question

Get all the sheet names from excel document

  • December 23, 2024
  • 4 replies
  • 0 views

I have to get all the sheet names from the excel document .

4 replies

stefanhelzle0001
stefanhelzle0001
December 23, 2024

I do not know of any direct support for this. But as modern Excel files are just ZIP files, containing XML files, you could unpack it and dig into the XML to find the names.

parthasarathym6661
parthasarathym6661Author
December 23, 2024

yes [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] ,Is there is any function to directly convert the excel file to XML or else do we need to follow any steps for the conversion.

stefanhelzle0001
stefanhelzle0001
December 23, 2024

That's no conversion. The XLSX file is a ZIP with a different extension. It contains a folder structure und XML files.

ranjiths050336
ranjiths050336
December 24, 2024

Hi [mention:0230b2676df9491980744e7e3357c35a:e9ed411860ed4f2ba0265705b8793d05] ,

I have replied workaround for reading the Excel sheet name in another discussion:https://community.appian.com/discussions/f/plug-ins/38207/read-data-from-excel-using-the-sheet-name.

Terms & ConditionsAccessibility statement