Finance | Project Operations, Human Resources, ...

When opening an excel file I get this error: "Object reference not set to an instance of an object"

(0) Share

Report

Posted on by DatWard

after debugging I found this code is what's causing the error,

ExportToExcelFilterTreeBuilder headerFilterBuilder = new ExportToExcelFilterTreeBuilder(resourcestr(PDEImportSheetPicking));

I checked template name all is fine, I refreshed the entities list. nothing helped

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Hi DatWard,

This looks like a custom class. The new method in ExportToExcelFilterTreeBuilder class is looking for the data entity name.

Here you are passing resourcestr(PDEImportSheetPicking). Is PDEImportSheetPicking your data entity name? If so, could try this line of code and check if that resolves your issue?

ExportToExcelFilterTreeBuilder headerFilterBuilder = new ExportToExcelFilterTreeBuilder(tableStr(PDEImportSheetPicking));

Was this reply helpful? Yes No
DatWard 5 on at

Like (0)

Report

Hi Gunjan!

Yes that's staging table of data entity. I tried your code... same error

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Hi DatWard,

In that case, you will need to replace PDEImportSheetPicking with the name of the entity. Assuming the name of the entity is PDEImportSheetPickingEntity, your code will look like this -

ExportToExcelFilterTreeBuilder headerFilterBuilder = new ExportToExcelFilterTreeBuilder(tableStr(PDEImportSheetPickingEntity));

You can check getDocumentFilters method in BudgetPlanLoadAttachment as an example where the entity is passed to the new method of ExportToExcelFilterTreeBuilder class

Was this reply helpful? Yes No
DatWard 5 on at

Like (0)

Report

Hello GunJan. didn't work. although I followed error this is where I get error from

this is exactly where I get this error, could it be those fields?

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi DatWard,

Are you able to open excel from other standard forms in the application?

Was this reply helpful? Yes No
DatWard 5 on at

Like (0)

Report

Hi Gunjan.

Didn't quite understand the question

Was this reply helpful? Yes No
DatWard 5 on at

Like (0)

Report

I think you're right I get this error (from same line) when I'm trying to open this form

The form I'm trying to open:

Was this reply helpful? Yes No