C# 将数据集以excel的形式输出

private void SaveLastMonthAuthorPays()
{
string fileName = "LastMonthAuthorPays.xls";

string contentFormat = "{0}\t{1}\t{2}\t{3}\t{4}\r\n";

DataSet ds = null;

AuthorPayManager authorPayManager = new AuthorPayManager();
            try
            {
                ds = authorPayManager.LoadLastMonthAuthorPays();
            }
            catch (Exception ex)
            {
                //LogHelper.Warn("获取上月应支付稿酬列表时出现错误," + ex.ToString());
                AddUserLogEx("获取上月应支付稿酬列表时出现错误," + ex.ToString(), LogOPType.Insert);
                this.RedirectErrorPage("获取上月应支付稿酬列表时出现错误,请与管理员联系");
            }

Response.ClearHeaders();
            Response.Clear();
            Response.Expires = 0;
            Response.Buffer = true;
            Response.AddHeader("Accept-Language", "zh-cn");

Response.AddHeader("content-disposition", "attachment; filename=" + fileName);
Response.ContentType = "Application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

Response.Write("支付月份\t当月支付稿酬\t半年奖励\t稿酬类型\t作家署名\r\n");
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                Response.Write(string.Format(contentFormat,
                    dr["moneytime"],//支付月份
                    dr["money"],        //当月支付稿酬
                    dr["money_level"],             //半年奖励
                    dr["nature"],        //
                    dr["aut_name"]      //作家署名
                    )
                );
            }

Response.End();
}

巴特西

C# 将数据集以excel的形式输出

最新文章

热门文章