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
DISCONTINUED. EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx). -
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. -
-
MiniExcel
Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac) -
DocX
Fast and easy to use .NET library that creates or modifies Microsoft Word files without installing Word. -
ExcelDna
Excel-DNA - Free and easy .NET for Excel. This repository contains the core Excel-DNA library. -
-
-
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 -
-
-
ExcelDna-Unpack
Command-line utility to extract the contents of Excel-DNA add-ins packed with ExcelDnaPack -
Syncfusion .NET Word Framework
This repository contains the samples for Syncfusion file format Windows Forms products and the guide to use them. -
Outlook Redemption
Library to work with the Outlook Object Model and (Extended) MAPI. Supports Outlook 98 -
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] -
Syncfusion .NET Excel Framework
A high-performance .NET Excel framework without Microsoft Office or interop dependencies. Create, read, and edit Excel documents seamlessly. Utilize Spreadsheet controls for creating, editing, and viewing easily. Effortlessly convert Excel files to PDF, images, and more with powerful conversion APIs. [$] [Free for Individuals and Small Businesses] -
Syncfusion .NET PowerPoint Framework
A high-performance .NET PowerPoint framework without Microsoft Office or interop dependencies. Create, read, and edit PowerPoint files seamlessly. Effortlessly convert PowerPoint files to PDFs and images with powerful conversion APIs. [$] [Free for Individuals and Small Businesses]
SaaSHub - Software Alternatives and Reviews
* 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?
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