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?

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,649 Super User 2025 Season 2 on at

Like (0)

Report

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

1 people found this reply helpful.

Was this reply helpful? Yes No
Dipika 15 on at

Like (0)

Report

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

Thanks

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

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.

Was this reply helpful? Yes No