public static void Save2Xlsx(string fileName, Dictionary <string, List <Order> > order_dic)
{
Workbook wb = new Workbook();
//清除默认的工作表
wb.Worksheets.Clear();
List <String> sheetlist = new List <String>();
//int no = order_dic.Count;
int no = 1;
foreach (string key in order_dic.Keys)
{
List <Order> orderlist = order_dic[key];
string sn = orderlist.First().Client;
string sheet_name = sn;
if (sn.Length >= 5)
{
sheet_name = sn.Substring(0, 5);
}
if (sheetlist.IndexOf(sn) > -1)
{
int _index = sheetlist.FindAll((String str) => str == sn).Count;
//重复客户，页签名+1
sheet_name += _index.ToString();
}
sheetlist.Add(sn);
Worksheet st = wb.Worksheets.Add(sheet_name);
//创建样式
CellStyle style = wb.Styles.Add("newStyle");
style.Font.FontName = "宋体";
style.Font.Size = 11;
st.ApplyStyle(style);
//创建字体
ExcelFont font1 = wb.CreateFont();
font1.FontName = "宋体";
font1.IsBold = true;
font1.Size = 14;
font1.Underline = FontUnderlineType.Single;
Console.WriteLine("no:{0} key:{1} sheet_name:{2}", no, key, sheet_name);
//foreach (Order order in orderlist)
//{
// Console.WriteLine("key:{0} Model:{1} Num:{2}", key, order.Model, order.Num);
//}
FormatXlsx(no, st, font1, orderlist);
no++;
Thread.Sleep(5);
}
wb.SaveToFile(fileName + "_销售出库单.xlsx", FileFormat.Version2013);
}
