Esempio n. 1
0
 private Stream GetWorkBookStream(XLSFile file)
 {
     try
     {
         return(file.OpenStream("Workbook"));
     }
     catch (IOException)
     {
         return(file.OpenStream("Book"));
     }
 }
Esempio n. 2
0
        private void Load(XLSFile file)
        {
            List<SheetRecord> sheets = new List<SheetRecord>();
            using (var stream = GetWorkBookStream(file))
            {
                SstRecord sst = null;
                SheetRecord currentSheet = null;
                while (stream.Length - stream.Position >= BIFFData.MinSize)
                {
                    var record = GetRecord(new BIFFData(stream), stream);
                    if (record != null)
                        GetSheetRecords(sheets, ref sst, ref currentSheet, record);
                }
                sheets.ForEach(i => i.SST = sst);
            }

            if (sheets.Count > 0)
                GetSheets(sheets);
        }
Esempio n. 3
0
        private void Load(XLSFile file)
        {
            List <SheetRecord> sheets = new List <SheetRecord>();

            using (var stream = GetWorkBookStream(file))
            {
                SstRecord   sst          = null;
                SheetRecord currentSheet = null;
                while (stream.Length - stream.Position >= BIFFData.MinSize)
                {
                    var record = GetRecord(new BIFFData(stream), stream);
                    if (record != null)
                    {
                        GetSheetRecords(sheets, ref sst, ref currentSheet, record);
                    }
                }
                sheets.ForEach(i => i.SST = sst);
            }

            if (sheets.Count > 0)
            {
                GetSheets(sheets);
            }
        }
Esempio n. 4
0
 private Stream GetWorkBookStream(XLSFile file)
 {
     try
     {
         return file.OpenStream("Workbook");
     }
     catch (IOException)
     {
         return file.OpenStream("Book");
     }
 }