Import Different schema of xlsx.file and maintain the file name of excel file

[SH_94]

Hi Community,

I would like to seek the help on the batch macro to import different schema of xlsx file and maintain the file name of xlsx file at the same time.

May i know if anyone of you have the macro that able to perform the above task? As i try to use batch macro previously and it only able to read one file of the folder. After i render the result , i noted that there are multiple of lines which are created for each row of the data.

Appreciate if someone can guide me on this.

[ArtApa · Accepted solution]

Hi @SH_94 - I can see that your workflow is in 2019.3. I use 2021.1. This may be a problem. Basically, the macros are simple:

1) You read all Sheets and create the appropriate FileNames:

2) You just use the macro from the article that I already shared. Actually, this is the same macro as was in your original macro. You just bring it a level up to the workflow.

[SH_94]

Hi @ArtApa ,

Thank a lot for your help and explanation on this.

Really appreciate it and finally i able to import the data based on your guidance.

Thank you so much.

[SH_94]

Hi @afv2688 ,

Previously, I tried to modify the macro that you provided and notice that i was unable to produce the desired result.

My initial thought was my understanding on the macro concept maybe was not that right. Hence, i had raised the queries in the previous post.

After a few try , i decided to post the problem that i facing instead of trying identify whether mine understanding on the macro concept is right or not.

Thanks a lot to @ArtApa  as i had been trying to analysis and modify the macro for quite some times.

Thanks again @afv2688 and @ArtApa .