CSV
Overview
Convert Static Game Data into comma-separated CSV format.
When conflicts occur, merging from Excel is hard to read, but with a text-based CSV format it is easier to find diffs.
Format
CSV outputs the table data read from the row specified by header.row.
- Row 1: Item names
- Row 2 and later: Static Game Data
The table input path and sheet name are not written into the CSV body.
Output Path
CSV output is written under a directory for each table input type.
| Input | Output path |
|---|---|
| Local Excel | csv/Excel/{directory relative to input_search_path}/{ExcelFileName}_{sheet}.csv |
| Google Sheets | csv/GoogleSheets/{header.output_path}/{header.name}_{sheet}_{spreadsheetId}.csv |
| EnumBase | csv/EnumBase/{EnumName}.csv |
EnumBase is written to csv/EnumBase for both local Excel input and Google Sheets input. It is not duplicated under csv/Excel or csv/GoogleSheets.
Example
Basic/Basic.xlsm#Dictionary
| A | B | C |
|---|---|---|
| Id | Name | |
| 1 | Rice | |
| 2 | Bread | |
| 3 | Pasta |
yaml
header:
input_path:
- path: Basic/Basic.xlsm
sheet: 辞書
row: 1
base_type: Normal
source_type: Normal
container_type: Dictionary
output_path: Basic
name: BasicDictionary
fields:
- key: Id
name: id
type: Int
- key: Name
name: name
type: String
...
Output CSV
Id,Name
1,Rice
2,Bread
3,Pasta