# Excel Reader fail to read file when formula is wrong

**URL:** <https://forum.knime.com/t/excel-reader-fail-to-read-file-when-formula-is-wrong/18727>\
**Category:** KNIME Analytics Platform\
**Created:** [October 11, 2019, 5:28am UTC](https://forum.knime.com/t/excel-reader-fail-to-read-file-when-formula-is-wrong/18727 "2019-10-11T05:28:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![laughsmile](https://forum-cdn.knime.com/user_avatar/forum.knime.com/laughsmile/32/8471_2.png) [@laughsmile](https://forum.knime.com/u/laughsmile)\
**Post date:** [October 11, 2019, 5:28am UTC](https://forum.knime.com/t/excel-reader-fail-to-read-file-when-formula-is-wrong/18727/1 "2019-10-11T05:28:39Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [October 11, 2019, 9:48pm UTC](https://forum.knime.com/t/excel-reader-fail-to-read-file-when-formula-is-wrong/18727/2 "2019-10-11T21:48:04Z")

</div>

There could be several possibilities using R packages like [gdata](https://www.r-bloggers.com/read-excel-files-from-r/) or [openxlsx](https://github.com/awalker89/openxlsx). In addition, there are Python packages (like [openpyxl](https://openpyxl.readthedocs.io/en/stable/)) 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](https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_excel_old_files_import)

---

<div class="post-metadata">

**Author:** ![laughsmile](https://forum-cdn.knime.com/user_avatar/forum.knime.com/laughsmile/32/8471_2.png) [@laughsmile](https://forum.knime.com/u/laughsmile)\
**Post date:** [October 16, 2019, 12:04pm UTC](https://forum.knime.com/t/excel-reader-fail-to-read-file-when-formula-is-wrong/18727/3 "2019-10-16T12:04:12Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [October 23, 2019, 12:04pm UTC](https://forum.knime.com/t/excel-reader-fail-to-read-file-when-formula-is-wrong/18727/4 "2019-10-23T12:04:13Z")

</div>

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