GemBox.Spreadsheet adds data validation in XLSX

Version 3.5 also adds new methods for extracting to DataTables and full support for sheet protection in XLSX.

Zoom [+]

Spreadsheets created using GemBox.Spreadsheet.

GemBox.Spreadsheet is a .NET component that enables developers to write, read or convert spreadsheet files (XLS, CSV, XLSX, HTML or ODS) from their .NET applications using one simple API. GemBox.Spreadsheet requires only .NET Framework and is many times faster than Excel automation object. GemBox.Spreadsheet is licensed per developer, server deployment is royalty free.

Updates in V3.5

• Full support for Data validation in XLSX
• Collections now implement generic versions of appropriate .NET interfaces
• Exporting to html supports exporting pictures
• Methods for sorting
• New methods for extracting to DataTable without needing to predefine DataTable
• Full support for sheet protection in XLSX
• Helper methods for setting Print Titles and Print Area
• Support through API for print gridlines and left/right header/footer in ODS

About GemBox Software

GemBox Software was founded by a group of young people, previously working as software consultants on numerous windows development projects. Their specialty and preferred choice has always been Microsoft platform and tools. They were early adopters of .NET platform, using it since Visual Studio .NET Beta 2. High-quality components are a necessity in modern application development, enabling you to save time, boost productivity and increase quality. Their products are a testimony of their mission; small, fast, standardized and well documented.