Creating an Application from a Spreadsheet

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. For Application Type, select Database.

4. Select From Spreadsheet.

5. 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 want to import.

6. 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 to include a column, make a selection from the Upload list.

7. 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.

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:

      • Classic creates a SQL report.

      • Interactive creates an interactive report.

   4. 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.