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"); }
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 Main() { //String sqltext = "select id, sex name from memcard"; // DataSet ds = ExecuteQuery(sqltext); //testExport(ds, "c:/mem.xls"); ExcalHelper obj = new ExcalHelper(4); DataTable _data = obj.ImportExcelFile("c:/mem.xls"); _data.TableName = "memcard"; if (_data != null && _data.Rows.Count > 0) { SqlBulkCopy bcp = new SqlBulkCopy("server=sql.w3249.vhostgo.com;database=vipsoft;uid=vipsoft;pwd=vip123456"); bcp.DestinationTableName = "memcard"; bcp.WriteToServer(_data); bcp.Close(); } }