calling Excel Macro from C#

[=?Utf-8?B?Vmlua2k=?=]

Hello Everyone,

I exported a gridview to excel spreadsheet. I want to adjust the column
width of the excel spreadsheet.
Is it possible to create Excel macro from C# to adjust the column width of
the spreadsheet. Below is my code for exporting to excel

string attachment = "attachment ; filename=Contac ts.xls";
Response.ClearC ontent();

Response.AddHea der("content-disposition", attachment);
Response.Conten tType = "applicatio n/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter( sw);
HtmlForm frm = new HtmlForm();

dgAgentActivity .Parent.Control s.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Ad d(dgAgentActivi ty);
frm.RenderContr ol(htw);

Any help will be greatly appreciated.

Thanks.

[Matt Brunell]

"Vinki" <Vi***@discussi ons.microsoft.c omwrote in message
news:2D******** *************** ***********@mic rosoft.com...

Hello Everyone,

I exported a gridview to excel spreadsheet. I want to adjust the column
width of the excel spreadsheet.
Is it possible to create Excel macro from C# to adjust the column width
of
the spreadsheet. Below is my code for exporting to excel

string attachment = "attachment ; filename=Contac ts.xls";
Response.ClearC ontent();

Response.AddHea der("content-disposition", attachment);
Response.Conten tType = "applicatio n/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter( sw);
HtmlForm frm = new HtmlForm();

dgAgentActivity .Parent.Control s.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Ad d(dgAgentActivi ty);
frm.RenderContr ol(htw);

Any help will be greatly appreciated.

Thanks.

You can use the Microsoft Office Primary Interop Assemblies. These allow
you to add a references which gives you access to COM components and let you
do just about anything with an office application.

Look up http://msdn2.microsoft.com/en-us/lib...57(VS.80).aspx

Here you should find out which reference to add, and information about
classes and methods.

[Alvin Bruney [MVP]]

No, it's not possible using your technique. You are better off trying an
Interop approach or using the OWC.
--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless Author Plug
OWC Black Book 2nd Edition
Exclusively on www.lulu.com/owc
$19.99
"Matt Brunell" <ma**@fast-soft.comwrote in message
news:80******** *************** ***********@mic rosoft.com...

"Vinki" <Vi***@discussi ons.microsoft.c omwrote in message
news:2D******** *************** ***********@mic rosoft.com...

>Hello Everyone,

I exported a gridview to excel spreadsheet. I want to adjust the column
width of the excel spreadsheet.
Is it possible to create Excel macro from C# to adjust the column width
of
the spreadsheet. Below is my code for exporting to excel

string attachment = "attachment ; filename=Contac ts.xls";
Response.ClearC ontent();

Response.AddHea der("content-disposition", attachment);
Response.Conten tType = "applicatio n/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter( sw);
HtmlForm frm = new HtmlForm();

dgAgentActivity .Parent.Control s.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Ad d(dgAgentActivi ty);
frm.RenderContr ol(htw);

Any help will be greatly appreciated.

Thanks.

You can use the Microsoft Office Primary Interop Assemblies. These allow
you to add a references which gives you access to COM components and let
you do just about anything with an office application.

Look up http://msdn2.microsoft.com/en-us/lib...57(VS.80).aspx

Here you should find out which reference to add, and information about
classes and methods.