I've found that when providing an excel worksheet name via the initiator for the feature reader transformer, it can't find a sheet that has spaces in its name i.e. 'as at 30Nov20', but it can find the same sheet if I rename 'as_at_30Nov20'.

Is there some setting that needs changed?

Page 1 / 1

Because of the spaces, you need to put the sheet name between quotation marks. So instead of

as at 30Nov20

you have to use

"as at 30Nov20"

2021-05-12_07h21_02

@garyhk Thanks for raising this issue. @nielsgerrits has given you a workaround, but this is something we'll try and fix in a future release.

Thanks for the replies especially @nielsgerrits. Using a stringconcatenator to add double quotes has fixed the issue for me.

Sign up