changing design/apperance in excel from VB.NET

[Tomek]

Hi,
Please help me with this. I'm exporting data to excel file and I want to
customize its apperance (i.e. bold columns name, auto size colums width,
freeze some columns). Is it possible?
I'm asking how to do it from Visual Basic .NET not from VBA. It is easy
to do it in Excel but I want to do it from my VB.NET application.
Thanks in advance,
Tomek

[Cor Ligthert]

Hi Tomek,

Did you already look here,

Office
http://support.microsoft.com/default...b;EN-US;311452

http://msdn.microsoft.com/office/

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en

And how to use Excel in VB.net you can see here
http://www.kjmsolutions.com/datasetarray.htm

I hope this helps?

Cor

Please help me with this. I'm exporting data to excel file and I want to
customize its apperance (i.e. bold columns name, auto size colums width,
freeze some columns). Is it possible?
I'm asking how to do it from Visual Basic .NET not from VBA. It is easy
to do it in Excel but I want to do it from my VB.NET application.
Thanks in advance,
Tomek

[Tomek]

Thanks for links.
I have strange error in all samples:
"Old format or invalid type library."
What's it means?
Tomek

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:eX**************@TK2MSFTNGP11.phx.gbl...

Hi Tomek,

Did you already look here,

Office
http://support.microsoft.com/default...b;EN-US;311452

http://msdn.microsoft.com/office/

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en
And how to use Excel in VB.net you can see here
http://www.kjmsolutions.com/datasetarray.htm

I hope this helps?

Cor

Please help me with this. I'm exporting data to excel file and I want to
customize its apperance (i.e. bold columns name, auto size colums width,
freeze some columns). Is it possible?
I'm asking how to do it from Visual Basic .NET not from VBA. It is easy
to do it in Excel but I want to do it from my VB.NET application.
Thanks in advance,
Tomek