How to upload an excel file and how to read its content row by row.

[Ravi]

Hi,

It would be great if you could share your thoughts on how to upload an excel (xls) file and read its content.

I will have four columns as follows
Country (text column)
State, (text column)
Population (which can be zero or comma seperated number)
Average Income - (which can be zero or comma seperated number)

Thanks,
Shiras

[Ravi]

early response is appreciated.

Thanks

[Alex Fidanov]

Hello David,

The RadUpload control is capable of uploading an excel file or any other type of file. However, to read its content you need an excel library that is capable of recognizing the excel file's content.

Regards,
Alex Fidanov
the Telerik team

[Ravi]

If could please suggest how to read its content in Silverlight 4 that will be a great help.

Thanks

[Ravi]

I am waiting for you response.

Please do update me as soon as possible.

Thanks

[Alex Fidanov]

Hi David,

You can use the FilesSelected event of the RadUpload and get the file stream of the file:

Stream stream = e.SelectedFiles[0].File.OpenRead();

Regards,
Alex Fidanov
the Telerik team

[Shiva]

Dear Alex,

This is an urgent request so please respond to it as soon as possible.

I have uploaded an excel file using RadUpload control and in its FileSelected event, I can get the stream of the file using e.SelectedFiles[0].File.Openread() as suggested by you in your comments.

I want to read the data of uploaded excel file from this stream. How do I do this??

Please share a code snippet with your comments so that i can get the proper understanding.

Thanks,
Shiva

[Petar Mladenov]

Hello Shiva,

 You can check out this codeplex library. Please note that once the file is on the server, the rest of the work is out of the Silverlight control's scope.

Kind regards,
Petar Mladenov
the Telerik team