XMLPort Import - From Excel with multiple worksheets

halcyon1234
Member Posts: 8
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!
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!
0
Best Answer
-
HI there is One One Solution , this involves Using Dotnet Interoperable Variables,
Anyway How you have Implemented Until Now For Single Worksheet5
Answers
-
HI there is One One Solution , this involves Using Dotnet Interoperable Variables,
Anyway How you have Implemented Until Now For Single Worksheet5
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions