<pre>using (OpenFileDialog openFileDialog = new OpenFileDialog() { Filter = "Excel 97-2003 Workbook|*.xls|Excel Workbook|*.xlsx |fichiers Textes (*.txt)|*.txt|fichiers CSV (*.csv)|*.csv|tous les fichiers (*.*)|*.*" })
{
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
TextBox_Emplacement.Text = openFileDialog.FileName;
using (var stream = File.Open(openFileDialog.FileName, FileMode.Open, FileAccess.Read))
{
using (IExcelDataReader reader = ExcelReaderFactory.CreateReader(stream))
{
DataSet result = reader.AsDataSet(new ExcelDataSetConfiguration()
{
ConfigureDataTable = (_) => new ExcelDataTableConfiguration() { UseHeaderRow = true }
});
dataTableCollection = result.Tables;
dataTableCollection1 = result.Tables;
sheet.Items.Clear();
foreach (DataTable table in dataTableCollection)
sheet.Items.Add(table.TableName);
Form_Copie cp1 = (Form_Copie)Application.OpenForms["Form_Copie"];
foreach (DataTable table in dataTableCollection)
cp1.radDropDownList1.Items.Add(table.TableName);