Import Excel error in NAV 2013

chandrurec

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.

Savatage

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 error

mohana_cse06

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 2013

chandrurec

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.

casanova

after open the sheet
press ok.
I have another error that said OpenXML.Spreadheet.celldata
how to solve this?

casanova

casanova wrote:

after open the sheet
press ok.
I have another error that said OpenXML.Spreadheet.celldata
how to solve this?

anybody can help?

Solmyr

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.

frisch

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...

CarlesTA

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..

rosietesmen

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.