Using Excel as Web Report 2

[chadau]

I need to use Excel as my reporting tool in an ASP.NET app. I have to load a spreadsheet with data from a SQL Server and display it to a client pc. First of all, has anyone done this? Secondly, how should I handle mutli user interaction with same report? Thanks in advance.

 

[logi2000]

you can use this code to convert the value on a datagrid to excel:

if (ds1 != null )
{
// Set the content type to Excel.
Response.ContentType = "application/vnd.ms-excel";
// Remove the charset from the Content-Type header.
Response.Charset = "";

// Turn off the view state.
this.EnableViewState = false;

System.IO.StringWriter tw;
tw = new System.IO.StringWriter() ;
System.Web.UI.HtmlTextWriter hw;

hw = new System.Web.UI.HtmlTextWriter(tw) ;

// Get the HTML for the control.
datagrid1.RenderControl(hw);
// Write the HTML back to the browser.
Response.Write(tw.ToString());
// End the response.
Response.End();
}

you need to have a web page with a datagrid, and associate the dataset to the datagrid. the above code will convert the datagrid to an excel file.

 

[adonet]

Do you have VB.NET code?

 

[adamroof]

this converter rocks!

http://www.kamalpatel.net/ConvertCSharp2VB.aspx

 

[adonet]

Thank you. A star for all of you.