A DotNet variable has not been instantiated. Attempting to call Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.HasWorksheet in Table Excel Buffer: SetActiveReaderSheet

(0) Share

Report

Posted on by Dipika

Getting this error while trying to import GST Rates from excel by using Import From Excel Action on Business Central (Cloud) version. I'm able to use the same action OnPrem successfully. How should I go about solving this issue?

All responses (5)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

RE: A DotNet variable has not been instantiated. Attempting to call Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.HasWorksheet in Table Excel Buffer: SetActiveReaderSheet

Hello,

This cannot be done in SaaS release. You may want to explore other alternatives. Please ask your partner or CSP or developer for assistance.

Thank you.
Dipika 15 on at

Like (0)

Report

RE: A DotNet variable has not been instantiated. Attempting to call Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.HasWorksheet in Table Excel Buffer: SetActiveReaderSheet

I'm using Business Central IN version. And trying to import GST rates via Import from excel action on GST rates page.

Thanks
Suggested answer

YUN ZHU 78,032 Super User 2025 Season 1 on at

Like (0)

Report

RE: A DotNet variable has not been instantiated. Attempting to call Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.HasWorksheet in Table Excel Buffer: SetActiveReaderSheet

Hi, The development methods of On-Pre and SaaS are different.

If you are on Cloud, I hope the following example can give you some hints.

How to use Excel Buffer to Import data

https://yzhums.com/4223/

Thanks.

ZHU
Suggested answer

Inge M. Bruvik 997 Moderator on at

Like (0)

Report

RE: A DotNet variable has not been instantiated. Attempting to call Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.HasWorksheet in Table Excel Buffer: SetActiveReaderSheet

Can you share your code?

If you are using .net variables in your on-prem code then you need to change that because you can not use .net variables in the cloud.
Suggested answer

Nitin Verma 21,317 Moderator on at

Like (0)

Report

RE: A DotNet variable has not been instantiated. Attempting to call Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.HasWorksheet in Table Excel Buffer: SetActiveReaderSheet

Hi,

I am not sure from where you are using "Import from Excel" action. Also if you are using customization you need to check that one.

Thanks.