本文詳細(xì)解答了如何在Asp.Net中應(yīng)用Aspose.Cells輸出報(bào)表到Excel 。

解決思路：

1、安裝Aspose.Cells，下載地址：//fc6vip.cn/zh-CN/product/563/download.aspx；

2、在.Net方案中引用此Cells；

3、寫(xiě)個(gè)函數(shù)ToExcel(傳遞一個(gè)DataTable)，可以另寫(xiě)個(gè)SetCellStyle的函數(shù)專(zhuān)門(mén)給各列設(shè)置樣式。

4、在按鈕的Click事件中調(diào)用此ToExcel()即可。

 部分代碼貼在這里，代碼還有需要改進(jìn)的地方，暫時(shí)這么用著，給自己以后方便查找，再者給真正接觸此控件的同志們拋個(gè)磚頭：

ExportToExcel()的：

/// <summary>
		/// 利用Aspose.Cells對(duì)DataTable數(shù)據(jù)生成Excel文件
		/// </summary>
		/// <returns>是否成功</returns>
		/// <param name="response">包含存儲(chǔ)路徑，直接用Response即可</param>
		/// <param name="dt">數(shù)據(jù)體</param>
		/// <param name="FileName">文件名</param>
		/// <param name="SheetName">sheet名</param>
		/// <param name="Title">表頭</param>
		/// <param name="ColTitle">列標(biāo)題，字符串?dāng)?shù)組</param>
		/// <param name="ColName">列名，字符串?dāng)?shù)組</param>
		/// <param name="ColWidth">列寬，整數(shù)數(shù)組</param>
		/// <param name="ColStyle">列樣式，整數(shù)數(shù)組，1=居中文本、2=特殊字體Georgia、3=居左文本、4=整數(shù)(x)、5=2位小數(shù)(x,xxx.xx)、6=日期(yyyy-M-d不帶時(shí)間)、7=百分?jǐn)?shù)(0.123=12.3%)</param>
		/// <param name="ColTitleRow">列標(biāo)題的開(kāi)始行號(hào)，有title的設(shè)為1即可</param>
		/// <param name="err">返回的錯(cuò)誤信息</param>
		public bool ExportToExcel(System.Web.HttpResponse response,DataTable dt, string FileName, string SheetName, string Title, 
			ArrayList ColTitle, ArrayList ColName, ArrayList ColWidth, ArrayList ColStyle, int ColTitleRow, ref string err)
		{

			//先檢查各數(shù)組是否個(gè)數(shù)一致
			if (ColTitle.Count != ColName.Count || ColTitle.Count != ColWidth.Count || ColTitle.Count != ColStyle.Count)
			{
				err = "數(shù)據(jù)組個(gè)數(shù)不一致";
				return false;
			}

			try
			{

				Workbook workbook = new Workbook(); 

				//打開(kāi)模版文件
				//			string path = System.Web.HttpContext.Current.Server.MapPath("~");
				//			path = path.Substring(0, path.LastIndexOf("//"));		
				//			path += @"/designer/Workbooks/NumberFormatting.xls";				
				//			workbook.Open(path);

				//打開(kāi)sheet
				workbook.Worksheets.Clear();
				Worksheet worksheet = workbook.Worksheets.Add(SheetName);
				worksheet = workbook.Worksheets[0];

				Cells cells = worksheet.Cells; 
				//cells.ClearContents(0,0,60,30); 

				//加入樣式
				ArrayList styles = new ArrayList();
				styles = SetCellStyle(workbook, ColStyle);

				//加入Title即表頭，類(lèi)似“xxx匯總表”，其占居所有列數(shù)
				Range w;//范圍
				if(ColTitleRow>0)
				{
					//Put數(shù)據(jù)到某個(gè)cell中
					cells[0,0].PutValue(Title);
					//設(shè)置行高
					cells.SetRowHeight(0, 35);
					//合并單元格
					cells.Merge(0,0,1,(byte)ColName.Count);
					//CreateRange函數(shù)參數(shù)說(shuō)明：cells.CreateRange(firstrow, firstcol, rownumber, colnumber)
					w=cells.CreateRange(0,0,1,(byte)ColName.Count);
					//設(shè)置該合并單元的Style
					//w.Style = (Aspose.Cells.Style)styles[ColStyle.Count];
					w.Style = workbook.Styles["SheetTitle"];
					}
			
				//給各列的標(biāo)題行PutValue，類(lèi)似“序號(hào)，類(lèi)型，名稱(chēng)，價(jià)格，數(shù)量，合計(jì)”
				int currow = ColTitleRow; 			
				byte curcol = 0;
				foreach(string s in ColTitle)
				{
					cells[currow,curcol++].PutValue(s);
					cells.SetRowHeight(ColTitleRow, 25);
				}
				//設(shè)置列標(biāo)題行的Style
				w=cells.CreateRange(currow,0,1,ColName.Count);						
				w.Style = (Aspose.Cells.Style)styles[ColStyle.Count+1];	
				//上面這行也可以寫(xiě)成
				//w.Style = workbook.Styles["ColTitle"];//ColTitle在函數(shù)SetCellStyle中設(shè)置了

				currow++;
			

				//將數(shù)據(jù)體按順序插入各cell
				for(int i=0; i<dt.Rows.Count; i++)
				{
					curcol = 0;
					for(int j=0; j<ColName.Count; j++)
					{
						object val = dt.Rows[i][ColName[j].ToString()].ToString().Trim();
						switch (int.Parse(ColStyle[j].ToString()))
						{
							case 4://整數(shù)
								if (val.ToString().Length>0)
									val = Int32.Parse(val.ToString());
								else
									val = "";
								break;
							case 5://2位小數(shù)
								if (val.ToString().Length>0)
									val = Decimal.Parse(val.ToString());
								else
									val = "";
								break;
							case 6://日期
								if (val.ToString().Length>0)
									val = DateTime.Parse(val.ToString());
								else
									val = "";
								break;
							case 7://百分?jǐn)?shù)，1=100%
								if (val.ToString().Length>0)
									val = Decimal.Parse(val.ToString());
								else
									val = "";
								break;
							default:
								break;
						}//end switch		
						cells[currow,curcol++].PutValue(val);
					}//end for j
					currow ++;
				} //end for i
				curcol = 0;
				//設(shè)置數(shù)據(jù)體Style
				for(int i=0; i<dt.Columns.Count; i++)
				{
					w = cells.CreateRange(ColTitleRow+1, i, dt.Rows.Count, 1);
					w.Style = (Aspose.Cells.Style)styles[i];				
				}
				//w=cells.CreateRange(ColTitleRow+1,col,currow,ColName.Count);
				//w.Style=excel.Styles["Data"];

				//設(shè)置各列寬度
				foreach(int s in ColWidth)
					cells.SetColumnWidth(curcol++, s);

				/*
				//********可參考的格式設(shè)置*******************************************************				
				//Set number format with built-in index
				for (int i = 0; i < 37; i ++)
				{
					cells[i, 1].PutValue(1234.5);
					//int Number = cells[i, 0].IntValue;

					//Set the display number format
					cells[i, 1].Style.Number = i;
				}

				//Set number format with custom format string
				for (int i = 1; i < 4; i ++)
				{
					cells[i, 3].PutValue(1234.5);
				
					//Set the display custom number format
					cells[i, 3].Style.Custom = cells[i, 2].StringValue;
				}
				//********可參考的格式設(shè)置*******************************************************
				*/

				//workbook.Save(FileName, FileFormatType.Default, SaveType.OpenInExcel, System.Web.HttpContext.Current.Response);
				workbook.Save(FileName, FileFormatType.Default, SaveType.OpenInExcel, response);

				return true;
			}
			catch (Exception ex)
			{
				err = ex.Message;
				return false;
			}
		}//end ExportToExcel()
		#endregion

