生成excel文件

 /// <summary>
        /// 将DataTable导出到Excel，参数dtData：表(DataTable)，iCompanyId：机构编号，sExcelName：Excel表名，sColumn：列名和对应的标题，sUrl：返回文件的下载路径
        /// </summary>
        /// <param name="dtData">表(DataTable)</param>
        /// <param name="iCompanyId">机构编号</param>
        /// <param name="sExcelName">Excel表名，如：商品表</param>
        /// <param name="sColumn">列名和对应的标题，列之间用逗号分隔，列名和标题用分号分隔(如："id:编号,name:姓名")</param>
        /// <param name="sUrl">返回文件的下载路径</param>
        public static bool DataTableToExcel(DataTable tbData, int iCompanyId, string sExcelName, string sColumn, ref string sUrl)
        {
            DateTime dtNow = DateTime.Now;
            string sPathName = "", sFileName = "";
            string sPath = BizPubFun.GetCompanyDir(iCompanyId);
            sPath += "pay_pic\\" + dtNow.ToString("yyyy") + "\\" + dtNow.ToString("MMdd") + "\\";
            try
            {
                if (!System.IO.Directory.Exists(sPath))
                {
                    Directory.CreateDirectory(sPath);
                }
            }
            catch (Exception e)
            {
                PubFun.WriteLogFile("DataTableToExcel " + e.Message);
                return false;
            }            sFileName = sExcelName + dtNow.ToString("yyyyMMddHHmmss") + ".xls";
            sPathName = sPath + sFileName;
            sUrl = BizPubFun.GetCompanyPath(iCompanyId) + "pay_pic/" + dtNow.ToString("yyyy") + "/" + dtNow.ToString("MMdd") + "/" + sFileName;            return DataTableToExcel(tbData, sPathName, sColumn);
        }