部署IIS后excel导出问题请教
在本地测试是没有任何问题的,但是部署到IIS上后别的机子访问,导出excel没任何反应,点按钮页面就刷新下也不报什么错.求高手帮帮忙。。。
以下是导出大体方法:
private void ExportExcel(Page page, string fileName, DataTable dt)
{
if (page == null)
{
return;
}
IOExcel excel = new IOExcel();
excel.CreateExcel(fileName);
DataTable dtExport = FillDataTable(dt);
//int rowCount = dt.Rows.Count;
int colCount = dtExport.Columns.Count;
int rowCount = dtExport.Rows.Count;
for (int col = 0; col < colCount; col++)
{
excel.SetRangeValue(1, col + 1, "");
excel.SetRangeValue(2, col + 1, "");
excel.SetRangeValue(3, col + 1, "");
excel.SetRangeValue(4, col + 1, "");
}
excel.MergeRange(1, 1, 2, 11);
excel.SetRangeValue(1, 1, "全省农民培训月报汇总");
excel.MergeRange(3, 1, 4, 1);
excel.SetRangeValue(3, 1, "编号");
excel.MergeRange(3, 2, 4, 2);
excel.SetRangeValue(3, 2, "县别、类别");
excel.MergeRange(3, 3, 4, 3);
excel.SetRangeValue(3, 3, "使用技术培训");
excel.MergeRange(3, 4, 4, 4);
excel.SetRangeValue(3, 4, "上网技能培训");
excel.MergeRange(3, 5, 4, 5);
excel.SetRangeValue(3, 5, "职业农民培训");
excel.MergeRange(3, 6, 3, 11);
excel.SetRangeValue(3, 6, "农民创业培训");
excel.SetRangeValue(4, 6, "农民专业合作负责人");
excel.SetRangeValue(4, 7, "农产品经纪人");
excel.SetRangeValue(4, 8, "园区基地企业负责人");
excel.SetRangeValue(4, 9, "农业服务业");
excel.SetRangeValue(4, 10, "其他");
excel.SetRangeValue(4, 11, "小计");
//excel填充数据
for (int row = 0; row < rowCount; row++)
{
for (int col = 0; col < colCount - 1; col++)
{
excel.SetRangeValue(row + 5, col + 1, dtExport.Rows[row][col].ToString());
SetFormat(excel, 2);//设置小数点后两位
if (col == 0)
{
SetFormat(excel, 0);
}
}
}
excel.SetActiveRange(1, 1, 4, 11);
excel.SetRangeHAlign("center");
excel.SetActiveRange(5, 1, rowCount + 4, 11);
excel.SetRangeHAlign("left");
excel.SetActiveRange(3, 1, rowCount + 4, 11);
excel.SetRangeBorders(1);
string uploadPath = page.MapPath(@"..\DownLoadFiles\Export" + DateTime.Now.ToString("_yyyyMMdd") + ".xls");
excel.SaveAs(uploadPath);
excel.Dispose();
Export.ExportExcel(page, uploadPath, fileName, true);
}