private void sb_newwork_Click(object sender, EventArgs e) { XtraTabPage xinka = new XtraTabPage(); xinka.Name = "xin"; xinka.Text = "新工作区"; NepCalaTable xintab = new NepCalaTable(); xintab.Dock = DockStyle.Fill; xinka.Controls.Add(xintab); this.xtraTabControl1.TabPages.Add(xinka); this.xtraTabControl1.SelectedTabPage = xinka; this.active_nepCalaTable = xintab; }
private void sb_import_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); DataTable dt = null; OpenFileDialog sflg = new OpenFileDialog(); sflg.Filter = "Excel(*.xls)|*.xls|Excel(*.xlsx)|*.xlsx"; if (sflg.ShowDialog() == System.Windows.Forms.DialogResult.Cancel) { return; } FileStream fs = new FileStream(sflg.FileName, FileMode.Open, FileAccess.Read); NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(fs); int sheetCount = book.NumberOfSheets; for (int sheetIndex = 0; sheetIndex < sheetCount; sheetIndex++) { string st_name = book.GetSheetName(sheetIndex); XtraTabPage xinka = new XtraTabPage(); xinka.Name = "xin"; xinka.Text = st_name; NepCalaTable xintab = new NepCalaTable(); xintab.Dock = DockStyle.Fill; xinka.Controls.Add(xintab); this.xtraTabControl1.TabPages.Add(xinka); this.xtraTabControl1.SelectedTabPage = xinka; this.active_nepCalaTable = xintab; NPOI.SS.UserModel.ISheet sheet = book.GetSheetAt(sheetIndex); if (sheet == null) { continue; } NPOI.SS.UserModel.IRow row = sheet.GetRow(0); if (row == null) { continue; } int firstCellNum = row.FirstCellNum; int lastCellNum = row.LastCellNum; if (firstCellNum == lastCellNum) { continue; } dt = new DataTable(sheet.SheetName); dt.Columns.Add("bushe_xianshu", typeof(int)); //MessageBox.Show(dt.Columns["bushe_xianshu"].DataType.ToString()); dt.Columns.Add("bushe_daoshu", typeof(int)); dt.Columns.Add("bushe_zongdaoshu", typeof(int)); dt.Columns.Add("banqian_daoshu", typeof(int)); dt.Columns.Add("ke_caiji", typeof(int)); dt.Columns.Add("banjia_daoshu", typeof(int)); dt.Columns.Add("hengxiangchang", typeof(int)); dt.Columns.Add("zongxiangchang", typeof(int)); dt.Columns.Add("zonghengbi", typeof(double)); dt.Columns.Add("paodaobi", typeof(double)); lastCellNum = 10; for (int i = firstCellNum; i < lastCellNum; i++) { dt.Columns.Add(row.GetCell(i).StringCellValue, typeof(string)); } for (int i = 1; i <= sheet.LastRowNum; i++) { DataRow newRow = dt.Rows.Add(); for (int j = firstCellNum; j < lastCellNum; j++) { newRow[j] = sheet.GetRow(i).GetCell(j).StringCellValue; } } NPOI.SS.UserModel.IRow row0 = sheet.GetRow(0); this.active_nepCalaTable.jifa_dianju.Text = row0.GetCell(13).StringCellValue; row0 = sheet.GetRow(1); this.active_nepCalaTable.jieshou_dianju.Text = row0.GetCell(13).StringCellValue; row0 = sheet.GetRow(2); this.active_nepCalaTable.jieshou_dianshu.Text = row0.GetCell(13).StringCellValue; row0 = sheet.GetRow(3); this.active_nepCalaTable.jifa_xianju.Text = row0.GetCell(13).StringCellValue; row0 = sheet.GetRow(4); this.active_nepCalaTable.jieshou_xianju.Text = row0.GetCell(13).StringCellValue; row0 = sheet.GetRow(5); this.active_nepCalaTable.muban_zong.Text = row0.GetCell(13).StringCellValue; row0 = sheet.GetRow(6); this.active_nepCalaTable.mobanpao.Text = row0.GetCell(13).StringCellValue; row0 = sheet.GetRow(7); this.active_nepCalaTable.jieshou_xianshu.Text = row0.GetCell(13).StringCellValue; row0 = sheet.GetRow(8); this.active_nepCalaTable.muban_heng.Text = row0.GetCell(13).StringCellValue; row0 = sheet.GetRow(9); this.active_nepCalaTable.bushe_jieshouxianshu.Text = row0.GetCell(13).StringCellValue; row0 = sheet.GetRow(10); this.active_nepCalaTable.bushe_jifaxianshu.Text = row0.GetCell(13).StringCellValue; ds.Tables.Add(dt); this.active_nepCalaTable.DDT = dt; } }