Howdy,
Working with the Excel Writer, I am wondering if there is a way to have a sheet name of 31 characters and a named range of an additional 10-20 characters?
A combined 31 characters does not permit very descriptive naming of sheet names/named ranges, if I'm completely missing something or someone has a suggestion for a work around I'd love to hear it.
Background
The writer’s General Parameters Sheet Name text box is limited to 31 characters, which makes sense since this is the designed maximum length for a sheet name. Reading the FME tutorial "Using a Template File when Writing Excel Data" there is no mention of character limitations.
FME's character limitation becomes an issue when writing to a named range, both the sheet name and named range are entered into the the same text box separated by a "/". Due to this, where the combined total characters exceed 31 the extra is trimmed off (e.g. sheet name & named range of "DataSummary_FMEoutput/tbl_SummaryCalcs" is 38 characters). As mentioned above, this does not permit very descriptive naming of sheet names/named ranges.
Based on a web search it looks like Excel places a 255 character limit on named ranges.
Thank you in advance!
