About the Create Application from Spreadsheet Wizard

You can create an application based on spreadsheet data by selecting Create from Spreadsheet in the Create Application Wizard.

To create an application from spreadsheet data:

1. On the Workspace home page, click the Application Builder icon.

2. Click the Create button.

3. Select Create from Spreadsheet.

4. For Load Method, specify how spreadsheet data will be uploaded. Select one of the following and click Next:

   1. Upload file, comma separated (*.csv) or tab delimited. Specify the following and click Next:

      • Text File - Click Browse to locate the file to be uploaded.

      • Separator - Specify the column separator character. Use \t for tab separators.

      • Optionally Enclosed By - Enter a delimiter character. You can use this character to deliminate the starting and ending boundary of a data value. If you specify a delimiter character, the wizard ignores white space occurring before the starting and ending boundary of a data value. You can also use this option to enclose a data value with the specified delimiter character.

      • File Character Set - Choose the character set in which the text file is encoded.

   2. Copy and paste. Copy and paste the tab delimited data you wish to import.

5. For Table Properties, review how your table will display and click Next. Specify the table name and column names, or modify the data types. To specify whether or not to include a column, make a selection from the Upload list.

6. For User Interface Defaults:

   1. Review the displayed Singular Name and enter a Plural Name.

   2. (Optional) Under Column User Interface Defaults, review the displayed column labels.

   3. Click Next.

7. For Summary Page:

   1. Summary By Column - Select the columns for which data will be summarized in reports and charts and click Next.

   2. Aggregate By Column - Select columns for which values will be aggregated in summary report and click Next.

8. For Application Options, specify the following:

   1. Application Name - Enter an alphanumeric name for this application.

   2. Create Mode:

      • Read and Write includes insert and update pages.

      • Read Only does not include insert and update pages.

   3. Report Implementation - Choose Classic to create a SQL report or Interactive to create an interactive report.

   4. Select a chart type.

   5. Click Next.

9. For User Interface Theme, select a theme and click Next.

   Themes are collections of templates that can be used to define the layout and style of an entire application. See "Managing Themes".

10. Confirm your selections and click Create.