Skip to main content
parthasarathym6661
Inspiring
Dec 23, 2024 10:15 AM UTC
Question

Get all the sheet names from excel document

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

4 replies

stefanhelzle0001
Brainy
Dec 23, 2024 10:54 AM UTC

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
Inspiring
Dec 23, 2024 11:31 AM UTC

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
Brainy
Dec 23, 2024 12:50 PM UTC

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

ranjiths050336
Inspiring
Dec 24, 2024 7:41 AM UTC

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.