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