99999久久久久久亚洲,欧美人与禽猛交狂配,高清日韩av在线影院,一个人在线高清免费观看,啦啦啦在线视频免费观看www

熱線電話：13121318867

登錄
首頁精彩閱讀asp.net生成Excel并導(dǎo)出下載五種實現(xiàn)方法
asp.net生成Excel并導(dǎo)出下載五種實現(xiàn)方法
2015-12-28
收藏

asp.net生成Excel并導(dǎo)出下載五種實現(xiàn)方法

有關(guān)Excel下載的文章網(wǎng)上想必有很多，利用閑暇時間整理了一些有Excel下載方法的文章，接下來介紹五種實現(xiàn)Excel下載的方法，感興趣的朋友可以了解下，或許對你學(xué)習(xí)Excel下載有所幫助

方法一 通過GridView(簡評：方法比較簡單，但是只適合生成格式簡單的Excel，且無法保留VBA代碼),頁面無刷新
aspx.cs部分

復(fù)制代碼代碼如下:

using System; 
using System.Collections; 
using System.Configuration; 
using System.Data; 
using System.Web; 
using System.Web.Security; 
using System.Web.UI; 
using System.Web.UI.HtmlControls; 
using System.Web.UI.WebControls; 
using System.Web.UI.WebControls.WebParts; 
using System.Text; 
public partial class DataPage_NationDataShow : System.Web.UI.Page 
{ 
private Data_Link link = new Data_Link(); 
private string sql; 
protected void Page_Load(object sender, EventArgs e) 
{ 
Ajax.Utility.RegisterTypeForAjax(typeof(DataPage_NationDataShow)); 
} 
protected void btnExcel_Click(object sender, EventArgs e) 
{ 
string strExcelName = "MyExcel"; 
strExcelName = strExcelName.Replace(@"/", ""); 
Data_Link link = new Data_Link(); 
string strSQL = this.hidParam.Value; 
DataSet ds = new DataSet(); 
ds = link.D_DataSet_Return(strSQL);//獲得想要放入Excel的數(shù)據(jù) 
gvExcel.Visible = true; 
gvExcel.DataSource = null; 
gvExcel.DataMember = ds.Tables[0].TableName; 
gvExcel.DataSource = ds.Tables[0]; 
gvExcel.DataBind(); 
ExportToExcel(this.Page, gvExcel, strExcelName); 
} 
protected void gvExcel_RowDataBound(object sender, GridViewRowEventArgs e) 
{ } 
public override void VerifyRenderingInServerForm(Control control) 
{ } 
/// <summary> 
/// 工具方法，Excel出力(解決亂碼問題) 
/// </summary> 
/// <param name="page">調(diào)用頁面</param> 
/// <param name="excel">Excel數(shù)據(jù)</param> 
/// <param name="fileName">文件名</param> 
public void ExportToExcel(System.Web.UI.Page page, GridView excel, string fileName) 
{ 
try 
{ 
foreach (GridViewRow row in excel.Rows) 
{ 
for (int i = 0; i < row.Cells.Count; i++) 
{ 
excel.HeaderRow.Cells[i].BackColor = System.Drawing.Color.Yellow; 
} 
} 
excel.Font.Size = 10; 
excel.AlternatingRowStyle.BackColor = System.Drawing.Color.LightCyan; 
excel.RowStyle.Height = 25; 
page.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName); 
page.Response.Charset = "utf-8"; 
page.Response.ContentType = "application/vnd.ms-excel"; 
page.Response.Write("<meta http-equiv=Content-Type content=text/html;charset=utf-8>"); 
excel.Page.EnableViewState = false; 
excel.Visible = true; 
excel.HeaderStyle.Reset(); 
excel.AlternatingRowStyle.Reset(); 
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); 
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
excel.RenderControl(oHtmlTextWriter); 
page.Response.Write(oStringWriter.ToString()); 
page.Response.End(); 
excel.DataSource = null; 
excel.Visible = false; 
} 
catch (Exception e) 
{ 
} 
} 
}

aspx部分
復(fù)制代碼代碼如下:

