Reading Excel data

a) Reading data in units of individual sheets

To read data of a book file in units of individual sheets, use the following settings:

• If one book file contains only one sheet:

  Use either of the following settings:

  • Select All sheets.

  • Select Specify sheets to read, and then specify the name of a sheet to be read.

• If one book file contains multiple sheets:

  Use either of the following settings:

  • Select Specify sheets to read, and then specify the name of one sheet you want to read.

  • Select Specify sheets to exclude, and then specify the names of multiple sheets that you want to exclude from being read.

    This method is useful when the name of a sheet you want read contains values, such as dates, that vary depending on the operating system environment.

b) Reading data in units of multiple sheets

To read data of a book file in units of multiple sheets, use the following settings:

• Select All sheets.

  All the sheets will be read.

• Select Specify sheets to read, and then specify the names of multiple sheets you want to read.

  This method is useful when you want to read only some of the sheets in a book file. Use a slash (/) to separate the names of sheets to be read.

• Select Specify sheets to exclude, and then specify a name of one sheet or the names of multiple sheets that you want to exclude from being read.

  This method is useful when you want to exclude from being read sheets that contain fixed content, such as a front cover or memos.

a) Reading data in units of records

To read data in units of records, specify a field name of your choice for the field name.

Specify a column letter for the column.

Example: "A"

 

You can combine the following two methods to specify a data range to be read.

• Specify a row from which reading starts

  Data reading starts from the row number specified in the Initial row number field. Data in a table format where the header cell contains information can also be read.

• Specify a row where reading ends

  Specify the position at which the reading ends in the End position field.

  • When the End position field is set as End of data (reading ends at the last row of data)

    The data range to be read ends in a row that is regarded as the last row of the existing data, such as the row where the table line settings end, or the row where data ends.

  • When the End position field is set as Empty record (reading ends at an empty record)

    If a row that consists only of empty cells is found, the row is handled as the end of the range to be read.

  • When the End position field is set as Empty row in a specified column (reading ends at the row with an empty cell at the specified column)

    If a row that consists of an empty cell at the target column is found, the row is handled as the end of the range to be read.

  • When the End position field is set as Specified row (reading ends at the specified row)

    The row specified in the Final row number field is handled as the end of the range to be read.

  • When the End position field is set as Row containing an empty cell (reading ends at a record with an empty cell)

    The data range to be read ends in a row where an empty cell appears in a column of your choice that is specified for a table range.

b) Reading data in units of cells

To read data in units of cells, specify a field name of your choice for the field name.

Specify a column letter and a row number for the cell.

Example: "A1"

 

You can use the following methods to read cells:

• Read a single cell

  Data is read from only a single cell of a sheet. This is a basic method for specifying cells when reading data in units of cells.

• Read multiple cells

  Repeat the procedure for reading a single cell to read data of multiple cells. A method for reading multiple consecutive cells by using a colon (:), which is used to indicate a range of cells, is not supported.

• Read cells with numeric formulas

  If numeric formulas are set to cells, calculation results are read as data.

• Read cells where a calculation error occurred

  If an error value is displayed as a calculation result of a numeric formula, the cell is read as an empty cell. Alternatively, read processing can be abnormally ended as an error.

• Read merged cells

  If cells are merged, data of that merged cells will be read as a value of the top left cell in the merged range. For other cells in the merged range, the default value of the applicable data type is read as data. For example, when reading data of a numerical value, a value "0" will be read.