public static Worksheet Decode(Workbook book, Stream stream, SharedResource sharedResource)
        {
            Worksheet worksheet = new Worksheet();

            worksheet.Book = book;
            List <Record> list = WorksheetDecoder.ReadRecords(stream, out worksheet.Drawing);

            worksheet.Cells = WorksheetDecoder.PopulateCells(list, sharedResource);
            worksheet.Book.Records.AddRange(list);
            return(worksheet);
        }
        public static FONT getFontForCharacter(Cell cell, ushort charIndex)
        {
            FONT          result      = null;
            int           num         = cell.Style.RichTextFormat.CharIndexes.BinarySearch(charIndex);
            List <ushort> fontIndexes = cell.Style.RichTextFormat.FontIndexes;

            if (num >= 0)
            {
                result = WorksheetDecoder.getFontRecord(cell.SharedResource, fontIndexes[num]);
            }
            else
            {
                if (~num != 0)
                {
                    result = WorksheetDecoder.getFontRecord(cell.SharedResource, fontIndexes[checked (~num - 1)]);
                }
            }
            return(result);
        }
Beispiel #3
0
        public static Workbook Decode(Stream stream)
        {
            Workbook       book = new Workbook();
            SharedResource sharedResource;
            List <Record>  records = ReadRecords(stream, out book.DrawingGroup);

            book.Records = records;
            List <BOUNDSHEET> boundSheets = DecodeRecords(records, out sharedResource);

            foreach (BOUNDSHEET boundSheet in boundSheets)
            {
                stream.Position = boundSheet.StreamPosition;
                Worksheet sheet = WorksheetDecoder.Decode(book, stream, sharedResource);
                sheet.Book      = book;
                sheet.Name      = boundSheet.SheetName;
                sheet.SheetType = (SheetType)boundSheet.SheetType;
                book.Worksheets.Add(sheet);
            }
            return(book);
        }
        public static Workbook Decode(Stream stream)
        {
            Workbook      workbook = new Workbook();
            List <Record> records  = WorkbookDecoder.ReadRecords(stream, out workbook.DrawingGroup);

            workbook.Records = records;
            SharedResource    sharedResource;
            List <BOUNDSHEET> list = WorkbookDecoder.DecodeRecords(records, out sharedResource);

            foreach (BOUNDSHEET current in list)
            {
                stream.Position = (long)((ulong)current.StreamPosition);
                Worksheet worksheet = WorksheetDecoder.Decode(workbook, stream, sharedResource);
                worksheet.Book      = workbook;
                worksheet.Name      = current.SheetName;
                worksheet.SheetType = (SheetType)current.SheetType;
                workbook.Worksheets.Add(worksheet);
            }
            return(workbook);
        }