jmcnamara/XlsxWriter

Features

• Cell Data Writing - Inserts text, numbers, or formulas into specific zero-indexed coordinates.
• XLSX File Generation - XlsxWriter creates a new workbook and saves it to a file using a specified name.
• XLSX Export - Functions as a library for transforming data into professional Excel XLSX files with support for multiple worksheets and formulas.
• Excel Automation - Provides a comprehensive toolkit for automating the creation of professional Excel reports.
• Automated Document Formatting - Programmatically applies visual styles, conditional formatting, and custom number formats to spreadsheet data.
• Bulk Data Writing - Writes a list of data across a sequence of cells in one operation.
• Chart Embeddings - Embeds chart objects into worksheets with precise positioning and scaling options.
• Chart Insertions - Builds various chart types with customizable axes and legends for workbook integration.
• Excel Table Creation - Defines cell ranges as formal tables featuring formatting, filters, and total rows.
• Spreadsheet Charting - Generates a wide variety of standard plots including bar, line, pie, and scatter charts with custom formatting.
• Spreadsheet Data Writing - Provides methods to insert text, numbers, and formulas directly into worksheet cells.
• Worksheet Organization - Adds new named sheets to a workbook for data and configuration.
• Memory-Optimized Export - Supports writing massive datasets exceeding 4 GB using a row-by-row disk-flushing mode to minimize RAM.
• Write Throughput Optimizations - Uses a specialized processing mode to lower memory consumption when generating spreadsheets with massive datasets.
• Disk-Buffered Writing - Writes extensive datasets to disk without consuming excessive RAM through a specialized memory-optimized mode.
• Table Grouping - Groups a range of cells into a formal table with specific formatting.
• Data Series Linking - Links charts to data by defining values and labels from the worksheet.
• Spreadsheet Visualizations - Generates charts, sparklines, and data labels embedded directly within spreadsheet documents.
• Structured Spreadsheet Tables - Adds structured tables to worksheets with support for custom total formulas.
• External Data Writing - Provides type-specific methods for writing strings, numbers, and formulas into spreadsheet cells.
• Row-Based Stream Writing - Minimizes RAM consumption by flushing large datasets to disk sequentially row-by-row.
• Spreadsheet Styling - Formats cells with percentages, dates, and custom styles for professional visual presentation.
• Memory-Optimized Writers - Implements a memory-optimized mode that flushes large datasets to disk row-by-row to minimize RAM usage.
• Chart Generators - Generates specific chart objects based on structured data for insertion into workbooks.
• Excel - Provides a full engine for embedding professional charts, sparklines, and visualizations in Excel.
• Cell Coordinate Mapping - Translates between zero-indexed integer coordinates and alphanumeric cell references like A1.
• Row-Based Streaming - Reduces memory overhead by flushing data to disk sequentially by row instead of buffering the entire dataset.
• Cell Styling Systems - Provides comprehensive controls over cell appearance including fonts, colors, borders, and alignment.
• Autofilter Configurations - Defines ranges with selectors and applies criteria to control displayed data via autofilters.
• Column Configuration - Sets column width and manages visibility and outline levels for organized data presentation.
• Custom Color Definitions - Sets element colors using HTML strings, named colors, or theme tuples.
• Data Control Implementations - Implements autofilters, validation lists, and defined names to manage spreadsheet user interaction.
• Freeze and Split Panes - Divides the worksheet into regions that remain visible while scrolling for better data navigation.
• Oversized File Generation - Creates workbook files larger than 4 GB by utilizing extended file format specifications.
• Row Configuration - Sets row height and manages formatting, visibility, and outline levels.
• Table Border Styling - Defines border styles and colors for all sides of a cell or creates diagonal borders.
• Table Data Referencing - Uses named table ranges within formulas to perform lookups on structured data.
• Spreadsheet Automation Macros - Includes signed project files within the workbook to enable VBA macro functionality.
• VBA Macro Embedding - Allows importing binary project files and signature files to enable custom macros and signed scripts.
• Row and Column Grouping - Creates collapsible outlines for rows and columns to highlight summaries.
• Dataframe Visualizers - Inserts visual charts into worksheets that contain exported tabular dataframe data.
• Marker Configurations - Sets the shape, size, border, and fill of markers within charts.
• Autofilter Setup - Adds dropdown filter lists to a data range to show or hide rows.
• Workbook Insertion - Supports writing external dataframes to specific worksheets and exact cell coordinates.
• DataFrame Autofiltering - Adds filtering to exported dataframe ranges to hide non-matching rows.
• DataFrame Table Conversion - Groups exported dataframe cells into formal table structures with headers.
• Spreadsheet Data Validation - Restricts the type of data users can enter into cells and provides selectable dropdown lists.
• Integrated Project Tooling - Integrates binary project files and digital signatures to enable internal macros and functions.
• Chart Title Configurators - Applies colors, gradients, and borders to chart titles and data labels.
• Formatted Text Insertion - Inserts text into cells using multiple different formats for different fragments of the string.
• Formula Evaluators - Inserts standard and array formulas, with the option to specify pre-calculated results.
• Array Formula Generation - Supports the creation of static and dynamic array formulas that return results across cell ranges.
• Formula Insertion - Allows inserting formulas into cells to perform calculations based on other cell values.
• Numeric Data Formatting - Defines how numbers are displayed using custom format strings or built-in indices.
• Document Password Protection - Implements password protection to restrict the modification of worksheet elements and lock cells.
• Background Fill Colors - Sets background patterns and colors for cells using solid fills or pattern indices.
• Cell Comments - Attaches notations to specific cells with custom authorship, visibility, and styling.
• Cell Range Definitions - Creates descriptive names for cell ranges to simplify the construction of formulas.
• Named Range Creation - Assigns custom names to cell ranges to simplify formula referencing.
• Number Formatting - Provides specialized number formatting to ensure values are displayed correctly as currency or dates.
• Chart Axis Configurations - Configures axis titles, number formats, scale ranges, and gridline visibility.
• Chart Legends - Manages the visibility, position, and font of the chart legend.
• Data Value Labels - Displays numeric values or category names next to data points with custom positioning.
• Chart Styling Utilities - Implements predefined design styles to customize the visual appearance of charts.
• Cell-Relative Positioning - Positions charts and images using percentage-based offsets relative to cell boundaries.
• Automatic Width Adjustment - Calculates and sets column widths automatically based on the length of the cell content.
• Cell Validation Rules - Restricts user input in cells or ranges to specific types or predefined dropdown lists.
• Cell Merging - Allows combining multiple neighboring cells into a single larger area for data entry.
• Conditional Formatting - Applies visual styles to cells automatically based on values, dates, text patterns, or formulas.
• Rich Text Styling - Creates text in a single cell with multiple different formats applied to different parts of the string.
• Sparkline Charts - Embeds compact, minimalist line charts within cells to visualize data trends across columns.
• Chart Visual Customizations - Customizes font name, size, color, and rotation for all chart elements.
• Document and File Processing - Generates Excel files with complex formatting and charts.
• File Formats - Module for creating Excel XLSX files.

Star history