Converting data from C#.Net to Excel 2007

[rshin2020]

How do I convert data/information from C#.net language to Excel 2007 spreadsheet to be displayed? I have no clear idea at all how this is going to take place. If the codes are given, how do i test them? Is it just copy and paste? I'm very new to C#.net as i just started reading. Because of work purpose, I need a quick guide as to how to solve this. Need some help asap. Thanks.

[tlhintoq]

There is no "quickie guide" for this.
An actual understanding of both C# and MS Office is required.
Add to that practice and understanding of the Microsoft.Office namespaces.

Open any WIndows Forms project in Visual studio.
Right-click on the project and choose "Add reference..."
In the next dialog choose the ".NET" tab.
Scroll down to "Microsoft.Office" section and notice there is..

• Microsoft.Office.InfoPath
• Microsoft.Office.Interop
• Microsoft.Office.Tool

s
Each of those have sub areas.

This will actually require learning and practice on small projects before starting anything that might be considered ready for an employer.

[rshin2020]

Thanks. But it comes back to 'How do I convert data/information from C#.net language to Excel 2007 spreadsheet to be displayed?'

[tlhintoq]

Start with tutorials on how to programmatically make an Excel spreadsheet and go from there. MSDN has many such tutorials.
http://msdn.microsoft.com/en-us/libr...86(VS.80).aspx

As you get deeper in, you will want to become familiar with this namespace:
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[RyanALEX]

I suggest to use a c#/VB.net excel component, There are great 3rd party components in the market that do the same job (or even better).
From a comparison testing I performed about a year ago Spire.XLS for .NET is the best from the following perspectives:
1. Read/Write of excel
2. Support of embedding images
3. Size of result Excel file is very small
4. Convenient API and very similar to Office's one
5. Multi-threaded and multi-process support