rust_xlsxwriter

The rust_xlsxwriter library supports a wide variety of Excel charts, including:

• Standard Charts: Area, Bar, Column, Line, Pie, Doughnut, Radar, Scatter, and Stock charts.
• Specialized Charts: Clustered category charts, Combined charts, Gauge charts (constructed via doughnut and pie charts), Pareto charts, and Sparklines (mini-charts that fit in a single cell).
• Advanced Chart Features: Charts with secondary axes, charts with data tables, charts with gradient fills, and charts with fill patterns.
• Chartsheets: Creating dedicated chartsheets.

Restrict user input in specific cells using data validation:

• Text Validation: Restrict input to specific string patterns (e.g., only uppercase text).
• Date Validation: Restrict input to date values within a specific fixed range.

Images can be inserted into worksheets with various configurations:

• Creation: Create image objects from buffers (u8 buffer) or standard file paths.
• Sizing: Scale images by width/height, scale to a fixed size, or use worksheet.insert_image_fit_to_cell() to fit an image to a cell.
• Accessibility: Set alternative text (alt_text) or mark an image as decorative to improve accessibility for screen readers.
• Behavior: Configure how the image behaves (object movement) when cells underneath it are changed.

Advanced workbook management includes:

• Document Properties: Set custom/user-defined workbook properties. You can also control the creation date to ensure consistent file checksums.
• VBA Macros: Add VBA projects to .xlsm files (e.g., adding, calculating, naming, saving, or signed macros).

Notes (formerly comments) can be added to cells with the following capabilities:

• Basic Usage: Create and add a new note to a cell.
• Customization: Set the author's name, change the background color, and adjust the note's dimensions (width/height).
• Visibility: Control whether the note is visible by default.
• Reuse: Reset the text of an existing Note object to reuse it for different cells.

The library provides several ways to write formatted dates and times into a worksheet:

• Standard Datetimes/HMS: Write formatted datetimes or times (including milliseconds).
• From Components: Create datetimes from Year-Month-Day (YMD) or from Hours-Minutes-Seconds (HMS).
• From External Sources: Write datetimes parsed from strings, from Unix timestamps, or from Excel serial datetime values.
• Excel Conversion: Use the ExcelDateTime::to_excel() method to convert datetime objects into the format Excel expects.

The library provides extensive control over chart aesthetics and components:

• Chart Components: Add data tables, drop lines, high-low lines, and up-down bars.
• Series & Points: Set individual segment colors for Pie charts, adjust chart rotation for pie/doughnut charts, and set the hole size for doughnut charts.
• Visual Areas: Format the chart plot area (the area between axes) and apply solid fills or specific colors to chart elements.
• Titles: Set chart titles and customize their font properties.
• Trendlines: Add trendlines to data series, set their type (e.g., polynomial), customize their names, and format their data labels. You can also hide trendline names from the legend.

You can add shapes, such as textboxes, and customize their appearance:

• Font Styling: Set font properties (bold, italic, name, size, color) specifically for text within a shape.
• Shape Styling: Customize the shape's appearance, including line properties and gradient fills.

You can restrict user input in worksheet cells using data validation. Supported validation types include:

• Decimal Numbers: Restrict to floating point values, either in a fixed range or based on a formula from another cell.
• Whole Numbers: Restrict to integers, either in a fixed range or based on a formula.
• Lists: Restrict input to a selection of values from a dropdown list. The list can be provided as a set of strings or a cell range.
• Text Length: Restrict input to strings within a specific character length range.
• Time: Restrict input to time values within a fixed range.

Additionally, you can enhance validation by:

• Setting an input message to explain required input to the user.
• Setting a custom error title and error message to display when invalid data is entered.

You can customize how data is presented in a chart series:

• Data Labels: Add labels with specific fonts, number formats, or positions, and show category names or percentages (doc_chart_data_labels, doc_chart_data_labels_set_num_format, doc_chart_data_labels_show_percentage).
• Series Appearance: Set the series name, invert colors if negative, or set a secondary axis (doc_chart_series_set_name, doc_chart_series_set_invert_if_negative, doc_chart_series_set_secondary_axis).
• Error Bars: Add error bars to a data series (doc_chart_error_bars_intro).

The library allows deep customization of chart elements using various formatting options:

• Fonts: Set bold, italic, color, name, size, and rotation for any chart element (doc_chart_font, doc_chart_font_set_bold, doc_chart_font_set_rotation).
• Fills: Apply solid, gradient, or pattern fills, and manage transparency (doc_chart_gradient_fill, doc_chart_pattern_fill, doc_chart_line_set_transparency).
• Lines/Borders: Format line width, dash type, and color, or remove borders/lines entirely (doc_chart_line_set_width, doc_chart_line_set_dash_type, doc_chart_format_set_no_border).
• Markers: Add and customize markers (type and size) for line charts (doc_chart_marker, doc_chart_marker_set_type).