Does Aspose Cells library support adding Graphic in Header/Footer?

Aspose.Cells Product Family
1

My question is: Can Aspose Cells library 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
2

Hi,

I think Aspose.Cells suits your needs well. It does support all your mentioned features including adding graphic to header/footer, rotation of text in the cell and creating/manipulating MS Excel charts in Excel spreadsheets, etc.

For your mentioned features:

Open Workbook - Yes (See the document for your reference) Set Header- Yes (See the document for your reference)
Add New Workbook - Yes (See the document for your reference) Set Footer - Yes (See the document for your reference)
Add New Sheet - Yes (See the document for your reference) Set Cell Styles - Yes (See the document for your reference)
Remove Sheet by Name - Yes (See the document for your reference) Set Cell Style - Yes (See the document for your reference)
Remove Sheet by Index - Yes (See the document for your reference) Set Cell Borders - Yes (See the document for your reference)
Select Sheet by Name - Yes (See the document for your reference) Set Cell Border - Yes (See the document for your reference)
Select Sheet by Index - Yes (See the document for your reference) Set Cell Alignments - Yes (See the document for your reference)
Get Sheet Names - Yes (See the document for your reference) Set Cell Alignment - Yes (See the document for your reference)
Set Sheet Name - Yes (See the document for your reference) Set Cell Protections - Yes (See the document for your reference)
Get Cell Value - Yes (See the document for your reference) Set Cell Protection - Yes (See the document for your reference)
Set Cell Value - Yes (See the document for your reference) Set Sheet Protection - Yes (See the document for your reference)
Set Cell Text - Yes (See the document for your reference) Set Cell Format - Yes (See the document for your reference)
Set Cell Text from Clipboard Yes, Grid controls support this. Set Cell Formats - Yes (See the document for your reference)
Set Row Values - Yes (See the document for your reference) Save - Yes (See the document for your reference)
Set Column Values - Yes (See the document for your reference) Save As - Yes (See the document for your reference)
Auto Fit - Yes (See the document for your reference) Close
Get Sessions

Hope this helps a bit.

Please browse Aspose.Cells APIs and Docs. Let us know if you find any feature not available.

Thank you.