iwfm.xls.write_2_excel

iwfm.xls.write_2_excel(file_base_name, data, sheets, elements, time_steps, dates, data_type='Crop')[source]

Write a 3D array as 2D tables to an excel workbook.

Deprecated since version Use: iwfm.xls.create_workbook(), iwfm.xls.add_worksheet(), iwfm.xls.write_cells(), and iwfm.xls.save_workbook() instead.

Parameters:
  • file_base_name (str) – Base name of output file (without .xlsx extension).

  • data (list) – 3D array of data [sheets][elements][time_steps].

  • sheets (int) – Number of sheets.

  • elements (int) – Number of elements (rows of data).

  • time_steps (int) – Number of time steps.

  • dates (list) – Dates corresponding to time steps.

  • data_type (str, default='Crop') – Type of information (used in sheet names).