Import file with several sheets
I have a module where I have a number of line items and two lists as dimension. One as rows and one as page selector. I want to build a function to export all data from that module, edit it in excel and then import the same file again, and hence get the values updated in Anaplan.
Now to the issue: When the file is exported, all the different pages are being exported into different sheets in Excel and I can't figure out how to map the import correct to get the values to update properly since the only place the list item form the dimension is mentioned in the excel file is in cell A1.
Does anyone know how to tackle this? Any help is appreciated!