<head runat="server"> 
<script type="text/javascript"> 
//Excel DownLoad 
function excelExport(){ 
var hidText = document.getElementById("hidParam"); 
hidText.value = "some params"; 
document.getElementById("ExcelOutput").click(); 
} 
</script> 
</head> 
<body onload="pageInit()"> 
<form id="form1" runat="server"> 
<input type="button" value="EXCEL下載" style="width:100px;" onclick="excelExport()" id="excelBut" /> 
<input id="hidParam" type="text" runat="server" style="display:none;"/> 
<asp:Button runat="server" ID="ExcelOutput" style="display:none" Text= "EXCEL出力" Width="0px" onclick="btnExcel_Click" UseSubmitBehavior="false"/> 
<asp:GridView ID="gvExcel" runat="server" Height="95px" OnRowDataBound="gvExcel_RowDataBound" Visible="False"></asp:GridView> 
</form> 
</body>

在剛才的aspx.cs代碼中
復(fù)制代碼代碼如下:

foreach (GridViewRow row in excel.Rows) 
{ 
for (int i = 0; i < row.Cells.Count; i++) 
{ 
excel.HeaderRow.Cells[i].BackColor = System.Drawing.Color.Yellow; 
} 
}

這部分是給表頭添加樣式。

有時候為了便于瀏覽，需要給交叉行添加樣式，簡單點的可以用下面這種：

復(fù)制代碼代碼如下:

excel.AlternatingRowStyle.BackColor = System.Drawing.Color.LightCyan;

但是細(xì)看一下會發(fā)現(xiàn)它把一整行的樣式都改變了，包括后面那些沒有用到的列。

解決辦法是有，不過比較繁瑣，就是修改每個單元格的樣式。

復(fù)制代碼代碼如下:

int rowCount = excel.Rows.Count; 
int colCount = excel.HeaderRow.Cells.Count; 
for (int i = 0; i < rowCount; i++) 
{ 
for(int j=0;j<colCount; j++) 
{ 
excel.Rows[i].Cells[j].BackColor = System.Drawing.Color.LightCyan; 
} 
}

方法二 通過DataGrid(與方法一基本相同),頁面無刷新

aspx.cs部分

復(fù)制代碼代碼如下:

public override void VerifyRenderingInServerForm(Control control) 
{} 
/// <summary> 
/// エクセル出力イベント 
/// </summary> 
/// <param name="sender"></param> 
/// <param name="e"></param> 
private void ExcelBut_Click(object sender, System.EventArgs e) 
{ 
DataGrid dgExcel = new DataGrid(); 
try 
{ 
DataSet ds = getExcelData(this.PageParams.Value);//出力データを取得する 
if(ds.Tables[0].Rows.Count>0) 
{ 
//エクセルへデータを投入する 
string execlName= "MyExcel"; 
Encoding encodingType=System.Text.Encoding.UTF8; 
dgExcel.DataMember=ds.Tables[0].TableName; 
dgExcel.DataSource=ds.Tables[0]; 
Response.Buffer = true; 
Response.Charset = "utf-8"; 
Response.AppendHeader("Content-Disposition", "attachment;filename=" + execlName+ ".xls"); 
Response.ContentEncoding = encodingType; 
Response.ContentType = "application/ms-excel"; 
StringWriter oStringWriter = new StringWriter(); 
HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter); 
dgExcel.DataBind(); 
dgExcel.Visible = true; 
dgExcel.RenderControl(oHtmlTextWriter); 
Response.Write(oStringWriter.ToString()); 
Response.Flush(); 
Response.Close(); 
dgExcel.DataSource = null; 
dgExcel.Visible = false; 
} 
else 
{ 
Response.Write("<script>alert('xxxxxx')</script>"); 
} 
} 
catch(Exception ex) 
{ 
Response.Write("<script>alert('oooooo')</script>"); 
} 
}

aspx部分
復(fù)制代碼代碼如下:

