How to add filter criteria to excel sheet through coding in c#?

Posted by Vijetha under C# on 4/12/2012 | Points: 10 | Views : 61315 | Status : [Member] | Replies : 6
Hi ,
The code below is how i generate the excel sheet and pass the data that i get in String builder(sb).
I want to apply filter criteria to it.
So please anyone help me out.



Response.Clear();
Response.Charset = string.Empty;
Response.ContentType = "application/ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=" + "EventExcelReport" + ".xls");
Response.Write(sb.ToString());
Response.End();




Responses

Posted by: Sakthi.Singaravel on: 4/12/2012 [Member] Silver | Points: 25

Up
0
Down
Hi Vijetha,

Refer this MSDN link for filter excel using c#...

http://msdn.microsoft.com/en-us/library/dd878132(v=office.12).aspx

Regards,
Singaravel M

Vijetha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sakthi.Singaravel on: 4/12/2012 [Member] Silver | Points: 25

Up
0
Down
r u got solution..?

Regards,
Singaravel M

Vijetha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vijetha on: 4/12/2012 [Member] Starter | Points: 25

Up
0
Down
Thats not working fine for me....


Regards,
Vijetha

Vijetha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sakthi.Singaravel on: 4/12/2012 [Member] Silver | Points: 25

Up
0
Down
okay..

Regards,
Singaravel M

Vijetha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sabarimahesh on: 4/12/2012 [Member] Bronze | Points: 25

Up
0
Down
Refer

http://msdn.microsoft.com/en-us/library/ff536099(v=office.12).aspx

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Vijetha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sabarimahesh on: 4/12/2012 [Member] Bronze | Points: 25

Up
0
Down
http://www.eggheadcafe.com/community/excel/66/10309261/vba-using-autofilter--filtering-on-all-available-criteria.aspx

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Vijetha, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response