Description
A lightweight excel(2007-) parser!
This is a simple excel reader, it can run on any .Net Framework.
As we know, Excel 2007 is a open xml format and compress with Zip foramt.
It have no third library dependence and almost can run any .net framwork(No Excel Interop, No Open XML SDK
and No using Linq, Xml and DataSet of C# System api),
maybe on window mobile you shoud modify a little for the missing api.
I use the ZipArchive(https://github.com/srxqds/ZipWrapper) and XMLParser(https://github.com/srxqds/XMLParser).
but it should be used on some editor work and no performance requirement situation!
Use Tips:
1.The sheetIndex, rowIndex and columnIndex are range between 0 to count!
2.Maybe some optimization or modify you should make by yourself depending on your needs.
Todo:
1.More flexible api to work!(done)
2.Test and fix the bug and handle some unexpect situation.(done)
3.Add Ceil Comment support!(done)
4.Trim the empty Row and Column!(done)
5.More optimization and test case!
Inspired By:
1.FastExcel:https://github.com/mrjono1/FastExcel/tree/master/FastExcel
2.C# How To Read .xlsx Excel File With 3 Lines of Code:http://www.codeproject.com/Tips/801032/Csharp-How-To-Read-xlsx-Excel-File-With-Lines-of
D.S. Qiu
2016 Guangzhou, Lucky Game
PureExcel alternatives and similar packages
Based on the "Office" category.
Alternatively, view PureExcel alternatives based on common mentions on social networks and blogs.
-
NPOI
a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop. -
EPPlus
EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx). -
ExcelDataReader
Lightweight and fast library written in C# for reading Microsoft Excel files -
ClosedXML
ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API. -
-
DocX
Fast and easy to use .NET library that creates or modifies Microsoft Word files without installing Word. -
MiniExcel
Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet -
ExcelDna
Excel-DNA - Free and easy .NET for Excel. This repository contains the core Excel-DNA library. -
NetOffice
🌌 Create add-ins and automation code for Microsoft Office applications. -
-
Report-From-DocX-HTML-To-PDF-Converter
.NET Core library to create custom reports based on Word docx or HTML documents and convert to PDF -
ShapeCrawler
🍂 A .NET library for manipulating PowerPoint presentations -
BookFx
Composing Excel spreadsheets based on a tree of nested components like the HTML DOM. -
ExcelDna-Unpack
Command-line utility to extract the contents of Excel-DNA add-ins packed with ExcelDnaPack -
GemBox.Bundle
A package of .NET components that enable fast, simple and efficient processing of office files (Excel, Word, PowerPoint, PDF and emails). [$]****[Free Lite versions] -
Outlook Redemption
Library to work with the Outlook Object Model and (Extended) MAPI. Supports Outlook 98
Clean code begins in your IDE with SonarLint
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest.
Do you think we are missing an alternative of PureExcel or a related project?
|
Access the most powerful time series database as a service
sponsored
www.influxdata.com
|
Popular Comparisons
-
PureExcelvsEPPlus
-
PureExcelvsClosedXML
-
PureExcelvsNPOI
-
PureExcelvsExcelDataReader
-
PureExcelvsOpen XML SDK
|
ONLYOFFICE Docs — document collaboration in your environment
sponsored
www.onlyoffice.com
|
README
PureExcel
A lightweight excel(2007-) parser!
This is a simple excel reader, it can run on any .Net Framework.
As we know, Excel 2007 is a open xml format and compress with Zip foramt.
It have no third library dependence and almost can run any .net framwork(No Excel Interop, No Open XML SDK and No using Linq, Xml and DataSet of C# System api), maybe on window mobile you shoud modify a little for the missing api.
I use the ZipArchive(https://github.com/srxqds/ZipWrapper) and XMLParser(https://github.com/srxqds/XMLParser).
but it should be used on some editor work and no performance requirement situation!
Use Tips:
1.The sheetIndex, rowIndex and columnIndex are range between 0 to count!
2.Maybe some optimization or modify you should make by yourself depending on your needs.
Todo:
1.More flexible api to work!(done)
2.Test and fix the bug and handle some unexpect situation.(done)
3.Add Ceil Comment support!(done)
4.Trim the empty Row and Column!(done)
5.More optimization and test case!
6.Support stream parser!
7.Excel formula parsing!
Inspired By:
1.FastExcel:https://github.com/mrjono1/FastExcel/tree/master/FastExcel
2.C# How To Read .xlsx Excel File With 3 Lines of Code:http://www.codeproject.com/Tips/801032/Csharp-How-To-Read-xlsx-Excel-File-With-Lines-of
D.S. Qiu
2016 Guangzhou, Lucky Game