A ditnet variable has not been instantiated.Attempting to call Microsoft.Dynamics.Nav.OpenXml.Spreedsheet.workbookwriter. AddworkbookWriter in Table Excel Buffer:WriteSheet

(1) Share

Report

Posted on by Unikul Pvt

All responses (4)

Answers (0)

AjayPandey 133 on at

Like (0)

Report

RE: A ditnet variable has not been instantiated.Attempting to call Microsoft.Dynamics.Nav.OpenXml.Spreedsheet.workbookwriter. AddworkbookWriter in Table Excel Buffer:WriteSheet

But new issue is generate when I debug this code mention below is the error.

Can you please help me to solve this issue I engaged in this issue so many days so please help me.

Microsoft Dynamics NAV

---------------------------

Break On Error Message:

A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookWriter.Create failed with this message: Access to the path 'C:

ProgramData

Microsoft

Microsoft Dynamics NAV

90

Server

MicrosoftDynamicsNavServer$DynamicsNAV90

users

default

DESKTOP-UNIKUL1

RAKSHITH UNIKUL

TEMP

__TEMP__958aff79760f43fda6c8ec7a3b1d3cee.tmp.xlsx' is denied.

---------------------------

OK

---------------------------
AjayPandey 133 on at

Like (0)

Report

RE: A ditnet variable has not been instantiated.Attempting to call Microsoft.Dynamics.Nav.OpenXml.Spreedsheet.workbookwriter. AddworkbookWriter in Table Excel Buffer:WriteSheet

Yes This is helpful
Suggested answer

YUN ZHU 73,696 Super User 2024 Season 2 on at

Like (0)

Report

RE: A ditnet variable has not been instantiated.Attempting to call Microsoft.Dynamics.Nav.OpenXml.Spreedsheet.workbookwriter. AddworkbookWriter in Table Excel Buffer:WriteSheet

Hi, hope the following helps.

Thanks.

ZHU
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: A ditnet variable has not been instantiated.Attempting to call Microsoft.Dynamics.Nav.OpenXml.Spreedsheet.workbookwriter. AddworkbookWriter in Table Excel Buffer:WriteSheet

Can you share your code?

You are missing to create the .net variable correctly in our code.