excel2myfile

A tool to extract data from excel files and write to complex via yaml config defined structures.

Usage

usage: excel2myfile.py yaml_config excel_file out_file

Yaml config

use double {{ or }} if you want a literal { or }.

sheet_name: Sheet1  # workbook sheet
statement: "my statement with \n{sub1}"  # first statement wich is only inserted once, set to {} to use outest statement in every line
substatements:
  sub1: "\tmy statement with a nested substatement ({sub2}) and two placeholders {ph1}, {ph2}\n"
  sub2: "my nested substatement with a placeholder {ph3}"
placeholder_row_start: 2
placeholder_column_mapping:
  ph1: A
  ph2: B
  ph3: C