將程式中的表格，匯出產生excel表格。使用Aspose外掛程式實現

標籤：

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(1, 1, 1, 0);            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 = 10;            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[0].ApplyStyle(style, flag); sheet.Cells.ImportDataTable(datas, true, 0, 0, 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);        }

　　

將程式中的表格，匯出產生excel表格。使用Aspose外掛程式實現