Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Keep Excel Worksheet Default Name Sheet1

edited February 2012 in General
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

Comments

  • edited February 2012
    This question was also sent to support@ and has been answered via tech
    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
This discussion has been closed.