Goodmorning,
i have to fill an excel template with data taken from Nav 2015.
The sheets in the excel contain a table with a formula.
![pk993o4taj7i.png](https://us.v-cdn.net/5022383/uploads/editor/ce/pk993o4taj7i.png)
i try to insert a new record but the excel buffer(T 370) it's not able to insert a new row with a formula for each record.
i used the funtion TempExcelBuffer.CreateRange('A2:B100') but this not work.
![573h556q99sm.png](https://us.v-cdn.net/5022383/uploads/editor/j6/573h556q99sm.png)
I also see the function createtable using the DotNet Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorksheetTableWriter.'Microsoft.Dynamics.Nav.OpenXml, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'
but i can't find any documentation.
thanks
Answers
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!