<head runat="server"> 
<script type="text/javascript"> 
//Excel DownLoad 
function excelExport(){ 
var hidText = document.getElementById("hidParam"); 
hidText.value = "some params"; 
document.getElementById("ExcelOutput").click(); 
} 
</script> 
</head> 
<body onload="pageInit()"> 
<form id="form1" runat="server"> 
<input type="button" value="EXCEL下載" style="width:100px;" onclick="excelExport()" id="excelBut" NAME="excelBut"/> 
<input id="hidParam" type="text" runat="server" style="display:none;" NAME="hidParam"/> 
<asp:Button runat="server" ID="ExcelOutput" style="display:none" Text= "EXCEL出力" Width="0px" onclick="btnExcel_Click" UseSubmitBehavior="false"/> 
<asp:datagrid id="gvExcel" Visible="False" Runat="server" style="Z-INDEX: 107; POSITION: absolute; TOP: 72px; LEFT: 520px" 
Width="80px" Height="40px"></asp:datagrid> 
</form> 
</body>

方法三 以XML形式的Excel方式(可以設(shè)置豐富的樣式，并可以有多個sheet，但需要模版。速度很快，但生成的文件較大，且無法保留VBA代碼)

具體方法：把模版以 XML Document形式另存為A.xml。然后參照A.xml中的內(nèi)容即可

復(fù)制代碼代碼如下:
 
