Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / how to select record from excel spreadsheet in c#?
Ask Question

How to select record from excel spreadsheet in C#?

Pravesh Singh 8530 17 Aug 2012
Hello Everyone,
Can anyone tell me how to select record from excel spreadsheet using c# code?
c# c#
Updated 03 Dec 2013
Pravesh Singh
Pravesh Singh

Other

Student

Message

3 Answers

Nibaal Bazzi
Nibaal Bazzi 03 Dec 2013
Report Abuse
Hi Pravesh,
you can also try this C# Excel library, it provides a neat and an efficient API's for various spreadsheet files manipulations.
Here is a small sample how you can read an Excel file in C# and retrieve the values from the selected cell.
public object GetSelectedRecord(string fileName, string cellName)
{
    var file = ExcelFile.Load(fileName);
    var sheet = file.Worksheets.ActiveWorksheet;
    var cell = sheet.Cells[cellName];
    return cell.Value;
}

I hope this helps.

Sohail Shaikh
Sohail Shaikh 29 Nov 2012
Report Abuse
http://blueraiden.exofire.net/blog/import-excel-spreadsheet-data-to-datagridview-using-vb-net
AVADHESH PATEL
AVADHESH PATEL 18 Aug 2012
Report Abuse
Hello Pravesh
 
You can use the following code to selecting record from excel spreadsheet in c#
// Create Data Table for MS-Office 2007 or 2003
            System.Data.DataTable dtExcel = new System.Data.DataTable();
            //DataTable Name
            dtExcel.TableName = "MyExcelData";
            //Path of excel file 
            string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='F:\avi\information.xlsx';Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";
            //connectin
            OleDbConnection con = new OleDbConnection(SourceConstr);
            //Query string
            string query = "Select * from [Sheet1$]";
            //DataAdapter object
            OleDbDataAdapter data = new OleDbDataAdapter(query, con);
            //fill record into DataTable
            data.Fill(dtExcel);


Now you can bind DataTable with control for displaying record. You may check following link too.

http://www.mindstick.com/Blog/294/How%20to%20import%20or%20export%20SQL%20Server%20table%20data%20in%20MS%20Excel%20sheet%20using%20C%2023%20Code


I hope it might be resolve your problem.

advertising