C# 导出 Execl 响应超时

大飞为 2017-11-15 10:30:03
这是我的代码：

[code=csharp] DataToExcel dte = new DataToExcel();
string FilePath = "../Excel/PrizeOrder/";
string filename = DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls";
try
{

List<string> ids = getSelected();

DataTable outdt = BLL.TBPrizeOrderBLL.FindByWhere23(Common.PageValidate.InputText(this.txtCode.Text, 50),
Common.PageValidate.InputText(this.txtName.Text, 50),
this.txtStartTime.Text, this.txtEndTime.Text, this.ddlState.SelectedValue, ids);

string SQLss = BLL.TBPrizeOrderBLL.FindByWhereTwo(Common.PageValidate.InputText(this.txtCode.Text, 50),
Common.PageValidate.InputText(this.txtName.Text, 50),
this.txtStartTime.Text, this.txtEndTime.Text, this.ddlState.SelectedValue, ids);

COM.Excel.cExcelFile excel = new COM.Excel.cExcelFile();

excel.CreateFile(Server.MapPath(FilePath + filename));
excel.PrintGridLines = false;

COM.Excel.cExcelFile.MarginTypes mt1 = COM.Excel.cExcelFile.MarginTypes.xlsTopMargin;
COM.Excel.cExcelFile.MarginTypes mt2 = COM.Excel.cExcelFile.MarginTypes.xlsLeftMargin;
COM.Excel.cExcelFile.MarginTypes mt3 = COM.Excel.cExcelFile.MarginTypes.xlsRightMargin;
COM.Excel.cExcelFile.MarginTypes mt4 = COM.Excel.cExcelFile.MarginTypes.xlsBottomMargin;

double height = 1.7;
excel.SetMargin(ref mt1, ref height);
excel.SetMargin(ref mt2, ref height);
excel.SetMargin(ref mt3, ref height);
excel.SetMargin(ref mt4, ref height);

COM.Excel.cExcelFile.FontFormatting ff = COM.Excel.cExcelFile.FontFormatting.xlsNoFormat;
string font = "宋体";
short fontsize = 10;
excel.SetFont(ref font, ref fontsize, ref ff);

byte b1 = 1,
b2 = 12;
short s3 = 12;
excel.SetColumnWidth(ref b1, ref b2, ref s3);

string header = "页眉";
string footer = "页脚";
excel.SetHeader(ref header);
excel.SetFooter(ref footer);




COM.Excel.cExcelFile.ValueTypes vt = COM.Excel.cExcelFile.ValueTypes.xlsText;
COM.Excel.cExcelFile.CellFont cf = COM.Excel.cExcelFile.CellFont.xlsFont0;
COM.Excel.cExcelFile.CellAlignment ca = COM.Excel.cExcelFile.CellAlignment.xlsCentreAlign;
COM.Excel.cExcelFile.CellHiddenLocked chl = COM.Excel.cExcelFile.CellHiddenLocked.xlsNormal;

// 报表标题
int cellformat = 1;
// int rowindex = 1,colindex = 3;
// object title = (object)strTitle;
// excel.WriteValue(ref vt, ref cf, ref ca, ref chl,ref rowindex,ref colindex,ref title,ref cellformat);

int rowIndex = 1;//起始行
int colIndex = 0;

string[] titlelist = { "订单号","下单时间","下单人","消耗积分","收货人","联系电话","所属地区","收货地址","订单状态","审核人","审核时间",
"审核描述","备注","快递方式","运费","物流单号","发货人","发货时间","商品编码", "商品名称", "单品积分", "订单数量", "配送数量","商品品牌","商品系列", "实扣积分"};

//取得列标题
foreach (string titleitem in titlelist)
{
colIndex++;
object namestr = (object)titleitem;
excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref namestr, ref cellformat);
}
DataTable detaldt = BLL.TBPrizeOrderBLL.FindDetail();
//取得表格中的数据
foreach (DataRow row in outdt.Rows)
{

DataRow[] ddt = detaldt.Select("PrizeOrder_ID="+Convert.ToInt32(row["id"]));



foreach (DataRow drow in ddt)
{
rowIndex++;
colIndex = 0;
//订单号
colIndex++;
object str = (object)row["OrderCode"].ToString();
excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
//订单时间
colIndex++;
str = row["OrderTime"].ToString();
try
{
str = (object)(Convert.ToDateTime(row["OrderTime"].ToString())).ToString("yyyy-MM-dd");
}
catch (Exception)
{
}
excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);

//下单人
colIndex++;
str = (object)row["RealName"].ToString();
excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);




...全文
344 7 打赏 收藏 转发到动态 举报
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
mirrorspace 2017-11-17
  • 打赏
  • 举报
 回复
