bw2io.export.excel#

Module Contents#

Functions#

create_valid_worksheet_name(string)

Exclude invalid characters and names.

lci_matrices_to_excel(database_name[, include_descendants])

Fake docstring

write_lci_excel(database_name[, objs, sections])

Export database database_name to an Excel spreadsheet.

write_lci_matching(db, database_name[, only_unlinked, ...])

Write matched and unmatched exchanges to Excel file

write_lcia_matching(db, name)

Write matched and unmatched CFs to Excel file
bw2io.export.excel.create_valid_worksheet_name(string)[source]#

Exclude invalid characters and names.

Data from http://www.accountingweb.com/technology/excel/seven-characters-you-cant-use-in-worksheet-names.

bw2io.export.excel.lci_matrices_to_excel(database_name, include_descendants=True)[source]#

Fake docstring

bw2io.export.excel.write_lci_excel(database_name, objs=None, sections=None)[source]#

Export database database_name to an Excel spreadsheet.

Not all data can be exported. The following constraints apply:

  • Nested data, e.g. {‘foo’: {‘bar’: ‘baz’}} are excluded. Spreadsheets are not a great format for nested data. However, tuples are exported, and the characters :: are used to join elements of the tuple.

  • The only well-supported data types are strings, numbers, and booleans.

Returns the filepath of the exported file.

bw2io.export.excel.write_lci_matching(db, database_name, only_unlinked=False, only_activity_names=False)[source]#

Write matched and unmatched exchanges to Excel file

bw2io.export.excel.write_lcia_matching(db, name)[source]#

Write matched and unmatched CFs to Excel file