This is a migrated thread and some comments may be shown as answers.

Work with xml file

1 Answer 45 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Miroslav
Top achievements
Rank 1
Miroslav asked on 19 Feb 2019, 10:09 AM
Hello,
our company uses your controls in your project.
We have the following question:
Could Component Spreadsheet be fed with data from a xml file or a stream of data from xml file?

1 Answer, 1 is accepted

Sort by
0
Tanya
Telerik team
answered on 22 Feb 2019, 09:52 AM
Hi Miroslav,

Directly importing data from XML is not supported functionality. RadSpreadsheet currently supports XLSX, CSV, PDF (export only) and plain text. You can find more information about how you can work with the supported formats in the Import/Export help topic.

To achieve the desired goal, you could process the XML (using XmlDocument, for example) to obtain the values from it and set it in the worksheet using the SetValue() methods.

Hope this is helpful.

Regards,
Tanya
Progress Telerik
Get quickly and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Spreadsheet
Asked by
Miroslav
Top achievements
Rank 1
Answers by
Tanya
Telerik team
Share this question
or