devexpress-office-file-api-spreadsheet

What problem does it solve?

This skill solves the problem of needing to programmatically work with Excel and spreadsheet files in .NET applications without installing Microsoft Office, while providing accurate DevExpress API guidance to reduce code errors and eliminate reliance on unvetted third-party libraries.

Core Features & Use Cases

• Full Spreadsheet Automation: Create, read, modify, and export .xlsx, .xls, .csv, .xlsm, and .txt spreadsheet files programmatically.
• Formatting & Logic: Apply cell formatting, Excel formulas (with portable invariant syntax), charts, pivot tables, data validation, and conditional formatting.
• Data & Export: Import data from DataTables, collections, and arrays; export workbooks to PDF, HTML, and images.
• Security & Compliance: Implement workbook/worksheet protection, password encryption, and content sanitization to meet GDPR, HIPAA, and SOX requirements.
• Use Case: A .NET developer building a server-side report generator can use this skill to create formatted Excel sales reports with calculated totals, embedded charts, and PDF export without installing Office on the deployment server.

Quick Start

Use this skill to generate a formatted .xlsx sales report with calculated totals, embedded charts, and PDF export for your .NET application.