private void AddRegions(IXLWorksheet worksheet, ExcelSheet sheet)
{
foreach (var dataRegion in sheet.Regions)
{
Throw <ArgumentNullException> .WhenObject.IsNull(() => dataRegion.Coordinates);
_dataFormat = ExcelDataFormatFactory.GetDataFormat(dataRegion.ConfigurationDataFormat);
_excelStyle = ExcelStyleFactory.GetStyle(dataRegion.ConfigurationExcelStyle);
AddHeader(worksheet, dataRegion);
AddRows(worksheet, dataRegion);
SetStyles(worksheet, dataRegion);
dataRegion.Coordinates.HeaderRowInitial++;
}
}
/// <summary>
/// 导出excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonImage2_Click(object sender, EventArgs e)
{
string saveFile = Dialog.GetSaveFile("AddressBook.xls");
if (!string.IsNullOrEmpty(saveFile))
{
DataTable dt = BindGrid();
XlsTransferData transfer = new XlsTransferData();
transfer.StyleType = ExcelStyleFactory.GetExcelStyleType(ExcelStyleType.Default);
byte[] bytes = transfer.GetBytes(dt, true);
FileHelper.WriteFile(saveFile, bytes);
if (MsgBox.Confirm("导出完毕，是否打开文件？"))
{
FileHelper.OpenFile(saveFile);
}
}
}
