Esempio n. 1
0
        void get_columnheads()
        {
            cbColumn.Items.Clear();
            cbColumn.Text = "";
            AutoCompleteStringCollection nac;
            List <string> ts;

            Program.all_cells  = new List <List <string> >();
            Program.start_row  = (long)lStartRow.Value;
            Program.col_values = new List <AutoCompleteStringCollection>();
            Program.col_index  = new List <long>();
            for (int c = 1; c <= 50; c++)
            {
                if (Program.sheet.Cells[Program.start_row, c].Value != null)
                {
                    if (Program.sheet.Cells[Program.start_row, c].Value.ToString().Length > 0)
                    {
                        cbitem i = new cbitem(c, Program.sheet.Cells[Program.start_row, c].Value.ToString());
                        cbColumn.Items.Add(i);
                        Program.col_index.Add(c);
                        nac = new AutoCompleteStringCollection();
                        ts  = new List <string>();
                        fill_col_values(ref nac, ref ts, c);
                        Program.all_cells.Add(ts);
                        Program.col_values.Add(nac);
                    }
                }
            }
            if (cbColumn.Items.Count > 0)
            {
                cbColumn.SelectedIndex = 0;
            }
        }
Esempio n. 2
0
        void load_sheets()
        {
            cbSheet.Items.Clear();
            int i = 1;

            foreach (Microsoft.Office.Interop.Excel.Worksheet ws in Program.book.Worksheets)
            {
                cbitem item = new cbitem(i, ws.Name);
                cbSheet.Items.Add(item);
                i++;
            }
            Program.start_row     = (long)lStartRow.Value + 1;
            Program.row           = Program.start_row;
            cbSheet.SelectedIndex = 0;
        }