RadSpreadsheet format a range of cell as an Excel table

[John]

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.

[Attila Antal]

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

[John]

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,