1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
| public void OuvrirFichierXls()
{
OpenFileDialog f = new OpenFileDialog(); //création d'une fenetre d'exploration
f.ShowDialog(); // affichage de cette fenetre
string chemin = f.FileName; // on r
string filePath = chemin;
if (chemin == "")
{
MessageBox.Show("Veuillez choisir un fichier");
}
else
{
Excel.Application oApp;
Excel.Workbook oWB;
Excel.Worksheet oSheet;
System.Reflection.Missing oMsng = System.Reflection.Missing.Value;
oApp = (Excel.Application)new Excel.Application();
oWB = (Excel.Workbook)oApp.Workbooks.Open(filePath, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing);
oSheet = (Excel.Worksheet)oWB.ActiveSheet;
// tbx_xl1.Text = ((Excel.Range)oSheet.Cells[B,2]).Value2.ToString();
for (int i = 1; i < oSheet.Rows.Count + 1; i++)
{
// A la première cellule vide, sortir de la boucle :
if ((oSheet.Cells[i, 1] == null || ((Excel.Range)oSheet.Cells[i, 1]).Value2 == null))
{
break;
}
tbx_xl1.Text = ((Excel.Range)oSheet.Cells[i, 2]).Value2.ToString();
tbx_xl2.Text = ((Excel.Range)oSheet.Cells[i, 3]).Value2.ToString();
tbx_xl1.ReadOnly = true;
tbx_xl2.ReadOnly = true;
}
} |
Partager