Pre-sales question - Features of Aspose.Cells for Reporting Services

We have been experiencing a number of limitations with SQL Reporting Services when saving reports as Excel workbooks.

Can Aspose.Cells address these problems?

  • Allow you to set the page size and orientation when creating the workbook?
  • Name tabs in the workbook?

Please let me know.

Regards,

JTA

Hi,

Thank you for considering Aspose.

Yes, Aspose.Cells provides the features of Page Setup and Work Sheet Tab naming. Please see the following document regarding the page setup and the sample code regarding the naming a worksheet.

Sample Case for Naming a worksheet tab in a workbook.

//Instantiating a Workbook object
Workbook workbook = new Workbook();

//Adding a new worksheet to the Workbook object
workbook.Worksheets.Add();

//Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[0];

//Setting the name of the newly added worksheet
worksheet.Name="My Worksheet";

//Saving the Excel file
workbook.Save(saveFileDialog1.FileName,FileFormatType.Default);

Please do let us know if you need any further assistance. We will be happy to help you out.

Thank You & Best Regards,