Keep Excel Worksheet Default Name Sheet1
I'm formatting an xls report for a vendor with strict requirements. Here's
his note to me:
• The other requirement we currently have is that the worksheet name (tab
at the bottom of the worksheet within Excel) must be the Excel default value
of “Sheet1”. (Your files have the name “Report”.) Our maps and our automated
processes currently require this worksheet name. We are considering how we
remove this restriction in the future, but for now all Excel files must
conform to this requirement.
How do I make this change? If not available in ReportBuilder is there
Delphi Code that can overwrite the name "Report" on the Excel Worksheet?
Thank you.
Jim
his note to me:
• The other requirement we currently have is that the worksheet name (tab
at the bottom of the worksheet within Excel) must be the Excel default value
of “Sheet1”. (Your files have the name “Report”.) Our maps and our automated
processes currently require this worksheet name. We are considering how we
remove this restriction in the future, but for now all Excel files must
conform to this requirement.
How do I make this change? If not available in ReportBuilder is there
Delphi Code that can overwrite the name "Report" on the Excel Worksheet?
Thank you.
Jim
This discussion has been closed.
Comments
support email.
In a future release we will consider adding an XLSSettings.WorksheetName
property. For now the solution requires modifying the source code, for which
I provided details via email.
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com