RadSpreadsheet format a range of cell as an Excel table

1 Answer 51 Views
Spreadsheet
John
Top achievements
Rank 1
Iron
John asked on 12 Apr 2023, 04:43 PM

Does the functionality exist to format a range of cells as a table like can be done in Excel?

I use the data provider to read the format of an existing Excel file.

But, a range of cells formatted as a table is not copied into the RadSpreadsheet.

1 Answer, 1 is accepted

Sort by
0
Attila Antal
Telerik team
answered on 24 Apr 2023, 10:13 AM

Hi John,

The Spreadsheet currently provides the following functionalities:

  • Work with MS Excel files (.xlsx, .csv), and with .txt, .json files - try the Import/Export an Excel File demo
  • Create, delete, and reorder Worksheets
  • Set custom styles to cells, rows, columns or regions
  • Resize rows and columns
  • Merge cells
  • Intuitive Column, Row and Cell Selection
  • Use different data formats (currency, percent etc.)

See WebForms Spreadsheet Overview

 

For the functionality of formatting a range of cells as a table, I suggest submitting a Feature Request. Because the RadSpreadsheet is a Web Forms wrapper for the Kendo widget, the Feature request should be submitted in the Kendo UI feedback portal at Progress® Kendo UI® for jQuery Feedback Portal. Once the Feature is implemented in the Kendo widget, it will also be available in the Web Forms RadSpreadsheet component.

 

Regards,
Attila Antal
Progress Telerik

Heads up! Telerik UI for ASP.NET AJAX versions for .NET 3.5 and 4.0 are retired. Progress will continue shipping assemblies compatible with .NET 4.5 and later. See whether this affects your apps in this article.
John
Top achievements
Rank 1
Iron
commented on 25 Apr 2023, 12:47 PM

I realized the RedSpreadsheet overview did indeed specify Table functionality is not supported.

Not a big issue as I simply override the Save functionality and use the OpenXml API to apply a table to the desired range prior to download,

Tags
Spreadsheet
Asked by
John
Top achievements
Rank 1
Iron
Answers by
Attila Antal
Telerik team
Share this question
or