1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| private void button2_Click(object sender, EventArgs e)
{
Open.ShowDialog();
if (Open.FileName != null)
{
//int i;
_Application Excel = new ApplicationClass();
_Workbook Classeur = Excel.Workbooks.Open(Open.FileName, 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);
Excel.Visible = true;
_Worksheet FStocks = (_Worksheet)Classeur.Sheets.Item[3];
DataRow Stock = BDD.Stocks.NewRow();
Stock["Id_Stock"] = Convert.ToString((FStocks.Cells.Item[2, 3] as Range).Value);
BDD.Stocks.Rows.Add(Stock);
MessageBox.Show(Convert.ToString((FStocks.Cells.Item[2, 3] as Range).Value), "Info", MessageBoxButtons.OK);
}
} |
Partager