Hou to upload multiple Excel file in c# windows form applica

Question

I have multiple excel file where contains salary sheet data. like that..

EMP1001.xls or EMP1001.xlsx ---- here EMP1001 is a employee no of a employee

month	basic	da	hra	total
jan	20000	15000	3000	38000
feb	19800	14000	2860	36660
mar	23200	16000	3050	42250

EMP1002.xls or EMP1002.xlsx

month	basic	da	hra	total
jan	8000	14000	2500	24500
feb	9000	17000	2100	28100
mar	10000	19000	1800	30800

I create a database table and extract excel data

emp_no	month	basic	da	hra	net
EMP1001	jan	20000	15000	3000	38000
EMP1001	feb	19800	14000	2860	36660
EMP1001	mar	23200	16000	3050	42250
EMP1002	jan	8000	14000	2500	24500
EMP1002	feb	9000	17000	2100	28100
EMP1002	mar	10000	19000	1800	30800

Actually I done all of these process with single file upload.

I want to upload multiple excel file and insert these data into database from excel file.

Please help me.

Leon D · Answer

Hi, Check this article: https://www.c-sharpcorner.com/blogs/import-and-export-data-from-excel-to-database

Prakash Mondal · Answer

Hi Jignes, This link for single file read example. for single file read, I write this bellow code succssfully working... OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.InitialDirectory = @"C:\"; openFileDialog1.Title = "Browse Image Files"; openFileDialog1.CheckFileExists = true; openFileDialog1.CheckPathExists = true; openFileDialog1.DefaultExt = "txt"; openFileDialog1.Filter = "Excel files (*.xls)|*.xls|Excel files (*.xlsx)|*.xlsx"; openFileDialog1.FilterIndex = 2; openFileDialog1.RestoreDirectory = true; openFileDialog1.ReadOnlyChecked = true; openFileDialog1.ShowReadOnly = true; if (openFileDialog1.ShowDialog() == DialogResult.OK) { DataTable dt = new DataTable(); string query = "select * FROM [Sheet1$]"; string connString = ""; string path = openFileDialog1.FileName.ToString(); connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\""; OleDbConnection conn = new OleDbConnection(connString); if (conn.State == ConnectionState.Closed) conn.Open(); OleDbCommand cmd = new OleDbCommand(query, conn); OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataSet ds = new DataSet(); //da.Fill(ds); da.Fill(dt); da.Dispose(); conn.Close(); conn.Dispose(); } then I using loop, read data from dataTable and insert into database. This is fine. ===> these code for browse at a time single excel file upload. But My Query is: I want to browse multiple excel file and read and store into datatable. Please solve.

Jignesh Kumar · Answer

Hi Prakash, Please find below link https://www.encodedna.com/windows-forms/read-an-excel-file-in-windows-forms-application-using-csharp-vbdotnet.htm Here is example of multiple files for pdf, doc, same way you can use for excel, https://www.c-sharpcorner.com/UploadFile/71c5a7/multiple-file-upload-in-Asp-Net585/