Spreadsheet Import builder inputsAdded by IBM on June 28, 2011 | Version 1 (Original)
|This topic describes the inputs for the Spreadsheet Import builder.
This topic describes the inputs for the Spreadsheet Import builder.
Table 1. General inputs
|Name||Required. Enter a name for this builder call. The WebSphere® Portlet Factory Designer displays this name in the builder call list.|
|File to Import||Required. Use the picker to locate a spreadsheet file that has been added to the project. The file must be in a supported format (.ODS or .XLS).|
Note: Spreadsheets that contain rich text cells (those that have multiple fonts and styles) are not supported. Any attempt to import a spreadsheet that has rich text cells throws a runtime exception.
|Generate Schema||Required. You can select the creation of schema in a variety of ways. You can choose: |
On Designer Regen
To create the schema every time the model is regenerated within IBM® WebSphere Portlet Factory Designer.On Every Regen
To create the schema every time the model is generated within WebSphere Portlet Factory Designer and IBM WebSphere Application Server.Only When Builder Changes Are Detected
To create the schema and preserve it (unchanged) on subsequent model generations. If a subsequent change is made to any of this builder input, a new schema will be generated.
|Content Selection Method||Required. You can select the Workbook content to import in a variety of ways. You can choose: |
Automatic (let builder find content)
Bounded (specify a range of cells)
To let the builder determine the content to import. The builder will select all of the cells in the smallest rectangular range that includes all of the defined content from the chosen sheet.
Note: This content may include cells that contain formatting but otherwise are blank.
Requires you to manually enter the range of cells that contains the content you want to import. The range is given by the Upper Left Cell and Lower Right Cell inputs. For example: A1-H99.By Range (use a named range from the workbook)
To import the content of a named range of spreadsheet cells. If no named ranges are defined for the spreadsheet, this input cannot be used to select spreadsheet content.
|Sheet||Use this input to select the workbook sheet that contains the content you want to import. All of the sheets defined in the workbook are available for selection. |
Example: Sheet 2
|Range|| Available when By Range is the Content Selection Method above. |
Select the named Workbook range that represents the data you want to import.
|Upper Left Cell||Available when Bounded is the Content Selection Method above. |
Enter the coordinates of the cell that represents the upper left boundary of the rectangular cell range you wish to import. This input can be left blank to have the builder automatically find the upper left cell.
|Lower Right Cell||Available when Bounded is the Content Selection Method above. |
Enter the coordinates of the cell that represents the lower right boundary of the rectangular cell range you wish to import. This input can be left blank to have the builder automatically find the lower right cell.
|Has Header Row||This input allows the builder to accommodate a content header row. |
Enable to make the builder use the first row in the selected cell range as the header row. Such a row might contain column labels or other text notation that identifies the data in the columns.
The header row is used to generate the XML schema element names that describe the data that is imported from the workbook.
|Preserve Empty Rows||This input allows the builder to preserve empty rows when the spreadsheet content is imported into a model as XML. |
By default this builder strips empty rows to provide a compact XML representation of the imported spreadsheet content
Enable this input to preserve empty rows for custom formatting of the content.
Note: Imported spreadsheet content with empty rows will appear differently on a page depending upon the HTML formatting applied to the page location where the content is displayed. In some cases empty rows might have a negligible height and be difficult to see.
|Preserve Cell Formatting||Enabling this checkbox causes the builder to keep the cell formatting when content is fetched from the spreadsheet.|
Example: When you apply formats such as "Currency", a cell value such as "12" appears as "$12". The Preserve Cell Formatting input allows you to decide whether to display the cell value "12" as simply "12" or "$12" in the imported XML.
Note: This input has no effect on cell color, font, or formula settings.
The inputs in this group specify the sample data that the builder uses to determine the schema for the data that is to be imported at runtime.
Table 2. Sample Data inputs
|Sample File||Required. Enter either a relative or absolute path to a spreadsheet file. If the path is relative, the builder assumes the root is the WEB-INF directory of your project. |
|Sample Sheet||Required. Enter the workbook sheet that contains the content. |
Parent topic: Spreadsheet Import builder