Bytes functions

Return a workbook as bytes instead of writing a file

write_sheet_arrow_to_bytes

jet.write_sheet_arrow_to_bytes(arrow_data, **options) -> bytes

Identical to write_sheet_arrow except that it takes no filename and returns the workbook.

arrow_data · Any · required

Arrow table or DataFrame conversion.

All formatting options carry over unchanged: sheet_name, styled_headers, freeze_rows, freeze_cols, auto_width, auto_filter, write_header_row, column_widths, column_formats, merge_cells, data_validations, hyperlinks, row_heights, cell_styles, formulas, conditional_formats, tables, charts, images, gridlines_visible, zoom_scale, tab_color, default_row_height, hidden_columns, hidden_rows, right_to_left, data_start_row, and header_content.

Returns

bytes, the complete .xlsx file.

write_sheets_arrow_to_bytes

jet.write_sheets_arrow_to_bytes(sheets_data, num_threads=1) -> bytes

sheets_data · list[dict] · required

The same sheet dictionaries as write_sheets_arrow.

num_threads · int · default: "1"

Defaults to 1 here, unlike the file-writing variant where it’s required.

Returns

bytes.

Usage

See In-memory output for framework examples.

Jetxl holds the whole workbook in memory before returning it. A million-row sheet approaches a gigabyte during generation, which is acceptable on a server and risky in a constrained function runtime. Write to a file for very large exports.