With the Spreadsheet Import builder, you can import into a model the content of a spreadsheet.
Use this builder when you want to get access to a data store.
This builder imports .ODS
formatted files for OpenDocument and most .XLS
formatted files generated by Microsoft Excel. Once imported into the model, the spreadsheet content is transformed into a schema-typed XML document and stored in a variable for easy manipulation and display using the various page-oriented builders such as the Data Page builder.
This builder is not designed for bulk data handling. Do not use a spreadsheet file as a primary data source. Use this builder for reporting only.
You must add the spreadsheet file to your project before this builder can import it. The project directory in which the spreadsheet file is placed does not matter to the builder. However, the file should be placed under the project WEB-INF subdirectory if the file contains data that you do not want exposed in an uncontrolled way. For example, if the spreadsheet file is placed in a servable content directory, anyone who knows the name and path of the file can download it from the application server with a browser.
Exclamation character in sheet name
An open document spreadsheet (.ODS format) that contains a sheet with a name that has the exclamation character (!) cannot be processed by the either the Spreadsheet Export builder or the Spreadsheet Import builder. Excel Versions Supported
An imported Microsoft Excel workbook must be in the .XLS format and have been created by Microsoft Excel.Rich Text
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.Boolean Formulas
Parent topic: Builder Reference: wpf7
About using the builder call editor: wpf7
Creating an archive: wpf7
Importing an archive file: wpf7