Hello All Experts Please tell. Can I use Microsoft Excel Sheet in c sharp as addition of Students Monthly fee And save it in SQL Server ?

Recommended Answers

Have a look here: http://csharp.net-informations.com/excel/csharp-excel-tutorial.htm
Excel also supports DB conections.

Jump to Post

All 3 Replies

yes it is possible.

You can also use Microsoft's managed assembly, Open XML SDK, to create native documents for Office 2007 and later.

Code project example using the library:
http://www.codeproject.com/KB/office/OpenXML-SDK-HelloWorld.aspx

The Open XML SDK also includes an awesome tool called the Open XML SDK Productivity Tool that turns *.docx, *.xlsx, etc in to C# code so you can see how the document was created

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.