Create Excel file from YAML description.
go get
go build
yaml2exls <YAML file name>
config:
books:
- book:
name:
sheets:
- sheet:
name:
rows:
- row:
cols:
- col
text:
img:
config:
img_scale: 0.5
books:
- book:
name: Book1
sheets:
- sheet:
name: Sheet1
rows:
- row:
cols:
- text: This is test.
- text: これがB1に入る予定
- row:
cols:
- img: assets/pic1.png
- row:
cols:
- img: assets/pic2.jpg
- row:
cols:
- text: Test2
- sheet:
name: シート2だよ
rows:
- row:
cols:
- text: Some text
- book:
name: 日本語ブック名(仮)
sheets:
- sheet:
name: あああ
rows:
- row:
cols:
- text: HogePiyo
- sheet:
name: 2.Test
rows:
- row:
cols:
- img: assets/pic2.jpg
config:
vertical_resolution: 96.0
use_image_height: true
img_scale: 1.0
img_margine: 1.0
Excel's vertital DPI. Default value is 96.0 (96 DPI).
If true, It would be calculate image height to skip row number.
If false, Does not calculate image height and does not skip row number.
Scaling ratio of image. Default value is 1.0.
Vertical margin after image.
Default value is 1.0. It means: one row height.
If use_image_height to false, This value does not use.
Array of book.
book:
name:
sheets:
book name to be use .xlsx file name.
book name without ".xlsx".
Array of sheet.
sheet:
name:
rows:
It will be use sheet name.
Array of row.
row:
cols:
Array of col.
col:
text:
img:
Cell text.
Image file path.