mario.Database.to_excel

Database.to_excel(path=None, flows=True, coefficients=False, units=True, scenario='baseline', include_meta=False)

Saves the database into an Excel file

Note

• The function will create a single Excel file with different sheets.

• The sheets bsed on the inputs will be:

  • coefficients

  • flows

  • units

• It is suggested to keep the units = True so the output file can be used to parse with MARIO again.

Parameters:

• path (str) – the path that the Excel file should be saved. If it is None, MARIO will try to use the default path and inform the user with a warning. (the path should contain the name of excel file like ‘pathdatabase.xlsx’)

• flows (boolean) – if True, in the Excel file, a sheet will be created named flows containing the data of the flows

• coefficients (boolean) – if True, in the Excel file, a sheet will be created named coefficients containing the data of the coefficients

• units (boolean) – if True, in the Excel file, a sheet will be created named units containing the data of the units

• scenario (str) – defines the scenario to print out the data

• include_meta (bool) – saves the metadata as a json file along with the data