How to restrict Excel worksheet name to 31 char in FSG report
Hi All,
we are generating GL FSG reports using custom FSG templates. We made slight changes to oracle provided templates. In one of the scenario, worksheet name is deriving more than 31 char and hence when we open the output, its a throwing a error message as invalid worksheet name as excel can handle only 31 char as worksheet name. Is there a way to restrict the excel worksheet name to 31 char and if so, what is the code which we need to write in hidden XDO_metadata sheet?
Note:- We are using "Program Publish FSG report" program to generate FSG reports. We are not using Report Manager.