Silverlight DataGrid displays the contents of the selected Excel file

Think of Excel as a database.

Then use it in the same way you normally would with the database.

Just use aspx pages, not silver.

private sub excel_click(byval sender as , byval e as

with response

buffer = true

contentencoding = "utf-8 ")end with

datagrid_ = false

dim tw as new

dim hw as new

datagrid_

end sub

Grid is placed on an aspx page and binds the data source.

This way the export is very fast, I don't know how much faster than recursively filling the xls cells myself.

But there is a flaw that you can only watch, and there will be problems when doing statistics.

Because in fact, this ** principle is to use XLS to display HMTL, which is different from the real XLS source**.

To give you an idea. It is to use the webservice to read Excel first, and then return the read data to Silverlight and then bind it to DataGrid.

To give you an idea. It is to use the webservice to read Excel first, and then return the read data to Silverlight and then bind it to DataGrid.

Excel?Local or server? The local one is uploaded to the server to parse excel, and the server's direct parsing is returned to the client for display.

You don't need to get the exported data from DataGrid, you can get the data directly from the data source and import it into Excel.

Just set the fields in the class list bound in the datagrid.

datagrid lookup control, and then find value, usually textblok control.