Importing reports that vary

Vanessa_21460

Hello All,

I have a process in which we get reports that are in Excel 97-2003 file format after 65536 rows of data the data is input on sheet two of the same file so on and so forth. Depending on the day I can have a file with 3 sheets, the next day it can have 30 sheets. Sheet 1 has a header sheets 2 through XX have the data that needs to be appended to the original sheet with no new headers. I can build a macro but wanting to see if Monarch complete might have a unique way to do this already built in. Anyone have any recommendations on possible solutions?

I would love to have this on the server but am open to any suggestions.

 

------------------------------
Vanessa Tanner
Manager Optimization Services
Gap Inc Store Labs
San Francisco NM
(505) 462-0455
------------------------------

Baba_Majekodunmi_703

Hi @Vanessa Tanner!

My first question is about the actual data source itself. I suspect that the underlying data source is a database of some sort. If this is the case, it would be preferred and ideal to connect directly to the data source via Monarch Complete and Automator.

If you can't connect to the database then you'll have to work with the different excel output files. The Append helper in Monarch complete will automate the work for combining all of the data across the various sheets, but this will need to be done manually for each spreadsheet. Good news is that it will be a fast manual process,  the challenge is how many of these spreadsheets do you get daily?

Does this help?

------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Manassas VA
978-275-9325
------------------------------
"