/// <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();
}
