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

Hi,

 

Check this article:

 

https://www.c-sharpcorner.com/blogs/import-and-export-data-from-excel-to-database 

Hi Jignes,

 

This link for single file read example.

 

 

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.

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/