devexpress-office-file-api-spreadsheet

Install the DevExpress.Document.Processor NuGet package, create a Workbook instance, write values to worksheet cells, and call SaveDocument with the .xlsx path. The library runs entirely in-process with no Office installation required.

Call workbook.ExportToPdf with the output file path after loading or building the workbook. You can configure page orientation, margins, print areas, and PDF/UA accessibility through worksheet print options and the BeforeExport event.

Yes, the .NET 6/7/8+ version is cross-platform and works on Linux, Docker, and cloud environments. Use DXFontRepository to load custom fonts at runtime since system fonts may be unavailable in those environments.

This happens when you assign the formula string to the cell's Value property instead of FormulaInvariant, or when the cell's NumberFormat is set to text. Always use cell.FormulaInvariant with English function syntax for portable, calculated formulas.

Yes, call sheet.Import with the DataTable, addHeader set to true, and the starting row and column indices. You can also import from lists of custom objects, one-dimensional arrays, or two-dimensional arrays.

Box and Whisker, Waterfall, Histogram, Pareto, Funnel, Sunburst, and Treemap charts can be created, loaded, and saved in code, but they cannot be printed or exported to PDF. Standard chart types like column, line, and pie export normally.