Work with xml file

[Miroslav]

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?

[Tanya]

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