-----------------------------------------------------------

New Message on MumbaiUserGroup

-----------------------------------------------------------
From: kai_275
Message 2 in Discussion


Hello Payal,
 
I have written a code to export HTML to excel file .
Attached is the function in C# which u may find useful.
 
Regards,
Kailas


[EMAIL PROTECTED]> wrote:
 




New Message on MumbaiUserGroup



Help required on exporting to excel





Reply





 
Reply to Sender   Recommend 
Message 1 in Discussion 





From: Payal 


Hi All,

I want some help on exporting data to excel.

I have an aspx page which has the following code:

TableRow trDashboard = new TableRow();
TableCell tcDashboard = new TableCell();
//First Row starts here
//First Column starts here
tcDashboard.Attributes.Add("align","center");
tcDashboard.CssClass = "txtblack";
tcDashboard.ForeColor = Color.Blue;
tcDashboard.Text = "Section No";
trDashboard.Cells.Add(tcDashboard);

//First Row Second Column starts here
tcDashboard = new TableCell();
tcDashboard.Attributes.Add("align","center");
tcDashboard.CssClass = "txtblack";
tcDashboard.ForeColor = Color.Blue;
tcDashboard.Text = "Mould No.";
trDashboard.Cells.Add(tcDashboard);

tblDashboard.Rows.Add(trDashboard); //First row over

tblDashboard is a Table with the runat property set to server.

The code that I have written up is just the header row.
The rest of the rows are
 fetched from the database and then
using a datatable they are populated in the same way as givem above (using a 
for loop).

This code is executed on click of submit button on the screen.

The output of this page is an html page.

Now I want to export this html created to excel on click of export to excel 
button present on the screen.

Can somebody tell me how do I do this.

Is it possible in C#.

Can you provide me with some links to export to excel.


I hope I am clear with the question


Regards,
Payal

_________________________________________________________________
Are you a Citibank RCA member? Want to fly free to India? 
http://server1.msn.co.in/sp03/diwali/rca/memberrca.asp Here is how you can!


View other groups in this category. 



Do you Yahoo!?

Yahoo! SiteBuilder - Free, easy-to-use web site design software

-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the "Remove" link below. On the pre-addressed 
e-mail message that opens, simply click "Send". Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to