You’re offline. This is a read only version of the page.
Announcements
Hi Experts,
Can anyone help me with sample code which would read entire excel workbook (as it is all sheets in workbook i cannot use dixif) from a particular network drive path on periodic basis & populate data into ax table.
I think SysExcel class wont work as that will work at client level only.
Thank
Mav
Don't try to solve all problem at once. Let's focus on reading the file for now and if you don't know how to work with AX tables, let's address that later.
Does it mean that you rejected both transforming the file and using ExcelPackage to import the file? Then you can surely find some other libraries, but you should explain why you rejected this one, so we can suggest something more suitable for you.
Or does it mean that you don't know how to use ExcelPackage and you simply gave up? Do you have any particular problem? Did you look at examples on the internet?
Then you would need multiple projects.
I personally wouldn't do it, though. Having an extra step transforming the file to something that you can easily import sounds much easier to me.
If you know how to import a single worksheet (and how you select which one), what is preventing your from importing multiple worksheets one by one?
Yes another approach would be transforming the file before importing.
My 1st preference is DIxif & hence wanted to check if you can pls elaborate on
"I think you could also process the file with DIXF, just not at once, but a single worksheet at a time."
Scenario
1 excel workfbook - multiple sheets all of this data to go into 1 single custom entity in Ax2012 via batch job i.e. minimum user intervention.
You can use ExcelPackage class from OfficeOpenXml namespace. You can find plenty of examples on the internet; some of them are even for AX 2012.
I think you could also process the file with DIXF, just not at once, but a single worksheet at a time.
#1
André Arnaud de Cal...
293,289
Super User 2025 Season 1
#2
Martin Dráb
232,068
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
