C# (CSharp) Common LogHelper.WriteTextLog示例

示例#1

        public static DataSet ImportExceltoDt_New(string strFileName)
        {
            DataSet ds = new DataSet();

            try
            {
                HSSFWorkbook hssfworkbook;
                using (FileStream file = new FileStream(strFileName, FileMode.Open, FileAccess.Read))
                {
                    hssfworkbook = new HSSFWorkbook(file);
                }

                for (int i = 0; i < hssfworkbook.NumberOfSheets; i++)
                {
                    DataTable dt    = new DataTable();
                    HSSFSheet sheet = hssfworkbook.GetSheetAt(i) as HSSFSheet;
                    if (sheet != null)
                    {
                        dt = ImportDt(sheet, 0, true, sheet.SheetName);
                        ds.Tables.Add(dt);
                    }
                }
            }
            catch (Exception ex)
            {
                LogHelper.WriteTextLog("ImportExceltoDt_New", ex.ToString());
            }
            return(ds);
        }