Does anyone know of a way to rename the Excel Template Worksheets after generation? Specifically when using the OneWorksheetPerDataRow option? I am producing a Sales per Region by Product Category with each Region being written to it's own worksheet. Ideally I would like to rename the worksheet to the Region Name.
Basically, if the sheet name is Sheet 1 the template creates Sheet 1(1), Sheet 1 (2), Sheet 1 (3).....
Please sign in to leave a comment.