Excel Buffer Create table

l0r3n20l0r3n20 Posts: 1Member
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

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


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

  • krikikriki Posts: 8,737Member, Moderator
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2019: 21 & 22 November 2019, Antwerp (Belgium)
Sign In or Register to comment.