private void CreateExcelTree() { List <ExcelDataHelper> Excels = new List <ExcelDataHelper>(); foreach (TreeNode rnode in treeView1.Nodes[0].Nodes) { string fname = rnode.Tag as string; TreeNode node = treeView1.Nodes[0].Nodes[Path.GetFileName(fname)]; ExcelDataHelper edh = new ExcelDataHelper(fname); Excels.Add(edh); string[] sheetnames = edh.GetSheetNames(); foreach (string sheet in sheetnames) { TreeNode cnode = new TreeNode(); cnode.Text = sheet; cnode.Name = sheet; node.Nodes.Add(cnode); GZDataTable gzdt = GZDataTable.ImportFromExcel(fname, sheet); string[] cols = gzdt.GetColumnsName(); foreach (string col in cols) { cnode.Nodes.Add(col); } } } }
public static GZDataTable ImportFromExcel(string filepath) { ExcelDataHelper excel = new ExcelDataHelper(filepath); DataSet ds = excel.ToDataSet(true, 2); GZDataTable gzdt = new GZDataTable(ds.DataSetName, ds.Tables[0].TableName, ds.Tables[0]); return(gzdt); //return NPOIHelper.Import(filepath); }
public void ExportToExcel() { ExcelDataHelper excel = new ExcelDataHelper(); DataSet ds = new System.Data.DataSet(); ds.Tables.Add(this); excel.FromDataSet(ds, true); excel.SaveAs("c_" + TableTile + DateStr + ".xls"); //NPOIHelper.Export(this, TableTile, DateStr, "c_" + TableTile+DateStr+".xls"); }
public static GZDataTable ImportFromExcel(string filepath, string sheetname) { ExcelDataHelper excel = new ExcelDataHelper(filepath); DataTable dt = excel.ToDataTable(sheetname, true, 2); GZDataTable gzdt = new GZDataTable(Path.GetFileName(filepath), sheetname, dt); return(gzdt); //return NPOIHelper.Import(filepath); }