"[SOLVED] Reading multiple worksheets from a single Excel file"

dominiciui

Hello All -

How do you load multiple worksheets from a single Excel spreadsheet file whereby the worksheets' attributes differ from each other.

What I found was:

'Loop Files' - ['Read Excel'] (as the nested operator) --> 'Append'

The 'Loop Files' provides me with a directory - do I just move the Excel spreadsheet to it's own folder even though it's a single file?

的读取Excel提供了导入向导- which only allows me to import one sheet.

I appreciate your help!
Dominic

awchisholm

Hello

You could use the Loop operator containing the Read Excel operator. Define an iteration macro in the Loop operator and use it as the sheet number for the Read Excel operator. One gotcha will be the imported cell range which may need to be different for different sheets.

Here's a simple example

regards

Andrew

dominiciui

Andrew -

Thank you very much for your help and code! Problem solved.

Best,
Dominic