Ask Your Question
1

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

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

Kumar gravatar image

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

Hi

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
1

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

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

Comments

Thank you so much.

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

Question Tools

1 follower

Stats

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

Seen: 97 times

Last updated: Apr 25