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 ?
yousafc# 0 Junior Poster in Training
ddanbe 2,724 Professional Procrastinator Featured Poster
Have a look here: http://csharp.net-informations.com/excel/csharp-excel-tutorial.htm
Excel also supports DB conections.
shiva07 3 Light Poster
yes it is possible.
sknake 1,622 Senior Poster Featured Poster
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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.