复杂啊.使用NPOI NPOI
hxm_admin 2017-11-17
  • 打赏
  • 举报
 回复
http://blog.csdn.net/hxm_admin/article/details/47130215
by_封爱 2017-11-15
  • 打赏
  • 举报
 回复
使用npoi导出..... 这里
大飞为 2017-11-15
  • 打赏
  • 举报
 回复
删减部分导出项
大飞为 2017-11-15
  • 打赏
  • 举报
 回复 
        protected void lbtnExport_Click(object sender, EventArgs e)
        {
            DataToExcel dte = new DataToExcel();
            string FilePath = "../Excel/PrizeOrder/";
            string filename = DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls";
            try
            {

                List<string> ids = getSelected();
                DataTable outdt = BLL.TBPrizeOrderBLL.FindByWhere23(Common.PageValidate.InputText(this.txtCode.Text, 50),
                 Common.PageValidate.InputText(this.txtName.Text, 50),
                this.txtStartTime.Text, this.txtEndTime.Text, this.ddlState.SelectedValue, ids);
                string  SQLss = BLL.TBPrizeOrderBLL.FindByWhereTwo(Common.PageValidate.InputText(this.txtCode.Text, 50),
                 Common.PageValidate.InputText(this.txtName.Text, 50),
                this.txtStartTime.Text, this.txtEndTime.Text, this.ddlState.SelectedValue, ids);                
                COM.Excel.cExcelFile excel = new COM.Excel.cExcelFile();
                excel.CreateFile(Server.MapPath(FilePath + filename));
                excel.PrintGridLines = false;
                COM.Excel.cExcelFile.MarginTypes mt1 = COM.Excel.cExcelFile.MarginTypes.xlsTopMargin;
                COM.Excel.cExcelFile.MarginTypes mt2 = COM.Excel.cExcelFile.MarginTypes.xlsLeftMargin;
                COM.Excel.cExcelFile.MarginTypes mt3 = COM.Excel.cExcelFile.MarginTypes.xlsRightMargin;
                COM.Excel.cExcelFile.MarginTypes mt4 = COM.Excel.cExcelFile.MarginTypes.xlsBottomMargin;
                double height = 1.7;
                excel.SetMargin(ref mt1, ref height);
                excel.SetMargin(ref mt2, ref height);
                excel.SetMargin(ref mt3, ref height);
                excel.SetMargin(ref mt4, ref height);
                COM.Excel.cExcelFile.FontFormatting ff = COM.Excel.cExcelFile.FontFormatting.xlsNoFormat;
                string font = "宋体";
                short fontsize = 10;
                excel.SetFont(ref font, ref fontsize, ref ff);
                byte b1 = 1,
                    b2 = 12;
                short s3 = 12;
                excel.SetColumnWidth(ref b1, ref b2, ref s3);
                string header = "页眉";
                string footer = "页脚";
                excel.SetHeader(ref header);
                excel.SetFooter(ref footer);
                COM.Excel.cExcelFile.ValueTypes vt = COM.Excel.cExcelFile.ValueTypes.xlsText;
                COM.Excel.cExcelFile.CellFont cf = COM.Excel.cExcelFile.CellFont.xlsFont0;
                COM.Excel.cExcelFile.CellAlignment ca = COM.Excel.cExcelFile.CellAlignment.xlsCentreAlign;
                COM.Excel.cExcelFile.CellHiddenLocked chl = COM.Excel.cExcelFile.CellHiddenLocked.xlsNormal;
                int cellformat = 1;
                int rowIndex = 1;//起始行
                int colIndex = 0;
                string[] titlelist = { "订单号","下单时间","下单人","消耗积分","收货人","联系电话","所属地区","收货地址","订单状态","审核人","审核时间",
                                     "审核描述","备注","快递方式","运费","物流单号","发货人","发货时间","商品编码", "商品名称", "单品积分", "订单数量", "配送数量","商品品牌","商品系列", "实扣积分"};
                //取得列标题				
                foreach (string titleitem in titlelist)
                {
                    colIndex++;
                    object namestr = (object)titleitem;
                    excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref namestr, ref cellformat);
                }
                DataTable detaldt = BLL.TBPrizeOrderBLL.FindDetail();
                //取得表格中的数据			
                foreach (DataRow row in outdt.Rows)
                {
                    DataRow[] ddt = detaldt.Select("PrizeOrder_ID="+Convert.ToInt32(row["id"]));
                    foreach (DataRow drow in ddt)
                    {
                        rowIndex++;
                        colIndex = 0;
                        //订单号
                        colIndex++;
                        object str = (object)row["OrderCode"].ToString();
                        excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
                        //订单时间
                        colIndex++;
                        str = row["OrderTime"].ToString();
                        try
                        {
                            str = (object)(Convert.ToDateTime(row["OrderTime"].ToString())).ToString("yyyy-MM-dd");
                        }
                        catch (Exception)
                        {
                        }
                        excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
                        //下单人
                        colIndex++;
                        str = (object)row["RealName"].ToString();
                        excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
                        //消耗积分
                        colIndex++;
                        decimal totalIntegral = 0;
                        for (int i = 0; i < ddt.Length; i++)
                        {
                            if (ddt[i]["DeliveryQty"] != null && ddt[i]["DeliveryQty"] != DBNull.Value && string.IsNullOrEmpty(ddt[i]["DeliveryQty"].ToString()) == false)
                            {
                                decimal qty = Convert.ToDecimal(ddt[i]["DeliveryQty"]);
                                totalIntegral = totalIntegral + (qty * Convert.ToDecimal(ddt[i]["Integral"]));
                                detaldt.Rows[i]["TotalIntegral"] = qty * Convert.ToDecimal(ddt[i]["Integral"]);
                            }
                            else
                            {
                                decimal qty = Convert.ToDecimal(ddt[i]["OrderQty"]); //获取填充子类的id 
                                totalIntegral = totalIntegral + (qty * Convert.ToDecimal(ddt[i]["Integral"]));
                            }
                        }
                        str = (object)totalIntegral;
                        excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
                        //收货人
                        colIndex++;
                        str = (object)row["Receiver"].ToString();
                        excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
                        //联系电话
                        colIndex++;
                        str = (object)row["Tel"].ToString();
                        excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
                        //所属地区
                        colIndex++;
                        str = (object)row["Address"].ToString();
                        excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
                        //收货地址
                        colIndex++;
                        str = (object)row["DetailedAddress"].ToString();
                        excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
                        //订单状态
                        colIndex++;
                        string state = BLL.GetData.GetOrderState2(row["CheckState"].ToString());
                        str = (object)state;
                        excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
                        //审核人
                        colIndex++;
                        str = (object)row["Emp_Name"].ToString();
                        excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
                        //审核时间
                        colIndex++;
                        str = row["OrderTime"].ToString();
                        try
                        {
                            str = (object)(Convert.ToDateTime(row["Check_Date"].ToString())).ToString("yyyy-MM-dd HH:mm:ss");
                        }
                        catch (Exception)
                        {
                        }
                        excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
                        //审核描述
                        colIndex++;
                        str = (object)row["CheckDiscription"].ToString();
                        excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
                        //发货人
                        colIndex++;
                        str = (object)row["Sender"].ToString();
                        excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat);
                        //发货时间时间
                        colIndex++;
                        str = row["SendTime"].ToString();
                        try
                        {
                            str = (object)(Convert.ToDateTime(row["Check_Date"].ToString())).ToString("yyyy-MM-dd HH:mm:ss");
                        }
                        catch (Exception)
                        {
                        }
                    }
                    excel.PrintGridLines = false;
                }
                int ret = excel.CloseFile();
            }
            catch (Exception ex)
            {
                string msg = ex.Message;
                //dte.KillExcelProcess();
            }
            finally
            {
                dte.KillExcelProcess();
            }

            if (filename != "")
            {
               

                Response.Redirect(FilePath + "/" + filename, true);
            }

        }
