Exemple #1
0
        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();
        }
Exemple #2
0
        //-------------------------------------------- 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();
        }