form请求导出表格_导出excel时，以form方式提交json数据

///

///导出excel///

///

private void Export(ListclassList)

{//判读是否为空

if (classList.Count == 0)

{return;

}try{//实例化一个 workbook

Workbook workbook = newWorkbook();//打开模板(在服务器上)

string path = System.Web.HttpContext.Current.Server.MapPath("~");

path= path.Substring(0, path.LastIndexOf("\\"));

path+= @"\file\ExcelTemplate\班级信息表.xlsx";

workbook.Open(path);int rows =classList.Count;int index = 4;int i = 1;//获得一个worksheet

Worksheet master = workbook.Worksheets[0];

workbook.Worksheets.Add("班级信息");

Worksheet sheet= workbook.Worksheets["班级信息"];

sheet.Copy(master);foreach (P_ClassInfoVO item inclassList)

{

Cells cells=sheet.Cells;//表格内容填写

cells["A" + index.ToString()].PutValue(i++);

cells["B" +index.ToString()].PutValue(item.C_Name);

cells["C" +index.ToString()].PutValue(item.C_Code);

cells["D" +index.ToString()].PutValue(item.Sp_Name);

cells["E" +index.ToString()].PutValue(item.C_StartClassTime);

cells["F" +index.ToString()].PutValue(item.C_CloseClassTime);

cells["G" +index.ToString()].PutValue(item.C_StudyLength);

cells["H" +index.ToString()].PutValue(item.T_Name);

cells["I" +index.ToString()].PutValue(item.C_StateStr);

cells["J" +index.ToString()].PutValue(item.C_Other);

index++;

}

workbook.Worksheets.RemoveAt(0);

Random rd= newRandom();string fileName = "班级信息" + DateTime.Now.ToString("yyyyMMddhhmmss") + rd.Next(10, 100) + ".xls";//ie需要编码(浏览器内核)

if (Request.UserAgent.ToLower().Contains("trident"))

{//保存文件

fileName =HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8);

}

workbook.Save(fileName, FileFormatType.Excel2003, SaveType.OpenInExcel, System.Web.HttpContext.Current.Response, System.Text.Encoding.UTF8);

HttpContext.Current.ApplicationInstance.CompleteRequest();

}catch{

}finally{

GC.Collect();

}

}