SetStyle()的：

#region SetCellStyle()設(shè)置格式，如果需要增加新的格式，請(qǐng)?jiān)赾ase后面增加，不要修改前面的

public ArrayList SetCellStyle(Workbook workbook, ArrayList styleindex)
		{
			//通用設(shè)置樣式的
			ArrayList CellStyle = new ArrayList(styleindex.Count + 2);
			Aspose.Cells.Style style = null;
			for (int i=0; i<styleindex.Count; i++)
			{
				int index = workbook.Styles.Add();
				
				style = workbook.Styles[index];
				style.Name = "Custom_Style" + ((int)(i + 1)).ToString();
				style.ForegroundColor = Color.White;
				style.HorizontalAlignment = TextAlignmentType.Center;
				style.VerticalAlignment = TextAlignmentType.Center;
				style.Font.Name = "宋體";
				style.Font.Size = 10;
				style.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
				style.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
				style.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
				style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
				
				switch((int)styleindex[i])
				{
					case 1://居中文本
						style.HorizontalAlignment = TextAlignmentType.Center;
						style.VerticalAlignment = TextAlignmentType.Center;
						break;
					case 2://特殊字體Georgia
						style.Font.Name = "Georgia";
						break;
					case 3://文本列
						style.HorizontalAlignment = TextAlignmentType.Left;
						break;
					case 4://整數(shù)列 1 Decimal 0  
						style.HorizontalAlignment = TextAlignmentType.Center;
						style.Number = 1;
						break;
					case 5://2位小數(shù) 39={Currency #,##0.00;-#,##0.00}   40={#,##0.00;[Red]-#,##0.00}
						style.HorizontalAlignment = TextAlignmentType.Right;
						style.Number = 40;
						break;
					case 6://日期列 14 Date yyyy-m-d
						style.HorizontalAlignment = TextAlignmentType.Center;
						style.Number = 14;//這個(gè)格式不是太好，還需要調(diào)整
						break;
					case 7://百分比% 10 Percentage 0.00%   
						style.HorizontalAlignment = TextAlignmentType.Center;
						style.Number = 10;
						break;
					default:
						break;
				}//end switch
				CellStyle.Add(style);
			}

			//特別增加一個(gè)用于表頭的style.Name = "SheetTitle";
			int sindex = workbook.Styles.Add();
			style = workbook.Styles[sindex];
			style.Name = "SheetTitle";
			style.Font.Size = 14;
			style.Font.IsBold = true;
			style.Font.Name = "楷體_GB2312";
			style.HorizontalAlignment = TextAlignmentType.Center;
			style.VerticalAlignment = TextAlignmentType.Center;
			style.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
			style.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
			style.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
			style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;

			CellStyle.Add(style);

			//特別增加一個(gè)用于列標(biāo)題的style.Name = "ColTitle";
			sindex = workbook.Styles.Add();
			style = workbook.Styles[sindex];
			style.Name = "ColTitle";
			style.Font.Size = 12;
			style.Font.IsBold = true;
			style.Font.Name = "宋體";
			style.HorizontalAlignment = TextAlignmentType.Center;
			style.VerticalAlignment = TextAlignmentType.Center;
			style.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
			style.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
			style.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
			style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;

			CellStyle.Add(style);

			//返回樣式數(shù)組
			return CellStyle;
			
		}//end SetCellStyle
		#endregion