Breaking News: Grepper is joining You.com. Read the official announcement!

c# read excel file stack overflow

dr4ft answered on September 14, 2023 Popularity 2/10 Helpfulness 1/10

answer c# read excel file stack overflow

c# read excel file stack overflow

Comment

//ref https://stackoverflow.com/questions/15793442/how-to-read-data-from-excel-file-using-c-sharp 
private void GetExcel()
        {
            string fullPathToExcel = "<Path to Excel file>"; //ie C:\Temp\YourExcel.xls
            string connString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0;HDR=yes'", fullPathToExcel);
            DataTable dt = GetDataTable("SELECT * from [SheetName$]", connString);

            foreach (DataRow dr in dt.Rows)
            {
                //Do what you need to do with your data here
            }
        }

Popularity 2/10 Helpfulness 1/10 Language csharp

Source: Grepper

Tags: c# excel file stack-overflow

Link to this answer
Share Copy Link

Contributed on Sep 14 2023

dr4ft

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

c# read excel file stack overflow

Contents

More Related Answers

c# read excel file stack overflow

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.