EXCEL导出

 

//获得数据集

            DataSet ds = new DataSet();
            ds.Tables.Add(dtbl);

            //获得sheet名(每个DataTable对应一个sheet)
            //从资源文件取得画面信息

 

            //string resourceValue = (string)base.GetLocalResourceObject("pageInfoResource");
            string[] sheetname ={ "InStockView",  };

            //获得Excel文件名

            //string strdate = DateTime.Now.ToString("yyyyMMddHHmmss");
            string filename = "InStockView" + ".xls";

            //获得列索引

 

            int[] columnIndexFrom = { 0 };

            int[] columnIndexTo = { ds.Tables[0].Columns.Count - 1};

            //生成Excel文件

            new PrintHelper().WriteExcel(ds, sheetname, filename, true, columnIndexFrom, columnIndexTo);

 

        public void WriteExcel(DataSet ds, string[] sheetname, string filename, bool showHead, int[] columnIndexFrom, int[] columnIndexTo)
        {
  
           //客户端生成Excel文件
            int count = ds.Tables.Count;
            DataTable[] dt = new DataTable[count];
            for (int i = 0; i < count; i++)
            {
                dt[i] = ds.Tables[i];
            }
            ExcelBook eb = new ExcelBook(dt, sheetname, showHead,columnIndexFrom, columnIndexTo);
            eb.IsAutoFitWidth = true;//自定适用列宽
            eb.Author = "";//作者
            eb.LastAuthor = "";//最后作者
            eb.Company = "";//公司
            eb.Version = "";//版本
            eb.WriteExcelToClient(filename);//下载Excel文件

        }