大飞为 2017-11-15
  • 打赏
  • 举报
 回复
//消耗积分 colIndex++; decimal totalIntegral = 0; for (int i = 0; i < ddt.Length; i++) { if (ddt[i]["DeliveryQty"] != null && ddt[i]["DeliveryQty"] != DBNull.Value && string.IsNullOrEmpty(ddt[i]["DeliveryQty"].ToString()) == false) { decimal qty = Convert.ToDecimal(ddt[i]["DeliveryQty"]); totalIntegral = totalIntegral + (qty * Convert.ToDecimal(ddt[i]["Integral"])); detaldt.Rows[i]["TotalIntegral"] = qty * Convert.ToDecimal(ddt[i]["Integral"]); } else { decimal qty = Convert.ToDecimal(ddt[i]["OrderQty"]); //获取填充子类的id totalIntegral = totalIntegral + (qty * Convert.ToDecimal(ddt[i]["Integral"])); } } str = (object)totalIntegral; excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //收货人 colIndex++; str = (object)row["Receiver"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //联系电话 colIndex++; str = (object)row["Tel"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //所属地区 colIndex++; str = (object)row["Address"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //收货地址 colIndex++; str = (object)row["DetailedAddress"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //订单状态 colIndex++; string state = BLL.GetData.GetOrderState2(row["CheckState"].ToString()); str = (object)state; excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //审核人 colIndex++; str = (object)row["Emp_Name"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //审核时间 colIndex++; str = row["OrderTime"].ToString(); try { str = (object)(Convert.ToDateTime(row["Check_Date"].ToString())).ToString("yyyy-MM-dd HH:mm:ss"); } catch (Exception) { } excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //审核描述 colIndex++; str = (object)row["CheckDiscription"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //备注 colIndex++; str = (object)row["Remark"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //快递方式 colIndex++; str = (object)row["SendType"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //运费 colIndex++; str = (object)row["Cost"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //物流单号 colIndex++; str = (object)row["TrackingNumber"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //发货人 colIndex++; str = (object)row["Sender"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //发货时间时间 colIndex++; str = row["SendTime"].ToString(); try { str = (object)(Convert.ToDateTime(row["Check_Date"].ToString())).ToString("yyyy-MM-dd HH:mm:ss"); } catch (Exception) { } excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); ////订单明细 //excel.PrintGridLines = true; //rowIndex++; //商品编码 colIndex++; str = (object)drow["PrizeCode"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //商品名称 colIndex++; str = (object)drow["PrizeName"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //单品积分 colIndex++; str = (object)drow["Integral"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //订单数量 colIndex++; str = (object)drow["OrderQty"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //配送数量 colIndex++; str = (object)drow["DeliveryQty"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //商品品牌 colIndex++; str = (object)drow["Barnd"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //商品系列 colIndex++; str = (object)drow["Series"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); //实扣积分 colIndex++; str = (object)drow["TotalIntegral"].ToString(); excel.WriteValue(ref vt, ref cf, ref ca, ref chl, ref rowIndex, ref colIndex, ref str, ref cellformat); } excel.PrintGridLines = false; } int ret = excel.CloseFile(); } catch (Exception ex) { string msg = ex.Message; //dte.KillExcelProcess(); } finally { dte.KillExcelProcess(); } if (filename != "") { Response.Redirect(FilePath + "/" + filename, true); }[/code] 响应超时。导出数据超过5000 就会超时 想用线程在后台挂着写入完成后 导出 但是提示 上下文不
星空蔚蓝 2017-11-15
  • 打赏
  • 举报
 回复
