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);
}
