private void btnExport_Click(object sender, EventArgs e)
{
SaveFileDialog sfd = new SaveFileDialog();
//文件后缀列表
sfd.Filter = "Excel文件(*.xls)|*.xls|Excel文件(*.xlsx)|*.xlsx";
//默然路径是系统当前路径
sfd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
if (sfd.ShowDialog() == DialogResult.Cancel)
{
return;
}
string fileName = sfd.FileName;
if (dgvReport.DataSource == null)
{
return;
}
if (NPOIService.DgvToExcel(fileName, dgvReport))
{
MessageBox.Show("文件保存成功", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("文件保存失败", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Initializes a new instance of the MainViewModel class.
/// </summary>
public MainViewModel()
{
////if (IsInDesignMode)
////{
//// // Code runs in Blend --> create design time data.
////}
////else
////{
//// // Code runs "for real"
////}
ChangePageCommand = new RelayCommand(ChangePage);
mainModel = new MainModel();
string filePath = @"D:\²Ö¿âÎïÁÏ×ܱí.xlsx";
NPOIService.ExcelToDataTable(filePath);
}
/// <summary>
/// Excel导出demo
/// </summary>
/// <returns></returns>
public ActionResult ExcelExport()
{
//1、获取数据
var list = settlementList;
//2、IWorkbook 和ISheet
IWorkbook workbook = new HSSFWorkbook();//new XSSFWorkbook();
ISheet sheet = workbook.CreateSheet("对账单");
//3、设置导出的列
List <ExcelColumn> columns = new List <ExcelColumn>();
columns.Add(new ExcelColumn <SettlementModel> {
FieldExpr = u => u.Id
});
columns.Add(new ExcelColumn <SettlementModel>
{
FieldExpr = u => u.BussinessType,
Name = "业务类型2",
OnDataBind = (value, item, cell) => item.BussinessType == 1 ? "月结对账单" : "季度结对账单"
});
columns.Add(new ExcelColumn <SettlementModel> {
FieldExpr = u => u.CreateDateBegin, Width = 100
});
columns.Add(new ExcelColumn <SettlementModel> {
FieldExpr = u => u.CreateDateEnd
});
columns.Add(new ExcelColumn <SettlementModel> {
FieldExpr = u => u.SerialId
});
columns.Add(new ExcelColumn <SettlementModel> {
FieldExpr = u => u.Title
});
//4、把数据和列做绑定
NPOIService.ListToExcel(workbook, sheet, list, columns);
//5、导出excel
return(ExportExcel(DateTime.Now.ToString("yyyyMMddHHmmss"), workbook));
}
/// <summary>
/// Excel导入案例
/// </summary>
/// <returns></returns>
public ActionResult ExcelImport()
{
try
{
IWorkbook workbook = NPOIService.GetWorkbook(HttpContext.Request);
ISheet sheet = workbook.GetSheetAt(0);
List <ExcelColumn> columns = new List <ExcelColumn>();
columns.Add(new ExcelColumn <SettlementModel> {
FieldExpr = u => u.Id
});
columns.Add(new ExcelColumn <SettlementModel> {
FieldExpr = u => u.BussinessType
});
columns.Add(new ExcelColumn <SettlementModel> {
FieldExpr = u => u.CreateDateBegin, AllowNull = true
});
columns.Add(new ExcelColumn <SettlementModel> {
FieldExpr = u => u.CreateDateEnd
});
columns.Add(new ExcelColumn <SettlementModel> {
FieldExpr = u => u.SerialId
});
columns.Add(new ExcelColumn <SettlementModel> {
FieldExpr = u => u.Title
});
var list = NPOIService.ExcelToList <SettlementModel>(workbook, sheet, columns);
//业务逻辑处理
}
catch (Exception ex)
{
//异常处理
}
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
