# Reusing Workflow with Excel Reader

**URL:** <https://forum.knime.com/t/reusing-workflow-with-excel-reader/91906>\
**Category:** KNIME Analytics Platform\
**Created:** [May 8, 2026, 2:54pm UTC](https://forum.knime.com/t/reusing-workflow-with-excel-reader/91906 "2026-05-08T14:54:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![temp02\_verizon](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/t/e8c25b/32.png) [@temp02\_verizon](https://forum.knime.com/u/temp02_verizon)\
**Post date:** [May 8, 2026, 2:54pm UTC](https://forum.knime.com/t/reusing-workflow-with-excel-reader/91906/1 "2026-05-08T14:54:53Z")

</div>

I have built several workflows that use an Excel readers. I complete the workflow and everything works as expected. When I receive a new data set, even though the schema on the new file matches the workflow, the workflow rescans the new file and changes all my data types in the Excel reader. (By default I set all columns to string - wish there was a way to set this as a perm default, but thats another topic).

Is there a way to prevent the Excel reader from changing the schema when pointing to a new file?

Thanks for your help…

---

<div class="post-metadata">

**Author:** ![fe145f9fb2a1f6b](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/f/f475e1/32.png) [@fe145f9fb2a1f6b](https://forum.knime.com/u/fe145f9fb2a1f6b)\
**Post date:** [May 8, 2026, 5:47pm UTC](https://forum.knime.com/t/reusing-workflow-with-excel-reader/91906/2 "2026-05-08T17:47:26Z")

</div>

simplest way would be by not opening the Excel Reader and instead supply the path to the Excel files as variable

---

<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:** [May 10, 2026, 6:48am UTC](https://forum.knime.com/t/reusing-workflow-with-excel-reader/91906/3 "2026-05-10T06:48:50Z")

</div>

> [@temp02\_verizon](#):
>
> wish there was a way to set this as a perm default

There have been several ways being suggested to do this.

> [@Excel Reader node - Transform tab - SET all columns to String](https://forum.knime.com/t/excel-reader-node-transform-tab-set-all-columns-to-string/75334/6):
>
> @Felipereis50 I once proposed this solution: Also you could try and force the types later. Using a sample table: Also you could try and use [openpyxl](https://hub.knime.com/search?type=Workflow&tag=openpyxl&sort=best) to [import the file](https://hub.knime.com/-/spaces/-/~gtHNLTIhu-uTNuDa/current-state/) and force strings import pandas as pd # Specify your file path and sheet name file\_path = 'your\_file.xlsx' sheet = 'YourSheetName' # Replace with your sheet name # Read the Excel file, specifying the sheet and forcing all columns to strings df = pd.read\_excel(file\_path, sheet\_name=sheet, dtype=str, engine='openpyxl') …

---

<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:** [August 8, 2026, 6:49am UTC](https://forum.knime.com/t/reusing-workflow-with-excel-reader/91906/4 "2026-08-08T06:49:33Z")

</div>

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