Skip to content

j-minster/excelcreator

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

excelcreator

Installation

git clone <THIS_PROJECT_URL>
cd excelcreator
poetry install
poetry shell

Required CSV structure

The input CSV file should be structured like this:

Group Boundaries ( n grouping columns ) Scenario 1 YEAR ( ... ) Scenario n YEAR
String String Strings Number Numbers Number
  • The output excel file will have as many sheets as there are unique 'Groups' in the 'Group' column
  • The remaining non-scenario columns will be used to group the data into blocks
  • Scenario names must contain a YEAR to be recognised.

Usage

poetry run createxl 'inputs/data.csv' \
    -o 'outputs' \
    -n 'output.xlsx'

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages