/// <summary> /// CreateXLS /// </summary> protected void CreateXLS(string SearchFileName) { #region 設定 //檔名 string xls_typeName, xls_date, xls_filename; xls_typeName = SearchFileName; xls_date = DateTime.Today.ToString("yyyy-MMdd"); xls_filename = xls_date + "_" + xls_typeName; CreateXLS CX = new CreateXLS(); HSSFWorkbook workbook = new HSSFWorkbook(); MemoryStream ms = new MemoryStream(); //要輸出的欄位 int[] list = { }; #endregion //呼叫產生XLS CX.DoCreateXLS(workbook, ms, list.ToList(), gv_List, false, ""); //輸出 Response.AddHeader("Content-Disposition", string.Format("attachment; filename=" + HttpUtility.UrlEncode(xls_filename, System.Text.Encoding.UTF8) + ".xls")); Response.BinaryWrite(ms.ToArray()); workbook = null; ms.Close(); ms.Dispose(); }
/// <summary> /// XLS /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnXls_Click(object sender, EventArgs e) { //先查詢 btn_Submit_Click(sender, e); #region 設定 var xls_filename = string.Format("{0}_系列盤點清單_【{1}筆】", DateTime.Now.ToString("yyyy-MMdd"), numcount); CreateXLS CX = new CreateXLS(); HSSFWorkbook workbook = new HSSFWorkbook(); MemoryStream ms = new MemoryStream(); //要輸出的欄位 int[] list = { }; #endregion //呼叫產生XLS CX.DoCreateXLS(workbook, ms, list.ToList(), gv_List, false, ""); //輸出 Response.AddHeader("Content-Disposition", string.Format("attachment; filename=" + HttpUtility.UrlEncode(xls_filename, System.Text.Encoding.UTF8) + ".xls")); Response.BinaryWrite(ms.ToArray()); workbook = null; ms.Close(); ms.Dispose(); }