1. Home
  2. Forum
  3. WPF
  4. Server-Sede Excel library for C# .NET, is File Format Excel what we are looking for ?

Server-Sede Excel library for C# .NET, is File Format Excel what we are looking for ?

My question is: Can SyncFusion File Formats Excel do the below things ?

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. And if possible the following actions:

Open Workbook

Set Header

Add New Workbook

Set Footer

Add New Sheet

Set Cell Styles

Remove Sheet by Name

Set Cell Style

Remove Sheet by Index

Set Cell Borders

Select Sheet by Name

Set Cell Border

Select Sheet by Index

Set Cell Alignments

Get Sheet Names

Set Cell Alignment

Set Sheet Name

Set Cell Protections

Get Cell Value

Set Cell Protection

Set Cell Value

Set Sheet Protection

Set Cell Text

Set Cell Format

Set Cell Text from Clipboard

Set Cell Formats

Set Row Values

Save

Set Column Values

Save As

Auto Fit

Close

Get Sessions


1 Reply
SS Sridhar Sukumar Syncfusion Team February 16, 2017 11:02 AM UTC

Hi Devid, 
 
Thank you for contacting Syncfusion support. 

XlsIO helps you to achieve the requirement without the use of MS Excel. The following table shows the list of supported and unsupported features. 
 
Features 
Supported 
Rotation of Text in a cell 
Yes 
Charts should not be thrown away 
Yes 
Add Graphic in Header and Footer 
Yes 
Open Workbook 
Yes 
Add New Workbook 
Yes 
Add New Sheet 
Yes 
Remove Sheet by Name 
Yes 
Remove Sheet by Index 
Yes 
Select Sheet by Name 
Yes 
Select Sheet by Index 
Yes 
Get Sheet Names 
Yes 
Set Sheet Name 
Yes 
Formulas 
Yes 
Get Cell Value 
Yes 
Set Cell Value 
Yes 
Set Cell Text 
Yes 
Set Cell Text from Clipboard 
No 
Set Row Values 
Yes 
Set Column Values 
Yes 
Auto Fit 
Yes 
Get Sessions 
No 
Set Header 
Yes 
Set Footer 
Yes 
Set Cell Styles 
Yes 
Set Cell Style 
Yes 
Set Cell Borders 
Yes 
Set Cell Border 
Yes 
Set Cell Alignments 
Yes 
Set Cell Alignment 
Yes 
Set Cell Protections 
Yes 
Set Cell Protection 
Yes 
Set Sheet Protection 
Yes 
Set Cell Format 
Yes 
Set Cell Formats 
Yes 
Save 
Yes 
Save As 
Yes 
Close 
Yes 
 
To know more about these functionalities, please refer the following UG documentation link. 
 
 
Please let us know if you have any concern. 
 
Regards, 
Sridhar S. 


Loader.
Up arrow icon