We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

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

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

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:

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Open Workbook - Yes (See the document for your reference)<o:p style=“box-sizing: border-box;”></o:p>

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Header<o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Add New Workbook <o:p style=“box-sizing: border-box;”></o:p> - Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Footer <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Add New Sheet <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Cell Styles <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Remove Sheet by Name <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Cell Style <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Remove Sheet by Index <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Cell Borders <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Select Sheet by Name <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Cell Border <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Select Sheet by Index <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Cell Alignments <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Get Sheet Names <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Cell Alignment <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Sheet Name <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Cell Protections <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Get Cell Value <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Cell Protection <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Cell Value <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Sheet Protection <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Cell Text <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Cell Format <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Cell Text from Clipboard Yes, Grid controls support this.<o:p style=“box-sizing: border-box;”></o:p>

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Cell Formats <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Row Values <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Save <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Set Column Values <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Save As <o:p style=“box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Auto Fit <o:p style=“box-sizing: border-box;”></o:p> <o:p style=“color: rgb(91, 91, 91); box-sizing: border-box;”></o:p>- Yes (See the document for your reference)

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Close<o:p style=“box-sizing: border-box;”></o:p>

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”>Get Sessions<o:p style=“box-sizing: border-box;”></o:p>

<span calibri",sans-serif;="" color:black;mso-ansi-language:en-us"="" style=“box-sizing: border-box;”><o:p style=“box-sizing: border-box;”></o:p>



Hope this helps a bit.

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

Thank you.