I have 30 Excel files, and in every file the data starts from B6 Cell (with the heading). How can I import the data in idea properly so that it will pick the data from B6 cell.
jyotikumar
Offline
Last seen: 2 months 3 weeks ago
Joined: 04/08/2022 - 02:37
Right now you will either have to edit the Excel files before the import or after the import to get rid of the extra row and column. If you bring it into IDEA you could then do the editing in IDEA, copy the history to an IDEAScript and then run the IDEAScript on the other 30 excel files.
Also in Passport if you download the utility app there is a utility that will allow you to import the 30 spreadsheets at the same time instead of one at a time.