static void testExport(DataSet ds, String path)
{
String[] title = new String[] { "编号", "姓名", "性别" };
int[] width = new int[] { 20, 20, 20 };
ExcalHelper e = new ExcalHelper("测试", title, width, 1);
e.ExportExcel(ds, path);
}
static void testExport()
{
DataSet ds = new DataSet();
DataTable db = new DataTable("tb0");
DataColumn dc = null;
dc = db.Columns.Add("id", Type.GetType("System.String"));
dc = db.Columns.Add("name", Type.GetType("System.String"));
dc = db.Columns.Add("sex", Type.GetType("System.String"));
ds.Tables.Add(db);
DataRow row = ds.Tables[0].NewRow();
row["id"] = "1";
row["name"] = "张三";
row["sex"] = "男";
ds.Tables[0].Rows.Add(row);
DataRow row2 = ds.Tables[0].NewRow();
row["id"] = "2";
row["name"] = "李四";
row["sex"] = "男";
ds.Tables[0].Rows.Add(row2);
String[] title = new String[] { "编号", "姓名", "性别" };
int[] width = new int[] { 20, 20, 20 };
ExcalHelper e = new ExcalHelper("测试", title, width, 1);
e.ExportExcel(ds, "c:/b.xls");
}