private void ExcelBut_Click(object sender, System.EventArgs e) 
{ 
DataSet ds = new DataSet(); 
string ExcelFileName = ""; 
DataRow dr=[------列名信息-------]; 
try 
{ 
ExcelFileName = Path.Combine(Request.PhysicalApplicationPath + "/ExcelFile", "MyExcel.xls"); 
//獲取Excel需要的數(shù)據(jù) 
ds = [------獲得數(shù)據(jù)-------]; 
if (ds.Tables.Count == 0) 
{ 
Response.Write("<script type='text/javascript'>alert('無數(shù)據(jù)');</script>"); 
return; 
} 
int sheetNum = ds.Tables.Count / 2; 
StreamWriter writer = new StreamWriter(ExcelFileName, false); 
//Styles標(biāo)簽前面的信息相當(dāng)于'頭信息'，不需要改變 
writer.WriteLine("<?xml version=\"1.0\"?>"); 
writer.WriteLine("<?mso-application progid=\"Excel.Sheet\"?>"); 
writer.WriteLine("<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\""); 
writer.WriteLine("xmlns:o=\"urn:schemas-microsoft-com:office:office\""); 
writer.WriteLine("xmlns:x=\"urn:schemas-microsoft-com:office:excel\""); 
writer.WriteLine("xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\""); 
writer.WriteLine("xmlns:html=\"http://www.w3.org/TR/REC-html40\">"); 
writer.WriteLine("<DocumentProperties xmlns=\"urn:schemas-microsoft-com:office:office\">"); 
writer.WriteLine("<LastAuthor>Automated Report Generator Example</LastAuthor>"); 
writer.WriteLine(string.Format("<Created>{0}T{1}Z</Created>", DateTime.Now.ToString("yyyy-mm-dd"), DateTime.Now.ToString("HH:MM:SS"))); 
writer.WriteLine(" <Company>51aspx.com</Company>"); 
writer.WriteLine(" <Version>11.6408</Version>"); 
writer.WriteLine("</DocumentProperties>"); 
writer.WriteLine("<ExcelWorkbook xmlns=\"urn:schemas-microsoft-com:office:excel\">"); 
writer.WriteLine("<WindowHeight>6195</WindowHeight>"); 
writer.WriteLine(" <WindowWidth>18495</WindowWidth>"); 
writer.WriteLine(" <WindowTopX>525</WindowTopX>"); 
writer.WriteLine(" <WindowTopY>4260</WindowTopY>"); 
writer.WriteLine(" <AcceptLabelsInFormulas/>"); 
writer.WriteLine(" <ProtectStructure>True</ProtectStructure>"); 
writer.WriteLine(" <ProtectWindows>False</ProtectWindows>"); 
writer.WriteLine("</ExcelWorkbook>"); 
//通過 ss:ID 和 ss:Name相當(dāng)于html中style的類 
writer.WriteLine(" <Styles> "); 
writer.WriteLine(" <Style ss:ID='Default' ss:Name='Normal'> "); 
writer.WriteLine(" <Alignment ss:Vertical='Bottom'/> "); 
writer.WriteLine(" <Borders/> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior/> "); 
writer.WriteLine(" <NumberFormat/> "); 
writer.WriteLine(" <Protection/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s23'> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11' "); 
writer.WriteLine(" ss:Color='#FF0000'/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s24'> "); 
writer.WriteLine(" <Interior/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s25'> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s26'> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11' "); 
writer.WriteLine(" ss:Color='#FF0000'/> "); 
writer.WriteLine(" <Interior/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s27'> "); 
writer.WriteLine(" <Borders> "); 
writer.WriteLine(" <Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" </Borders> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior ss:Color='#CCFFFF' ss:Pattern='Solid'/> "); 
writer.WriteLine(" <Protection/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s28'> "); 
writer.WriteLine(" <Borders> "); 
writer.WriteLine(" <Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" </Borders> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior ss:Color='#CCFFFF' ss:Pattern='Solid'/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s29'> "); 
writer.WriteLine(" <Borders> "); 
writer.WriteLine(" <Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" </Borders> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior ss:Color='#CCFFFF' ss:Pattern='Solid'/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s30'> "); 
writer.WriteLine(" <Borders> "); 
writer.WriteLine(" <Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" </Borders> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior ss:Color='#CCFFFF' ss:Pattern='Solid'/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s31'> "); 
writer.WriteLine(" <Borders> "); 
writer.WriteLine(" <Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" </Borders> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior ss:Color='#CCFFFF' ss:Pattern='Solid'/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s32'> "); 
writer.WriteLine(" <Alignment ss:Vertical='Bottom' ss:WrapText='1'/> "); 
writer.WriteLine(" <Borders> "); 
writer.WriteLine(" <Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" </Borders> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior ss:Color='#CCFFFF' ss:Pattern='Solid'/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s33'> "); 
writer.WriteLine(" <Alignment ss:Vertical='Bottom' ss:WrapText='1'/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s34'> "); 
writer.WriteLine(" <Alignment ss:Vertical='Bottom' ss:WrapText='1'/> "); 
writer.WriteLine(" <Borders> "); 
writer.WriteLine(" <Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" </Borders> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s35'> "); 
writer.WriteLine(" <Borders> "); 
writer.WriteLine(" <Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" </Borders> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s36'> "); 
writer.WriteLine(" <Borders> "); 
writer.WriteLine(" <Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" </Borders> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior ss:Color='#FFFF99' ss:Pattern='Solid'/> "); 
writer.WriteLine(" <Protection ss:Protected='0'/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s37'> "); 
writer.WriteLine(" <Borders> "); 
writer.WriteLine(" <Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" </Borders> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s38'> "); 
writer.WriteLine(" <Borders> "); 
writer.WriteLine(" <Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" </Borders> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" <Style ss:ID='s39'> "); 
writer.WriteLine(" <Borders> "); 
writer.WriteLine(" <Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/> "); 
writer.WriteLine(" </Borders> "); 
writer.WriteLine(" <Font ss:FontName='ＭＳ Ｐゴシック' x:CharSet='128' x:Family='Modern' ss:Size='11'/> "); 
writer.WriteLine(" <Interior/> "); 
writer.WriteLine(" </Style> "); 
writer.WriteLine(" </Styles> "); 
//Sheet操作 
writer.WriteLine("<Worksheet ss:Name='" + dr["Msg030"] + "'>"); 
writer.WriteLine(" <Table ss:ExpandedColumnCount='9' ss:ExpandedRowCount='3000' x:FullColumns='1' x:FullRows='1' ss:StyleID='s33' ss:DefaultColumnWidth='54' ss:DefaultRowHeight='13.5'>"); 
writer.WriteLine("<Column ss:StyleID='s34' ss:AutoFitWidth='0' ss:Width='110.25'/>"); 
writer.WriteLine("<Column ss:StyleID='s34' ss:AutoFitWidth='0' ss:Width='33.75'/>"); 
writer.WriteLine("<Column ss:StyleID='s34' ss:AutoFitWidth='0' ss:Width='118.5'/>"); 
writer.WriteLine("<Column ss:StyleID='s34' ss:AutoFitWidth='0' ss:Width='159.75'/>"); 
writer.WriteLine("<Column ss:StyleID='s34' ss:AutoFitWidth='0' ss:Width='147.75' ss:Span='4'/>"); 
for (int num = sheetNum - 1; num >= 0; num = num - 1) 
{ 
// 考課表間有3行的空行 
if (num != sheetNum - 1) 
{ 
writer.WriteLine("<Row>"); 
writer.WriteLine("</Row>"); 
writer.WriteLine("<Row>"); 
writer.WriteLine("</Row>"); 
writer.WriteLine("<Row>"); 
writer.WriteLine("</Row>"); 
} 
// 列名 
writer.WriteLine("<Row ss:Height='40.5'>"); 
writer.WriteLine("<Cell ss:StyleID='s32'><Data ss:Type='String'>" + dr["Msg002"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s32'><Data ss:Type='String'>" + dr["Msg003"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s32'><Data ss:Type='String'>" + dr["Msg004"] + "</Data></Cell>"); 
writer.WriteLine("</Row>"); 
// 詳細(xì)數(shù)據(jù) 
for (int i = 0; i < ds.Tables[2 * num].Rows.Count; i++) 
{ 
writer.WriteLine("<Row ss:Height='27'>"); 
writer.WriteLine("<Cell><Data ss:Type='String'>" + ds.Tables[2 * num].Rows[i]["EvalLevel1Name"].ToString() + "</Data></Cell>"); 
writer.WriteLine("<Cell><Data ss:Type='Number'>" + ds.Tables[2 * num].Rows[i]["EvalLevel2Code"].ToString() + "</Data></Cell>"); 
writer.WriteLine("<Cell><Data ss:Type='String'>" + ds.Tables[2 * num].Rows[i]["EvalLevel2Name"].ToString() + "</Data></Cell>"); 
writer.WriteLine("</Row>"); 
} 
} 
writer.WriteLine(" </Table>"); 
writer.WriteLine(" </Worksheet>"); 
// 其他Sheet操作 
for (int num = sheetNum - 1; num >= 0; num--) 
{ 
writer.WriteLine("<Worksheet ss:Name='" + ds.Tables[2 * num].Rows[0][1].ToString() + "' ss:Protected='1'>"); 
writer.WriteLine(" <Table ss:ExpandedColumnCount='31' ss:ExpandedRowCount='30000' x:FullColumns='1' x:FullRows='1' ss:StyleID='s25' ss:DefaultColumnWidth='54' ss:DefaultRowHeight='13.5'>"); 
writer.WriteLine(" <Row>"); 
writer.WriteLine("<Cell ss:StyleID='s26'><PhoneticText xmlns='urn:schemas-microsoft-com:office:excel'>カキキイロテンスウツ</PhoneticText><Data ss:Type='String'>" + dr["Msg031"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:Index='14' ss:StyleID='Default'/>"); 
writer.WriteLine("<Cell ss:StyleID='Default'/>"); 
writer.WriteLine("<Cell ss:StyleID='Default'/>"); 
writer.WriteLine("<Cell ss:StyleID='Default'/>"); 
writer.WriteLine("<Cell ss:StyleID='Default'/>"); 
writer.WriteLine("<Cell ss:StyleID='Default'/>"); 
writer.WriteLine("<Cell ss:StyleID='Default'/>"); 
writer.WriteLine("<Cell ss:StyleID='Default'/>"); 
writer.WriteLine("<Cell ss:StyleID='Default'/>"); 
writer.WriteLine("</Row>"); 
writer.WriteLine(" <Row>"); 
writer.WriteLine("<Cell ss:StyleID='s26'><PhoneticText xmlns='urn:schemas-microsoft-com:office:excel'>カキキイロテンスウツ</PhoneticText><Data ss:Type='String'>" + dr["Msg032"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:Index='14' ss:StyleID='Default'/>"); 
writer.WriteLine("<Cell ss:StyleID='Default'/>"); 
writer.WriteLine("<Cell ss:StyleID='Default'/>"); 
writer.WriteLine("</Row>"); 
// 列名 
writer.WriteLine("<Row>"); 
writer.WriteLine("<Cell ss:StyleID='s27'><Data ss:Type='String'>" + dr["Msg001"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s28'><Data ss:Type='String'>" + dr["Msg002"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s28'><Data ss:Type='String'>" + dr["Msg003"] + "</Data></Cell>"); 
writer.WriteLine("</Row>"); 
int SheetN = ds.Tables[2 * num].Rows.Count; 
//詳細(xì)數(shù)據(jù) 
for (int i = 0; i < SheetN; i++) 
{ 
writer.WriteLine("<Row>"); 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='Number'>" + ds.Tables[2 * num].Rows[i]["EvalLevel1Code"].ToString() + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='String'>" + ds.Tables[2 * num].Rows[i]["EvalLevel1Name"].ToString() + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='Number'>" + ds.Tables[2 * num].Rows[i]["EvalLevel2Code"].ToString() + "</Data></Cell>"); 
writer.WriteLine("<Cell><Data ss:Type='String'> </Data></Cell>"); 
writer.WriteLine("</Row>"); 
} 
writer.WriteLine("<Row>"); 
writer.WriteLine("</Row>"); 
writer.WriteLine("<Row>"); 
writer.WriteLine("</Row>"); 
//列名 
writer.WriteLine("<Row>"); 
writer.WriteLine("<Cell ss:StyleID='s29'><Data ss:Type='String'>" + dr["Msg011"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s30'/>"); 
writer.WriteLine("<Cell ss:StyleID='s31'/>"); 
writer.WriteLine("<Cell ss:StyleID='s29'><Data ss:Type='String'>" + dr["Msg012"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s31'/>"); 
writer.WriteLine("<Cell ss:StyleID='s29'><Data ss:Type='String'>" + dr["Msg013"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s30'/>"); 
writer.WriteLine("<Cell ss:StyleID='s30'/>"); 
writer.WriteLine("<Cell ss:StyleID='s30'/>"); 
writer.WriteLine("<Cell ss:StyleID='s31'/>"); 
writer.WriteLine("<Cell ss:StyleID='s29'><Data ss:Type='String'>" + dr["Msg014"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s31'/>"); 
writer.WriteLine("<Cell ss:StyleID='s29'><Data ss:Type='String'>" + dr["Msg015"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s31'/>"); 
writer.WriteLine("</Row>"); 
writer.WriteLine("<Row>"); 
writer.WriteLine("<Cell ss:StyleID='s28'><Data ss:Type='String'>" + dr["Msg016"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s28'><Data ss:Type='String'>" + dr["Msg017"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s28'><Data ss:Type='String'>" + dr["Msg018"] + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s28'><Data ss:Type='String'>" + dr["Msg019"] + "</Data></Cell>"); 
writer.WriteLine("</Row>"); 
int DateLen = ds.Tables[2 * num + 1].Rows.Count; 
string EmployeeManagement = ""; 
for (int i = 0; i < DateLen; i++) 
{ 
writer.WriteLine("<Row>"); 
writer.WriteLine("<Cell ss:StyleID='s37'><Data ss:Type='Number'>" + ds.Tables[2 * num + 1].Rows[i]["EmployeeManagementID"].ToString() + "</Data></Cell>"); 
if (!EmployeeManagement.Equals(ds.Tables[2 * num + 1].Rows[i]["EmployeeManagementID"].ToString())) 
{ 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='Number'>" + ds.Tables[2 * num + 1].Rows[i]["EmployeeCode"].ToString() + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='String'>" + ds.Tables[2 * num + 1].Rows[i]["EmployeeName"].ToString() + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='String'>" + ds.Tables[2 * num + 1].Rows[i]["BefEmployeeName2"].ToString() + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='String'>" + ds.Tables[2 * num + 1].Rows[i]["EmployeeName2"].ToString() + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s38'><Data ss:Type='Number'>" + ds.Tables[2 * num + 1].Rows[i]["EvalLevel1Code"].ToString() + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='String'>" + ds.Tables[2 * num + 1].Rows[i]["EvalLevel1Name"].ToString() + "</Data></Cell>"); 
EmployeeManagement = ds.Tables[2 * num + 1].Rows[i]["EmployeeManagementID"].ToString(); 
} 
else 
{ 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='String'></Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='String'></Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='String'></Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='String'></Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s38'><Data ss:Type='String'></Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='String'></Data></Cell>"); 
} 
writer.WriteLine("<Cell ss:StyleID='s39'><Data ss:Type='Number'>" + ds.Tables[2 * num + 1].Rows[i]["EvalLevel2Code"].ToString() + "</Data></Cell>"); 
writer.WriteLine("<Cell ss:StyleID='s35'><Data ss:Type='String'>" + ds.Tables[2 * num + 1].Rows[i]["EvalLevel2Name"].ToString() + "</Data></Cell>"); 
writer.WriteLine("</Row>"); 
} 
writer.WriteLine(" </Table>"); 
writer.WriteLine(" </Worksheet>"); 
} 
writer.WriteLine("</Workbook>"); 
writer.Close(); 
FileDownload(ExcelFileName); 
} 
catch (System.Exception ex) 
{ 
} 
finally 
{ 
Response.End(); 
} 
} 
public void FileDow

SQL

數(shù)據(jù)分析咨詢請掃描二維碼

若不方便掃碼，搜微信號：CDAshujufenxi

數(shù)據(jù)分析師資訊
更多

OK
客服在線
立即咨詢
客服在線
立即咨詢
') } function initGt() { var handler = function (captchaObj) { captchaObj.appendTo('#captcha'); captchaObj.onReady(function () { $("#wait").hide(); }).onSuccess(function(){ $('.getcheckcode').removeClass('dis'); $('.getcheckcode').trigger('click'); }); window.captchaObj = captchaObj; }; $('#captcha').show(); $.ajax({ url: "/login/gtstart?t=" + (new Date()).getTime(), // 加隨機數(shù)防止緩存 type: "get", dataType: "json", success: function (data) { $('#text').hide(); $('#wait').show(); // 調(diào)用 initGeetest 進行初始化 // 參數(shù)1：配置參數(shù) // 參數(shù)2：回調(diào)，回調(diào)的第一個參數(shù)驗證碼對象，之后可以使用它調(diào)用相應(yīng)的接口 initGeetest({ // 以下 4 個配置參數(shù)為必須，不能缺少 gt: data.gt, challenge: data.challenge, offline: !data.success, // 表示用戶后臺檢測極驗服務(wù)器是否宕機 new_captcha: data.new_captcha, // 用于宕機時表示是新驗證碼的宕機 product: "float", // 產(chǎn)品形式，包括：float，popup width: "280px", https: true // 更多配置參數(shù)說明請參見：http://docs.geetest.com/install/client/web-front/ }, handler); } }); } function codeCutdown() { if(_wait == 0){ //倒計時完成 $(".getcheckcode").removeClass('dis').html("重新獲取"); }else{ $(".getcheckcode").addClass('dis').html("重新獲取("+_wait+"s)"); _wait--; setTimeout(function () { codeCutdown(); },1000); } } function inputValidate(ele,telInput) { var oInput = ele; var inputVal = oInput.val(); var oType = ele.attr('data-type'); var oEtag = $('#etag').val(); var oErr = oInput.closest('.form_box').next('.err_txt'); var empTxt = '請輸入'+oInput.attr('placeholder')+'！'; var errTxt = '請輸入正確的'+oInput.attr('placeholder')+'！'; var pattern; if(inputVal==""){ if(!telInput){ errFun(oErr,empTxt); } return false; }else { switch (oType){ case 'login_mobile': pattern = /^1[3456789]\d{9}$/; if(inputVal.length==11) { $.ajax({ url: '/login/checkmobile', type: "post", dataType: "json", data: { mobile: inputVal, etag: oEtag, page_ur: window.location.href, page_referer: document.referrer }, success: function (data) { } }); } break; case 'login_yzm': pattern = /^\d{6}$/; break; } if(oType=='login_mobile'){ } if(!!validateFun(pattern,inputVal)){ errFun(oErr,'') if(telInput){ $('.getcheckcode').removeClass('dis'); } }else { if(!telInput) { errFun(oErr, errTxt); }else { $('.getcheckcode').addClass('dis'); } return false; } } return true; } function errFun(obj,msg) { obj.html(msg); if(msg==''){ $('.login_submit').removeClass('dis'); }else { $('.login_submit').addClass('dis'); } } function validateFun(pat,val) { return pat.test(val); }