Excel Reader fail to read file when formula is wrong

KNIME Analytics Platform
#1

Hi all

I have the following formula in the Excel file,
=IFERROR(INDIRECT(ADDRESS(TnoStartRow),TnoStartColumn....),0,"")
But TnoStartRow and TnoStartColumn are not defined in the Name Manager of Formlua Tab.
So blank cell is shown when opening the Excel file by double click

But when Excel Reader Node opened the Excel file , the following error occurred:
org.apache.poi.ss.formula.FormulaParseException: Specified named range TnoStartRow does not exist in the workbook

The Reevaluate formulas in the Excel Reader node is unchecked , how can I read Excel file by ignoring the formula errors.
BTW: KNIME Version is 3.7.2
Thanks

Ryu

#2

There could be several possibilities using R packages like gdata or openxlsx. In addition, there are Python packages (like openpyxl) that might help with that.

Also maybe you could provide us with a sample Excel file that contains the phenomenon.

https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_excel_old_files_import

1 Like
#3

Hi mlauber71

Thank you very much for your answer.

I found the problem is caused by old Excel, the file read failure is created before 2011 year.
If I create same file content by using latest Excel , everything is OK even formula is not defined.

2 Likes
#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.