public void WriteExcel() { using (ExcelHelper excel = new ExcelHelper("abcds.xls")) { excel.Hdr = "YES"; excel.Imex = "0"; Dictionary<string, string> tableDefinition = new Dictionary<string, string>(); tableDefinition.Add("Name", "ntext"); tableDefinition.Add("Age", "ntext"); tableDefinition.Add("Class", "ntext"); excel.WriteTable("Student", tableDefinition); StringBuilder sb = new StringBuilder(); // //for (int i = 0;i <100; i++) // //{ sb.Append(" insert into [Student] (Name,Age,Class) values ("); //// } // sb.Append("'"); sb.Append("a"); sb.Append("',"); sb.Append("'"); sb.Append("b"); sb.Append("',"); sb.Append("'"); sb.Append("c"); sb.Append("'"); sb.Append(")"); Console.WriteLine(sb.ToString()); excel.ExecuteCommand(sb.ToString()); // excel.ExecuteCommand(sql); } }
//创建ExcelHelper private static ExcelHelper CreateExcelForRivalPrice(string sheetName) { FileHelper.CreateDirectory("Sku"); string filePath = @"Sku\{0} 分析淘宝.xls".StringFormat(DateTime.Now.ToString("yyyy-MM-dd")); var excel = new ExcelHelper(filePath); excel.Imex = "0"; excel.Hdr = "YES"; if (File.Exists(filePath)) { if (SysUtils.CheckTableExsit(excel, sheetName)) { return excel; } } Dictionary<string, string> dic = new Dictionary<string, string>(); dic.Add("款号", "double"); dic.Add("售价", "double"); dic.Add("成本价", "double"); dic.Add("利润", "double"); dic.Add("价格", "double"); dic.Add("邮费", "double"); dic.Add("总价", "double"); dic.Add("销量", "double"); dic.Add("评价数", "double"); dic.Add("用户名", "varchar(255)"); dic.Add("地点", "varchar(255)"); dic.Add("标题", "varchar(255)"); dic.Add("网址", "varchar(255)"); dic.Add("SKU", "varchar(255)"); dic.Add("成交记录", "text"); excel.WriteTable(sheetName, dic); return excel; }
//创建ExcelHelper 该EXCEL是用于存放SKU数据 private ExcelHelper CreateExcelForBanggoSku(string sheetName) { FileHelper.CreateDirectory(Resource.SysConfig_Sku); string filePath = @"Sku\{0} banggoSku.xls".StringFormat(DateTime.Now.ToString("yyyy-MM-dd")); var excel = new ExcelHelper(filePath) { Imex = "0", Hdr = "YES" }; if (File.Exists(filePath)) { if (SysUtils.CheckTableExsit(excel, sheetName)) { return excel; } } var dic = new Dictionary<string, string> { {"产品地址", "varchar(255)"}, {"款号", "Double"}, {"售价", "Double"}, {"库存","Double"}, {"SKU", "text"}, {"售完","Double"} }; excel.WriteTable(sheetName, dic); return excel; }
//创建ExcelHelper 该EXCEL是用于存放SKU数据 private ExcelHelper CreateExcelForSell(string sheetName) { FileHelper.CreateDirectory("Sell"); string filePath = @"Sell\{0} 销售.xls".StringFormat(DateTime.Now.ToString("yyyy-MM-dd")); var excel = new ExcelHelper(filePath) { Imex = "0", Hdr = "YES" }; if (File.Exists(filePath)) { if (SysUtils.CheckTableExsit(excel, sheetName)) { return excel; } } var dic = new Dictionary<string, string> { {"订单编号", "varchar(255)"}, {"卖出时间", "varchar(255)"}, {"货源", "varchar(255)"}, {"购买人", "varchar(255)"}, {"款号", "Double"}, {"颜色", "varchar(255)"}, {"尺码", "varchar(255)"}, {"商品属性", "varchar(255)"}, {"原价", "Double"}, {"买家应付邮费", "Double"}, {"单件售价", "Double"}, {"购买数量", "Double"}, {"支出邮费", "Double"}, {"销售金额", "Double"}, {"付款金额", "Double"}, {"退款金额", "Double"}, {"利润", "varchar(255)"}, {"结帐情况", "varchar(255)"}, {"结帐时间", "varchar(255)"}, {"购买帐号", "varchar(255)"}, {"备注", "varchar(255)"}, }; excel.WriteTable(sheetName, dic); return excel; }