iwfm.xls

Excel file operations for IWFM.

Uses openpyxl by default (cross-platform). Falls back to win32com on Windows if openpyxl is not installed.

New API (recommended):

create_workbook, open_workbook, save_workbook, close_workbook add_worksheet, get_worksheet, write_cells, write_budget_data

Legacy API (deprecated):

excel_init, excel_new_workbook, excel_kill xl_open, xl_save, xl_quit, xl_write_2d bud2xl, write_budget_to_xl, write_2_excel

Functions

get_backend()

Return name of active backend ('openpyxl' or 'win32com').

Modules

bud2xl(budget_file, excel_file[, verbose, row])	Read IWFM Budget or Z-Budget output file and paste into existing Excel workbook.
buds2xl(bud_file[, type, verbose])	Read IWFM Budget.in file and write output to an Excel or csv file.
excel_init([visible, display_alerts])	Initialize the Excel application.
excel_kill(excel)	Close Excel application.
excel_new_workbook(excel)	Open a new Excel workbook with one sheet.
write_2_excel(file_base_name, data, sheets, ...)	Write a 3D array as 2D tables to an excel workbook.
write_budget_to_xl(wb, budget_data)	Write IWFM Budget data to an Excel workbook.
xl_open(excel_file)	Open an excel workbook.
xl_quit(excel)	Gracefully close the excel application.
xl_save(wb, excel_file_name)	Save the excel workbook.
xl_write_2d(output, wb[, row, col, sheet])	Write a 2D array to an existing excel workbook.
xls	Typer subapp for IWFM Excel import/export utilities.