Import and save Excel file ???
C#
2
Posts
2
Posters
0
Views
1
Watching
-
hi ! How can I open excel file, show it on DataGrid, then save it into Database(SQLServer) ???
You can have a look into the COM component "Microsoft Excel 11.0 Object Library" which is avilable in IDE COM tab once you have office installed in your machine. This class will expose lot of operations which we can deal with excel files. please find MSDN for more info and code samples. Please read this article too Working With excel Sreejith Nair [ My Articles ]