Add Worksheet Names Before Export to Excel

When reports are exported to Excel, the worksheet names are derived from the list frame names specified in Impromptu. A number is appended to the name to ensure uniqueness. For example, Countries changes to Countries_1. The name is also truncated to 27 characters, if required, so that a number from _1 to _999 can be appended without exceeding the 31 character limit for Excel worksheet names.

We recommend that you change the default list frame names to something more meaningful to improve usability.

Steps

1. Right-click the list frame, and click Properties.

2. In the Name box, type a meaningful name, and click OK.

Worksheet Names and Scoped Data

If data is scoped , the worksheet name is based on how the data is scoped. If the data is scoped by data group, the worksheet name is based on the data groupings. For example, if data is grouped by product, the worksheet names use the product names, and the product name Star Lite can generate the worksheet name Star_Lite_1. If the report contains a form frame with two list frames with scoped data, the worksheet names appear as Star_Lite_1, Star_Lite_2, Star_Dome_3, and Star_Dome_4.

If data is scoped by row, the name is based on the row number. The worksheet name is created by appending a number to the row name. For example, the worksheet name for row 1 becomes row1_1. If the report contains a form frame with two list frames, the worksheet names appear as row1_1, row1_2, row2_3, row2_4, and so on.