RubyPDF Blog

Introduction

This library is built based on the following documents, thanks to their authors:

• Compound Document file format
• Excel file format
• Microsoft Office 97 Drawing File Format

Record structures in BIFF8/BIFF8X format are considered.

What it can do?

• It can read read worksheets in a workbook and read cells in a worksheet.
• It can read cell content (text, number, datetime, or error) and cell format (font, alignment, linestyle, background, etc.).
• It can read pictures in the file, get information of image size, position, data, and format.

Using the code

1. Open file:

   Stream fileStream = File.OpenRead(file);
   Workbook book = new Workbook();
   book.Open(fileStream);
   Worksheet sheet = book.Worksheets[0];

2. Read cell:

   int row = 1;
   int col = 0;
   string ID = sheet.Cells[row, col].StringValue;
    
   Picture pic = sheet.ExtractPicture(row, col);