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.
-
-
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.Offic e 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.Offi ce" section and notice there is..- Microsoft.Offic e.InfoPath
- Microsoft.Offic e.Interop
- Microsoft.Offic e.Tool
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. -
Thanks. But it comes back to 'How do I convert data/information from C#.net language to Excel 2007 spreadsheet to be displayed?'Comment
-
Start with tutorials on how to programmaticall y make an Excel spreadsheet and go from there. MSDN has many such tutorials.
As you get deeper in, you will want to become familiar with this namespace:
Comment
-
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 supportComment
Comment