Exemple #1
0
        public void LoadFromFile(string fileName)
        {
            var stream = File.Open(fileName, FileMode.Open, FileAccess.Read);
            var reader = ExcelReaderFactory.CreateReader(stream);

            for (int i = 0; i < reader.ResultsCount; i++)
            {
                var sheet = new ExcelSheetData();
                LogUtils.instance.AddLog("读取页签:" + reader.Name);
                sheet.ReadFromExcel(reader.Name, reader);

                if (sheet.isNeedExprot)
                {
                    excelSheets.Add(sheet);
                }
                else
                {
                    LogUtils.instance.AddLog("页签无需导出 , 跳过 :" + reader.Name);
                }

                reader.NextResult();
            }

            stream.Close();
        }