Import Excel error in NAV 2013

chandrurec
Member Posts: 560
Hi all,
I want o import a excel file(.xlsx) directly into NAV. When I create a new file and then try to import I can able to import but when I try to download the customer excel which is also the same xlsc and same template I am getting error as below.
Microsoft Dynamics NAV
This message is for C/AL programmers: A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.Open failed with this message: The spreadsheet is corrupted. The following error occurred: The attribute 'verticalDpi' has invalid value '0'. The MinInclusive constraint failed. The value must be greater than or equal to 1..
OK
any idea whats the cause of this error and how to overcome it.
thanks in advance.
Regards,
chandru.
I want o import a excel file(.xlsx) directly into NAV. When I create a new file and then try to import I can able to import but when I try to download the customer excel which is also the same xlsc and same template I am getting error as below.
Microsoft Dynamics NAV
This message is for C/AL programmers: A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.Open failed with this message: The spreadsheet is corrupted. The following error occurred: The attribute 'verticalDpi' has invalid value '0'. The MinInclusive constraint failed. The value must be greater than or equal to 1..
OK
any idea whats the cause of this error and how to overcome it.
thanks in advance.
Regards,
chandru.
0
Comments
-
When you create the file are you just creating an excel sheet & saving it?
or are you exporting it using an xml port like it appears your customer is?
if your creating it differently then perhaps there is an issue with their xmlport.
Also are you both using the same excel versions?
trying to narrow down the cause of the error0 -
Just noticed a similar Platform fix released by Microsoft
https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;en-us;2862723
348976 "A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.Open failed with this message: The spreadsheet is corrupted. The following error occurred: The 'shapeId' attribute is not declared" error message when you import a budget with a comment from Microsoft Excel 20130 -
Hi Savatage ,
I am just saving the excel file and not exporting using xml port.
and both the excel version are same.
Thanks & Regards,
chandru.0 -
after open the sheet
press ok.
I have another error that said OpenXML.Spreadheet.celldata
how to solve this?0 -
I faced the similar problem.
Try to create new excel document and copy content of the broken document to the new one.
It was helpful in my case.Oleg Dovgalenko0 -
Although this is a very old topic, I'd like to give it a kick.
I'm trying to use the Excel Buffer to import/update items into NAV 2013 (build 38454, so after the hotfix mentioned above).
The report runs fine and imports everything perfectly, but only after I open the Excel-file, copy all the contents and paste them into a new file, then save it and run the report.
Although this is keeping things in working order at the moment, the file is a daily export from SAP (from a sister company), and the report runs in the jobqueue (but crashes on the error if we don't "fix" the Excel first).
Google just keeps giving me this topic and some openXML implementation documents - does anybody know what's wrong in NAV? or is it in the Excel-file? and in the last case, what is the problem? I'm hoping to create a script or tool that fixes the excel-file automatically...0 -
Hi frisch and all users
did you find the solution?
im experiencing the same error, with nav 2013. while importing from excel.
Thanks to all
ps Related error:
Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.Open The attribute 'verticalDpi' has invalid value '0'. The MinInclusive constraint failed. The value must be greater than or equal to 1..
0 -
the table having field Item No, Qty and remarks . while doing the import , If any Error comes in validation. the remarks field should fill error Text. can u please guide how to achieve this requirement.0
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