XMLPort Import - From Excel with multiple worksheets

halcyon1234

I have a customer who wants to import an Excel through an XMLPort. Easy enough, do it all the time.

But this customer has an Excel with multiple sheets, each sheet has data to import.

My normal reaction would be to tell them to save each sheet as it's own Excel document, and then create one XMLPort for each type of import they want.

But is there any way of setting up an XMLPort to read from multiple sheets in an Excel?

Thanks!

rajavenkat74@gmail.com

HI there is One One Solution , this involves Using Dotnet Interoperable Variables,
Anyway How you have Implemented Until Now For Single Worksheet

rajavenkat74@gmail.com

HI there is One One Solution , this involves Using Dotnet Interoperable Variables,
Anyway How you have Implemented Until Now For Single Worksheet