This project is read-only.

Server-side Excel library for use with C# and .NET

Feb 14 at 3:13 PM
Edited Feb 14 at 3:25 PM
My question would be: Is NPOI library the library I am looking for ? Does NPOI support the features below ?

At our company we are using the [Telerik RadSpreadProcessing] Library with .NET C#. It can manipulate data on the server-side without the need for Office. Unfortunately the Telerik library is missing few features that we need. Such features are:
• Add Graphic in Header and Footer
• Rotation of Text in a cell
• Charts should not be thrown away (Telerik library throws away)

The library should support the .xlsx format but also Formulas to manipulate the data.

Furthermore it would be ideal if the library has the below functionalities:

• OpenWorkbook
• AddNewWorkbook
• AddNewSheet
• RemoveSheetByName
• RemoveSheetByIndex
• SelectSheetByName
• SelectSheetByIndex
• GetSheetNames
• SetSheetName
• GetCellValue
• SetCellValue
• SetCellText
• SetCellTextFromClipboard
• SetRowValues
• SetColumnValues
• AutoFit
• SetHeader
• SetFooter
• SetCellStyles
• SetCellStyle
• SetCellBorders
• SetCellBorder
• SetCellAlignments
• SetCellAlignment
• SetCellProtections
• SetCellProtection
• SetSheetProtection
• SetCellFormat
• SetCellFormats
• Save
• SaveAs
• Close
• GetSessions