public static void TestUserSet()
{
string localFilePath = "D:\\工艺工段.xlsx";
ExcelExport export = new ExcelExport();
ExcelStyle excelStyle = new ExcelStyle();//通常情况下，不需要修改EscelStyle
excelStyle.MaxColWidth = 100;
excelStyle.MinColWidth = 100;
excelStyle.BorderColor = Color.Black;
excelStyle.BorderStyle = Consts.BorderStyle.Thin;
List <Cell> list = new List <Cell>();
list.Add(new Cell("工艺工段", "A1", "N1")
{
MaxHeight = 18, MinHeight = 18
});
list.Add(new Cell("计划开始生产时间", 0, 1)
{
TextAlign = Consts.TextAlign.BottomCenter
});
list.Add(new Cell("工艺厂商", 1, 1)
{
BackgroundColor = Color.Yellow
});
list.Add(new Cell("工艺部件", 2, 1)
{
BackgroundColor = Color.Yellow
});
list.Add(new Cell("工艺发出时间", 3, 1));
list.Add(new Cell("工艺发出数量", 4, 1));
list.Add(new Cell("工艺完成时间", 5, 1));
list.Add(new Cell("数量", 6, 1));
list.Add(new Cell("欠数", 7, 1));
list.Add(new Cell("工艺剪生产周期时间", 8, 1));
list.Add(new Cell("异常停顿开始时间", 9, 1));
list.Add(new Cell("异常原因", 10, 1));
list.Add(new Cell("异常恢复生产时间", 11, 1));
list.Add(new Cell("欠数原因", 12, 1));
list.Add(new Cell("计划生产完成时间", 13, 1));
ExcelPackage package = null;
try
{
package = new ExcelPackage();
var sheetName = "Sheet1";
var sheet = package.Workbook.Worksheets.Add(sheetName);
export.Export(list, sheet, excelStyle);//不需要修改整体样式时，不需要传递excelStyle
FileInfo f = new FileInfo(localFilePath);
package.SaveAs(f);
System.Diagnostics.Process.Start(localFilePath);
}
catch (Exception ex)
{
}
finally
{
if (package != null)
{
package.Dispose();
}
}
}
public static void TestLayout()
{
Image image = new Bitmap(1000, 5000);
Graphics graphics = Graphics.FromImage(image);
var text = "我站在北京天安门广场观看升国旗,五星红旗随风飘扬";
var fontSize = new ExcelStyle().FontSize;
var fontFamily = new ExcelStyle().FontFamily;
var sz = graphics.MeasureString(text, new Font(fontFamily, fontSize), 1000);
graphics.DrawString(text, new Font(fontFamily, fontSize), new SolidBrush(Color.Black), 0, 0);
image.Save("D:\\DrawString.bmp");
ExcelExport export = new ExcelExport();
List <Cell> list = new List <Cell>();
list.Add(new Cell("我站在北京天安门广场观看升国旗")
{
RowIndex = 0, ColIndex = 0, Rowspan = 1, TextAlign = Consts.TextAlign.MiddleLeft
});
list.Add(new Cell("我站在北京天安门广场观看升国旗,五星红旗随风飘扬")
{
RowIndex = 0, ColIndex = 1, Colspan = 2
});
list.Add(new Cell(DateTime.Now)
{
RowIndex = 0, ColIndex = 4
});
list.Add(new Cell("2,2")
{
RowIndex = 1, ColIndex = 1
});
list.Add(new Cell("2,3")
{
RowIndex = 1, ColIndex = 2
});
list.Add(new Cell("2,4")
{
RowIndex = 1, ColIndex = 3
});
list.Add(new Cell("2,5")
{
RowIndex = 1, ColIndex = 4
});
list.Add(new Cell(string.Empty)
{
RowIndex = 2, ColIndex = 5, MinWidth = Cell.GetPixelWidth(60), MinHeight = Cell.GetPixelHeight(60)
}); //测试空内容撑开
list.Add(new Cell("测试宽度是否会自动撑开")
{
RowIndex = 2, ColIndex = 6, MinWidth = Cell.GetPixelWidth(15)
});
list.Add(new Cell("测试高度是否会自动撑开")
{
RowIndex = 3, ColIndex = 7, MaxWidth = 60
});
ExcelPackage package = null;
try
{
var localFilePath = "D:\\Text.xlsx";
package = new ExcelPackage();
var sheetName = "Sheet1";
var sheet = package.Workbook.Worksheets.Add(sheetName);
export.Export(list, sheet);
FileInfo f = new FileInfo(localFilePath);
package.SaveAs(f);
System.Diagnostics.Process.Start(localFilePath);
}
catch (Exception ex)
{
}
finally
{
if (package != null)
{
package.Dispose();
}
}
}
