AshishShakya

Hi,

How can you create formated excel files through a program. By formatting, i mean individual cell background colors, row widths, column heights.. and stuff.

Thanks in advance.



Re: Visual Studio Tools for Office Creating a formatted Microsoft excel file.

TaylorMichaelL

You can use VSTO to create and manipulate any Office document through the programming interface exposed by the application itself. Since this is unrelated to the C# language I'm moving this posting from C# language to the VSTO forum. Someone in that forum can probably provide you more details.

Michael Taylor - 7/12/07

http://p3net.mvps.org





Re: Visual Studio Tools for Office Creating a formatted Microsoft excel file.

Dennis Wallentin

Hi,

This is a rather "open - ended" question as the number of available tools are more then just one

However, You need to provide additional info in order to provide any relevant recommendations.

# Will Excel be available and if so what version(s) are involved.

# Will the file(s) be generated on a Server






Re: Visual Studio Tools for Office Creating a formatted Microsoft excel file.

Peter Ritchie

VSTO is not an API for creating Office files. VSTO is a tool to build applications targeting Office 2007, creating add-ins or document customiztions. It's is not a means of automating Office applications. For discussions relating to automating office applications and documents via .NET see http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.officedev&lang=en&cr=US




Re: Visual Studio Tools for Office Creating a formatted Microsoft excel file.

AshishShakya

Thanks for all your messages.. Let me give the full details to my problems. I'm leaving Office 2007 out of the picture.. So, lets say Office 2003 will be available at the max. You say VSTO is for Office 2007. So, maybe i can't use it... Thanks coz' i'll look into it anyway.

Cheers.





Re: Visual Studio Tools for Office Creating a formatted Microsoft excel file.

Ji Zhou ĘC MSFT

Hi,

In fact, VSTO only supports Word&Excel2003 document-level solution and Outlook2003 AddIns. It is VSTO SE support Office 2007 AddIns. In my opinion, you can use either Office Automation or VSTO in your scenario. But your question is too general. You can get some information from msdn to start:

http://msdn2.microsoft.com/en-us/library/cww296yz(VS.80).aspx

Thanks

Ji