# read multiple spreadsheets from one excel file and edit data

**URL:** <https://forum.knime.com/t/read-multiple-spreadsheets-from-one-excel-file-and-edit-data/46316>\
**Category:** KNIME Analytics Platform\
**Created:** [August 24, 2022, 10:18am UTC](https://forum.knime.com/t/read-multiple-spreadsheets-from-one-excel-file-and-edit-data/46316 "2022-08-24T10:18:50Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [August 24, 2022, 10:24am UTC](https://forum.knime.com/t/read-multiple-spreadsheets-from-one-excel-file-and-edit-data/46316/2 "2022-08-24T10:24:16Z")

</div>

@Maya229 welcom eto the KNIME forum.

Maybe you take a look at these sample workflow:

> [@Bulk load of excel sheet with empty worksheet](https://forum.knime.com/t/bulk-load-of-excel-sheet-with-empty-worksheet/43934/2):
>
> @MarekV if you take a look at this example with your files the empty entry is being skipped. You can configure what the reader would consider as a missing entry and skip it if you want. If you still have duplicates you can further elevate them with the [Duplicate Row Filter](https://kni.me/n/SQUECT-F0VhUjdbf) or [advanced techniques](https://forum.knime.com/t/school-of-duplicates-and-how-to-deal-with-them/24164). [kn\_forum\_43934\_excel\_bulk\_import.knwf](https://forum.knime.com/uploads/short-url/bjNdmmGMH8SVfwTTopsduAATlA6.knwf) (51.2 KB)

> [@\[bug or no bug ?\] Excel Reader preconfigured work sheet selection options](https://forum.knime.com/t/bug-or-no-bug-excel-reader-preconfigured-work-sheet-selection-options/38226/7):
>
> @Geo what you could do is force the use of sheet\_selection = “NAME” thru a Flow Variable in case of doubt. Maybe not the most elegant way but shout provide an additional layer of security. And indeed under certain circumstances it seems to revert to the default value. Not able to reproduce it yet in a constant way. But might be worth looking into, @laaaarsi.

---

_[View the full topic](https://forum.knime.com/t/read-multiple-spreadsheets-from-one-excel-file-and-edit-data/46316)._