http://www.cnblogs.com/lanyue52011/p/3372452.html这个是原文地址

 /// <summary>

        /// 点击按钮，将内存表导出excel表格！

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        protected void Button1_Click(object sender, EventArgs e)

        {

//这三行是原文中所没有的，不设置license的话，会有warning，至于liscense文件，百度云中有！

            Aspose.Cells.License li = new Aspose.Cells.License();

            string path = Server.MapPath("License.lic");

            li.SetLicense(path);
//这三行是原文中没有的……

            Aspose.Cells.Workbook book = new Aspose.Cells.Workbook();

            Aspose.Cells.Worksheet sheet = book.Worksheets["Sheet1"];

            sheet.FreezePanes(, , , );

            Aspose.Cells.Style style = book.Styles[book.Styles.Add()];

            style.Pattern = Aspose.Cells.BackgroundType.Solid;

            style.Borders.SetStyle(Aspose.Cells.CellBorderType.Thin);

            style.Borders.SetColor(System.Drawing.Color.LightSteelBlue);

            style.IsTextWrapped = true;

            style.Font.Size = ;

            Aspose.Cells.StyleFlag flag = new Aspose.Cells.StyleFlag();

            flag.All = true;

            sheet.Cells.ApplyStyle(style, flag);

            style.VerticalAlignment = Aspose.Cells.TextAlignmentType.Center;

            style.Font.IsBold = true;

            flag.All = true;

            sheet.Cells.Rows[].ApplyStyle(style, flag); sheet.Cells.ImportDataTable(datas, true, , , datas.Rows.Count, datas.Columns.Count, false, "yyyy-MM-dd", false);

            book.Save(DateTime.Now.ToString("yyyyMMddhhmmss") + ".xlsx", Aspose.Cells.FileFormatType.Excel2007Xlsx, Aspose.Cells.SaveType.OpenInExcel, Response);

        }