Skip to main content

Excel Utilities

We are sunsetting our SDKs and will no longer add new features, security patches, bug fixes, or technical support for them. To access the latest capabilities and ongoing improvements, we encourage you to migrate to our RESTful API.SDK support will officially end on December 31, 2026. On this date, the underlying endpoints used by the SDKs and related documentation will be decommissioned.To avoid any disruption to your services, please ensure your migration is complete by that date.For migration assistance, please contact us at support@bigdata.com.

check_excel_dependencies

Check if the required Excel dependencies (openpyxl and pillow) are installed. Returns
  • bool: True if dependencies are installed, False otherwise.
Example

ExcelManager

Class for managing Excel workbook operations, formatting, and branding. Parameters (constructor)
  • min_column_width (int): Minimum column width (default: 12).
  • max_column_width (int): Maximum column width (default: 75).
  • row_offset (int): Row offset for data (default: 3).
  • column_offset (int): Column offset for data (default: 1).
Key Methods
  • save_workbook(df_args, workbook_path): Save DataFrames to an Excel workbook.
  • beautify_workbook(workbook_path): Apply formatting to an Excel workbook.
Example