private void button1_Click(object sender, EventArgs e) { excell exc = new excell(VeriTabani2, 1); int sil = Convert.ToInt32(textBox1.Text); exc.DeleteWorksheet(sil + 1); exc.kapat(); veritabanigoster(); }
//-------------------------------------------- VERİLERİ ÇEK ---------------------------------------------- public void OpenFile() { excell excel = new excell(@"" + VeriTabani + "", 1); Dizi[1, 0] = excel.ReadCell(1, 1); Dizi[2, 0] = excel.ReadCell(2, 1); Dizi[3, 0] = excel.ReadCell(3, 1); Dizi[4, 0] = excel.ReadCell(4, 1); Dizi[5, 0] = excel.ReadCell(5, 1); Dizi[6, 0] = excel.ReadCell(6, 1); Dizi[7, 0] = excel.ReadCell(7, 1); Dizi[8, 0] = excel.ReadCell(8, 1); Dizi[9, 0] = excel.ReadCell(9, 1); Dizi[10, 0] = excel.ReadCell(10, 1); Dizi[11, 0] = excel.ReadCell(11, 1); Dizi[12, 0] = excel.ReadCell(12, 1); Dizi[1, 5] = excel.ReadCell(1, 0); Dizi[2, 5] = excel.ReadCell(2, 0); Dizi[3, 5] = excel.ReadCell(3, 0); Dizi[4, 5] = excel.ReadCell(4, 0); Dizi[5, 5] = excel.ReadCell(5, 0); Dizi[6, 5] = excel.ReadCell(6, 0); Dizi[7, 5] = excel.ReadCell(7, 0); Dizi[8, 5] = excel.ReadCell(8, 0); Dizi[9, 5] = excel.ReadCell(9, 0); Dizi[10, 5] = excel.ReadCell(10, 0); Dizi[11, 5] = excel.ReadCell(11, 0); Dizi[12, 5] = excel.ReadCell(12, 0); Dizi2[1] = Convert.ToInt16(excel.ReadCell(1, 2)); Dizi2[2] = Convert.ToInt16(excel.ReadCell(2, 2)); Dizi2[3] = Convert.ToInt16(excel.ReadCell(3, 2)); Dizi2[4] = Convert.ToInt16(excel.ReadCell(4, 2)); Dizi2[5] = Convert.ToInt16(excel.ReadCell(5, 2)); Dizi2[6] = Convert.ToInt16(excel.ReadCell(6, 2)); Dizi2[7] = Convert.ToInt16(excel.ReadCell(7, 2)); Dizi2[8] = Convert.ToInt16(excel.ReadCell(8, 2)); Dizi2[9] = Convert.ToInt16(excel.ReadCell(9, 2)); Dizi2[10] = Convert.ToInt16(excel.ReadCell(10, 2)); Dizi2[11] = Convert.ToInt16(excel.ReadCell(11, 2)); Dizi2[12] = Convert.ToInt16(excel.ReadCell(12, 2)); excel.kapat(); }