Multiple Excel Sheets Importing

2 posts / 0 new
Last post
jyotikumar
Offline
Joined: 04/08/2022 - 02:37
Multiple Excel Sheets Importing

I have an excel file with more than 20 sheets and the header row is the fifth row. Is there any way to import multiple sheets of a single excel file? Also, can we consider 5th row as my header row?

Brian Element's picture
Brian Element
Online
Joined: 07/11/2012 - 19:57

The import function allows you to import multiple worksheets but the header row has to be on the first row, you can't get around that so you either have to manually delete them would probably be the easiest.  A script could be created to delete the first 5 rows of each sheet but that would be more for an advanced IDEAScript programmer.