响应时间有限制吧，改一下配置呢？
C#零基础入门课程
零基础C#入门课程旨在帮助编程小白从零开始掌握C#语言的基础知识和编程技能。课程主要包括以下几个方面： C#语言简介与开发环境搭建：介绍C#语言的特点、应用场景和优势，并教授如何搭建C#开发环境，选择和使用常用...
C#_.NetCore_Web项目_EXCEL数据导出（ExcelHelper_第一版）
A-前端触发下载Excel的方法有三种： 　1-JS-Url跳转请求-后台需要返回文件流数据： window.Location.href = "/ajax/toolhelper.js?action=reBuyExport&beginTime=" + beginTime + "&endTime=" + endTime; ...
使用Ajax实现异步导出数据到excel
最近做项目的时候就遇到需要把用户分散在多个数据表中的数据整合到一起既可以在线查看，又能导出excel。对于这个需求，如果用户量小的情况下直接点击链接跳转请求服务器处理从数据表中取出数据生成excel再返回客户端...
多线程导出excel高并发_用多线程优化Excel表格数据导入校验的接口
公司的需求，当前某个Excel导入功能，流程是：读取Excel数据，传入后台校验每一条数据，判断是否符合导入要求，返回给前端，导入预览展示。(前端等待响应，难点)。用户再点击导入按钮，进行异步导入(前端不等待，好...
C#通过UrlReWrite配置重定向以及代理Proxy中的超时请求
项目使用UrlReWrite重定向功能，同时也设置了代理，但是IIS的默认是120秒，高级设置里的连接超时也设置7200秒，但是网站在导出excel的时候，还是出现502-web服务器在作为网关或代理服务器时收到了无效响应，由于数据...
.NET社区

62,046

社区成员

669,049

社区内容

发帖
与我相关
我的任务
社区描述
.NET技术交流专区
javascript云原生 企业社区
社区管理员
  • ASP.NET
  • .Net开发者社区
  • R小R
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告

.NET 社区是一个围绕开源 .NET 的开放、热情、创新、包容的技术社区。社区致力于为广大 .NET 爱好者提供一个良好的知识共享、协同互助的 .NET 技术交流环境。我们尊重不同意见，支持健康理性的辩论和互动，反对歧视和攻击。

希望和大家一起共同营造一个活跃、友好的社区氛围。

试试用AI创作助手写篇文章吧

+ 用AI写文章