Ask Your Question

How to find the sheet name in excel file while reading data from it?

asked 2019-04-25 05:57:41 -0600

Kumar gravatar image

updated 2019-04-25 06:48:04 -0600


I am trying to read *.xlsx file which has multiple sheets with Directory origin. While reading, it is reading all sheets data into a single Json/txt file, So there I am not able to find which data belongs to which sheet. Is there any way to find out the sheet name or group the data by sheet name ?

Thanks in advance.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2019-04-25 10:04:34 -0600

metadaddy gravatar image

The sheet name is in a record header attribute - you can access it with the expression ${record:attribute('worksheet')}.

You can easily see this if you preview the pipeline with Show Record/Field Header enabled:

image description

edit flag offensive delete link more


Thank you so much.

Kumar gravatar imageKumar ( 2019-04-29 00:48:23 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-04-25 05:57:41 -0600

Seen: 868 times

Last updated: Apr 25 '19