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.
