Excel Buffer - Open XML

Ravi_Prakash_Goyal

Hi,

We are upgrading NAV from version 3.70 to 2013 and I am getting issues in merging Excel Buffer table. As i can understand Excel Buffer is no longer using Automation and now using Open XML dll's. Customer has added some code for cell formatting like Size, Wrap Text, Autofit, Row Height and Column Width etc. I could not find these properties in existing Open XML dll. My question is if we need to create separate dlls to implement these properties or are they readily available somewhere?

Thanks in advance!!

beran

The functionality you request is not supported in Nav 2013. As you define the OpenXml is now used for the Excel buffer functionality. The AL code is using a Nav defined wrapper around OpenXml Sdk. The OpenXml Sdk can be found here http://www.microsoft.com/en-us/download ... px?id=5124. Note version 2.0 OpenXml Sdk is used in Nav 2013 (2.5 is available today). Also note that the SDK provide a Tool, where you can see the generated XML.

You can yourself extend the generated XML document but Microsoft does not support any use of such extended functionality.

If you choose such an approach anyway then note there are a number of fallbacks. The sequence of any XML children is important for the Excel application where as the Openxml Sdk Tool couldn't care less. The first two Fills are empty and gray. The best approach is actually to make a document with the requested behavior then open it in the OpenXml Tool and study.
If you are really keen you can study the OpenXml standard (ECMA-376) http://msdn.microsoft.com/en-us/library ... =office.14).aspx .

Alternatively you can use VSTO - http://msdn.microsoft.com/en-us/office/hh133430.aspx. - after the document has been generated.