KNIME Community Forum

Reading Excel sheets in loop and writting in DB is failing

KNIME Analytics Platform

ScottF Closed May 16, 2022, 3:33pm 4

Read multiple sheets from excel and insert into DB- 4.5.1 KNIME Analytics Platform

Hi , I am trying to read multiple sheets in a single excel workbook and insert into DB but i am not able to read it. Its currently reading same sheet for multiple times (which is same as number of sheets i have ) so same row is coming [Design _issue] for 6 times but only from first sheet. Need your help , previously given solution doesnt work on Version 4.5.1 as “XLS reader” node is obsolete now. Thanks, Raman

show post in topic

Home
Categories
FAQ/Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled