Click here to Skip to main content
11,429,977 members (73,121 online)
Click here to Skip to main content

Excel Reader

, 20 Feb 2009 LGPL3
Rate this:
Please Sign up or sign in to vote.
Create, read and modify Excel *.xls files in pure C# without COM interop
Sample Image - ExcelReader.png

Introduction

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

Record structures in BIFF8/BIFF8X format are considered.

Now this project is hosted on Google Code.
You can get the latest code, report issues and submit improvements from there. 

What It Can Do?

  • It can 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.
  • It can create a workbook and save to file.

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);
  3. Create workbook:
    string file = "C:\\newdoc.xls";
    Workbook workbook = new Workbook();
    Worksheet worksheet = new Worksheet("First Sheet");
    worksheet.Cells[0, 1] = new Cell(1);
    worksheet.Cells[2, 0] = new Cell(2.8);
    worksheet.Cells[3, 3] = new Cell((decimal)3.45);
    worksheet.Cells[2, 2] = new Cell("Text string");
    worksheet.Cells[2, 4] = new Cell("Second string");
    worksheet.Cells[4, 0] = new Cell(32764.5, "#,###.00");
    worksheet.Cells[5, 1] = new Cell(DateTime.Now, @"YYYY\-MM\-DD");
    worksheet.Cells.ColumnWidth[0, 1] = 3000;
    workbook.Worksheets.Add(worksheet);
    workbook.Save(file);
  4. Traverse worksheet:
     // traverse cells
     foreach (Pair<Pair<int, int>, Cell> cell in sheet.Cells)
     {
         dgvCells[cell.Left.Right, cell.Left.Left].Value = cell.Right.Value;
     }
    
     // traverse rows by Index
     for (int rowIndex = sheet.Cells.FirstRowIndex; 
    	rowIndex <= sheet.Cells.LastRowIndex; rowIndex++)
     {
         Row row = sheet.Cells.GetRow(rowIndex);
         for (int colIndex = row.FirstColIndex; 
    	colIndex <= row.LastColIndex; colIndex++)
         {
             Cell cell = row.GetCell(colIndex);
         }
     }

History

  • 2007-5-17
    • Displayed each Sheet in separate tabpage
    • Fixed some bugs in FORMULA.cs and Form1.cs
  • 2007-5-26
    • Decoded FORMULAR result
  • 2008-1-23
    • Changed default Encoding from ASCII to UTF8 in Record.cs ln97 (suggested by ragundo)
    • Return EmptyCell instead of null for non existing cells (requested by amrlafi)
    • Bug fix in Record.cs ln83 and ln133 (proposed by dhirshjr and ilogpasig)
    • Tried to fix bug in CompoundDocument.cs (found by stevenbright)
  • 2008-9-15
    • Create, Open and Modify CompoundDocument
  • 2008-9-22
    • Save modified CompoundDocument
  • 2008-10-26
    • Encoded workbook and worksheet to BIFF8 records
    • Fixed a bug that compressed Unicode string wrongly decoded by UTF8
  • 2008-11-10
    • Fixed XF format so that the created *.xls file can be opened by Microsoft Excel 2003
  • 2008-11-16
    • Assigned number format for number and date time values
    • Set column widths
  • 2009-1-3
    • Updated project source code and article text
    • Many bug fixes
    • Added support to create and modify *.xls files
  • 2009-01-20
    • Fix for getting 'NaN' when reading string value of a formula cell
    • Start a Google Code project
  • 2009-01-23
    • Support for decode cell format and encode predefined cell format
    • Changed namespaces and directory structure
    • Added some test cases
  • 2009-02-12
    • Initial implementation of encode images

License

This article, along with any associated source code and files, is licensed under The GNU Lesser General Public License (LGPLv3)

Share

About the Author

Liu Junfeng
Software Developer (Senior) Beyondsoft SH
China China
No Biography provided

Comments and Discussions

 
Questionexcel文件转成pdf Convert excel to pdf Pin
ming_775519-Mar-15 17:34
memberming_775519-Mar-15 17:34 
QuestionTks for thread! Pin
vietnam-travel-vietnam-tour25-Mar-14 21:40
professionalvietnam-travel-vietnam-tour25-Mar-14 21:40 
NewsMessage Automatically Removed Pin
16-Oct-13 23:51
memberJamie Calops16-Oct-13 23:51 
Questionformatting Pin
mbowles20129-Jan-13 6:41
membermbowles20129-Jan-13 6:41 
QuestionData amount related problem Pin
Llarian3-Sep-12 4:45
memberLlarian3-Sep-12 4:45 
GeneralMy vote of 5 Pin
tomercagan26-Aug-12 2:03
membertomercagan26-Aug-12 2:03 
QuestionHow can i dump a worksheet to a DataTable? Pin
navakiran19-Aug-12 2:18
membernavakiran19-Aug-12 2:18 
GeneralMy vote of 5 Pin
cdwilliams11-Jul-12 10:24
membercdwilliams11-Jul-12 10:24 
SuggestionC# Read Excel and Show in WPF DataGrid Pin
Member 471378514-Jun-12 5:49
memberMember 471378514-Jun-12 5:49 
QuestionError writing to excel when using japanese characters Pin
princektd13-Jun-12 21:29
memberprincektd13-Jun-12 21:29 
QuestionFix for Reading Excel with Macro Issue? Pin
gsanchezbiz27-Mar-12 22:12
membergsanchezbiz27-Mar-12 22:12 
QuestionImages count [modified] Pin
afxii15-Jan-12 3:37
memberafxii15-Jan-12 3:37 
QuestionCol count? Pin
Okan Kocyigit22-Dec-11 3:11
memberOkan Kocyigit22-Dec-11 3:11 
QuestionCharting/graphs Pin
forge33_se31-Aug-11 16:11
memberforge33_se31-Aug-11 16:11 
QuestionMerge cells Pin
plextoR24-Jul-11 1:44
memberplextoR24-Jul-11 1:44 
GeneralMy vote of 3 Pin
Reelix13-Apr-11 1:55
memberReelix13-Apr-11 1:55 
GeneralMy vote of 5 Pin
rajesh_chan28-Mar-11 23:36
memberrajesh_chan28-Mar-11 23:36 
GeneralClass reference Pin
senguptaamlan8-Mar-11 2:53
membersenguptaamlan8-Mar-11 2:53 
AnswerRe: Class reference Pin
DrkSpyder26-Dec-11 21:50
memberDrkSpyder26-Dec-11 21:50 
GeneralRe: Class reference Pin
Nick Merchant1-May-12 11:43
memberNick Merchant1-May-12 11:43 
GeneralMy vote of 5 Pin
careced1-Mar-11 8:36
membercareced1-Mar-11 8:36 
GeneralMy vote of 5 Pin
sneff28-Feb-11 3:51
membersneff28-Feb-11 3:51 
GeneralCompoundDocument should implement IDisopsable Pin
sneff28-Feb-11 3:30
membersneff28-Feb-11 3:30 
GeneralRe: CompoundDocument should implement IDisopsable Pin
Liu Junfeng31-Mar-11 7:07
memberLiu Junfeng31-Mar-11 7:07 
GeneralRe: CompoundDocument should implement IDisopsable Pin
sneff31-Mar-11 11:20
membersneff31-Mar-11 11:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.150428.2 | Last Updated 20 Feb 2009
Article Copyright 2006 by Liu Junfeng
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid