[Solved] Import excel with named ranges does not work

[Nikos]

when importing a spreadsheet which has named ramges the named ranges are not imported. So any cells that reference these by range name do not work.

See attached file for demo.

Nick.

 

[Ianko]

Hello Nikos,

Frankly, named ranges are not supported by Kendo Spreadsheet. I encourage you to post a feature request here: http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback. 

A possible alternative is to use server-side approach to import the excel file and process it by using RadSpreadProcessing library. Which will eventually enable you to transform the named ranges to cell ranges. http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/named-ranges. 

Regards,
Ianko
Telerik by Progress