Reading Data from an Excel File Using C#! Help please!
C#
1
Posts
1
Posters
0
Views
1
Watching
-
Hi, I am trying to read data from an Excel spreadsheet cell by cell which contains data with which I want to perform string manipulation and then save to SQL srvr..all the data in the spreadsheet are of a string data type.. I have recieved some help from one of the members of this site who gave me some direction, but using VB.NET code...I want to specifically use C# for this task. How do i open the .xls file in order to read data from it?? How do I read the data from the cell(s) in a specified worksheet?? and (if i need to) how do i close the .xls file?? any advice and help will be greatly appreciated. Thanks a million.. Afzal Hassen Afzal Hassen