How to specify data range

This section describes the detailed operations on how to specify the data range in the "Create app from Excel file" function.

The method of specifying the data range differs depending on the type selected in the "Select Input Format screen".

Attention

This page explains how to specify the data range for "List", "List with Header", and "Single form".

If you select the cross table, please see Operation explanation by screen (cross table) βversion.

How to specify [List]

When you select List Table, "Table" will appear in the Specify Data Range dialog.

In a list table, you need to specify the title line of the "Table".

• Table settings

1. Click "Select the title row" in the Specify Data Range dialog.

2. Select a cell in the title row of the table, and click the "Set" button.

3. The Label Settings dialog box will open. If you are satisfied with the contents, click the "OK" button.

Tip

The default setting for the label name is a value that is used as a candidate for the label name.

If the item is labeled "<No label>" or you want to change the name to something else, please set the label name yourself.

Attention

Make sure that the range displayed in the input section is the range for entering data in the table.

4. The selected data range will be registered. If there are no problems, close this dialog and proceed to the next screen.

Attention

If there are any columns in the table that you do not want to be inputted, such as formula columns, click the trash icon to delete them.

Tip

If you want to change the label name of a registered item, click on the edit icon and rename it.

How to specify [List with Header]

If you select List with Header, the Specify Data Range dialog will display the "Table" tab and the "Header" tab.

In a list table with headers, you need to specify the title line of the "Table" and set the data position of the "Header".

• Table settings

1. Click the "Table" tab in the Specify Data Range dialog.

2. Click on "Select the title row".

3. Select a cell in the title row of the table, and click the "Set" button.

4. The Set Label dialog box will open. Check the label names in the table, and if there is no problem, click the "OK" button.

Tip

The default setting for the label name is a value that is used as a candidate for the label name.

If the item is labeled "<No label>" or you want to change the name to something else, please set the label name yourself.

Attention

Make sure that the range displayed in the input section is the range for entering data in the table.

5. The selected data range will be registered. When you have finished setting up the "Table" and "Header", close this dialog and proceed to the next screen.

Attention

If there are any columns in the table that you do not want to be inputted, such as formula columns, click the trash icon to delete them.

Tip

If you want to change the label name of a registered item, click on the edit icon and rename it.

• Header settings

1. Click on the "Header" tab in the Specify Data Range dialog.

2. Click "Select input cell".

3. Select the header information cell of the table and click the "Set" button.

Hint

Header information is the data that you want to manage by "Person in charge", "Store", "Department", etc. when multiple tables exist.

Tip

You can select multiple cells by holding down the Ctrl key while selecting cells, such as "A1,B1".

If you have a lot of cells to select, you may want to do this several times.

4. The Label Settings dialog box will open. Check the label name, and if there is no problem, click the "OK" button.

5. When you have finished registering the "Table" and "Header", close this dialog and proceed to the next screen.

How to specify [Single form]

When you select a single form, the "Header" tab and "Table" tab will appear in the Specify Data Range dialog.

For a single form, it is necessary to set the data position of the "Header".

The table setting should be specified if the table exists in the sheet.

• Header settings

1. Click on the "Header" tab in the Specify Data Range dialog.

2. Click "Select input cell".

3. Select the data entry cell and click the "Set" button.

Tip

You can select multiple cells by holding down the Ctrl key while selecting cells, such as "A1,B1".

If you have a lot of cells to select, you may want to do this several times.

4. The Label Settings dialog box will open. Check the label name, and if there is no problem, click the "OK" button.

Tip

The default setting for the label name is a value that is used as a candidate for the label name.

If the item is labeled "<No label>" or you want to change the name to something else, please set the label name yourself.

5. When the registration of the "Header" is complete, close this dialog and proceed to the next screen.

Attention

If there is a table data area in the sheet, set the table settings as well.

• Table settings

1. Click the "Table (Optional)" tab in the Specify Data Range dialog.

2. Click "Select the input range".

3. Select the data input range of the table, and click the "Set" button.

4. The Label Settings dialog box will open. Check the label name, and if there is no problem, click the "OK" button.

5. When you have completed the registration of "Table (Optional)" and "Header", close this dialog and proceed to the next screen.

Attention

If there are any columns in the table that you do not want to be inputted, such as formula columns, click the trash icon to delete them.