Writing Excel data

(1) Units in which sheets are written

When writing data into a book file, you can select the target sheet from the following:

Using a fixed value

The name of the sheet is set by a fixed value.

Using a field value

The name of the sheet is determined when data processing is executed.

The sheet data can be written to a single sheet or to multiple sheets, by combining the method for selecting the target sheets with the specification of the target sheet names to best match your purpose.

(2) How to write data in a sheet

The two ways for writing data into a sheet are described below. Writing by units of records and by units of cells can be used together.

Writing by units of records

Data is written in lengthwise on the assumption that a row of a particular range of cells is one record. This is suitable for Excel data that include consecutive data rows and is in a table format.

Writing by units of cells

Data is written directly from the specified cell. This is suitable for Excel data that includes data to be written that is scattered about the file.

(3) Writing using a template

You can quickly create documents for a particular use such as reports by using Excel functions such as formats, formulas, functions, and graphs that are preset in a template file.