Export sheet setting information

Here is how to export the sheet settings information.

The exported file will contain cell values, formatting information, and row and column settings.

Therefore, it is possible to compare the exported files before and after the sheet changes to identify the changes and their contents.

It is also possible to search for cells that have a specific formatting.

Attention

Exported files cannot be used for import.

Export sheet setting information

1. Open Application management tab in "Manage" screen.
2. Right click on the sheet and select "Export" -> "Setting information of sheet" menu.

Tip

Sheet setting information can also be exported after multiple sheets are selected. In this case, the sheet setting information for each sheet will be exported as a single file.

3. In the Output of sheet setting information screen, specify the output destination, file format, and output items, and click the Output button.

[1] Output destination

If a single sheet is selected, specify the output file path.

If multiple sheets are selected, specify the output destination folder.

In this case, the setting information for each sheet will be output as a file named "Sheet Information_[sheet name].csv".

[2] Output item name in the first row.

If checked, the item name will be output on the first row of the export file.

[3] Output, so that not the calculation result but the expression is displayed when opened in Excel

If the value in a cell is a formula starting with "=", the formula will be evaluated and the result will be displayed when opened in Excel.

If checked, the formula will be output with an additional "'" at the beginning, and the formula will be displayed even when opened in Excel.

[4] Character encodings for file

Specifies the character encoding of the exported file.

[5] Output items

Specify the contents to be exported. For details on what is output when each item is selected, please refer to "About exported files".

Tip

Select application(s) to export sheet setting information.

If an application is selected, the export will be executed for all sheets contained in the selected application.

When exporting, a folder with the application name is created in the destination folder, and a file named "Sheet information_[sheet name].csv" is output in that folder.

Attention

Depending on the number of cells in the sheet, the number of values input, and the number of formats set, the export may take a long time or may not be possible due to errors.

About exported files

In exporting sheet settings, the data in the rows, columns, and cells that correspond to the following will be output.

[Row and Column]

• The height and width have been changed
• Hidden
• Fixed frame position

[Cell]

• Value is inputted
• Formatting is set
• Merge cells (output only the top-left cell)

The data will be output in the following order: row (ascending order), column (ascending order), cell (A1->B1->…->A2->B2…).

Also, according to the contents specified as output items, the output will be as follows.

1: Items to be output when "Cell Value" is selected

2: Items to be output when "Cell Format" is selected

3: Items to be output when "Settings of rows and columns"

Item name	1	2	3	Output contents
Sheet name	✓	✓	✓	Sheet name
Address	✓	✓	✓	For rows, the number of rows (1, 2, etc.); for columns, the column name (A, B, etc.); for cells, the cell address (A1, B2, etc.)
Input value	✓			Value input into the cell
Horizontal position		✓		left, center, right, fill, justify, centeracrossselection, distributed * General does not output
Vertical position		✓		top, bottom, justify, distributed * center does not output
Put space before and after(Justify distributed)		✓		Output "1" only if applicable
Indent		✓		Indent (1, 2, 3, etc.)
Wrap text and show all		✓		Output "1" only if applicable
Merging cells		✓		Output the merged range only for the origin cell of the join (upper left cell) (e.g. A1:B5)
Font		✓		Font name
Boldface		✓		Output "1" only if applicable
Italic		✓		Output "1" only if applicable
Font size		✓		Font size
Underline		✓		single, double, single-account, double-account
Font color		✓		Font color (e.g. #ff0000)
Background color		✓		Background color (e.g. #ff0000)
Display format		✓		Format string in display format (#,##0.00_ , $#,##0.0_ ;$-#,##0.0 , yyyy"-"mm"-"dd hh:mi;@ etc.)
Left side border thickness		✓		Left side border thickness ("1" for the 1st - 5th from the top, "2" for the 6th - 9th, and "3" for the 10th (bottom) in the ruled line style in the Format Cells dialog)
Left side border color		✓		Left side border color (e.g. #ff0000)
Left side border style		✓		Left side border style (Continuous, Dot, Dash, DashDot, DashDotDot)
Right side border thickness		✓		Right side border thickness ("1" for the 1st - 5th from the top, "2" for the 6th - 9th, and "3" for the 10th (bottom) in the ruled line style in the Format Cells dialog)
Right side border color		✓		Right side border color (e.g. #ff0000)
Right side border style		✓		Right side border style (Continuous, Dot, Dash, DashDot, DashDotDot)
Thickness of upper ruled line		✓		Upper border thickness ("1" for the 1st - 5th from the top, "2" for the 6th - 9th, and "3" for the 10th (bottom) in the ruled line style in the Format Cells dialog)
Color of upper ruled line		✓		Upper border color (e.g. #ff0000)
Style of upper ruled line		✓		Upper border style (Continuous, Dot, Dash, DashDot, DashDotDot)
Bottom border thickness		✓		Bottom border thickness ("1" for the 1st - 5th from the top, "2" for the 6th - 9th, and "3" for the 10th (bottom) in the ruled line style in the Format Cells dialog)
Bottom border color		✓		Bottom border color (e.g. #ff0000)
Bottom border style		✓		Bottom border style (Continuous, Dot, Dash, DashDot, DashDotDot)
Row height			✓	Row height
Column width			✓	Column width
Hidden row			✓	Output "1" only if applicable
Hidden column			✓	Output "1" only if applicable
Fixed row			✓	Output "1" only if applicable
Fixed column			✓	Output "1" only if applicable

"Sheet name" and "Address" will always be output regardless of the output item selected.

Attention

• Characters that cannot be represented by the selected character encoding will be converted to "?" for output.
• No information about tags will be output in the exported information.