Open-source documentation and report processing components on the. NET platform include Execel PDF Word and. netexecel

Open-source documentation and report processing components on the. NET platform include Execel PDF Word and. netexecel

Do you know these. NET open source projects in the first two articles? Do you know how to make. NET open-source projects more intense? Make. NET open source more violent! In Series 2, everyone is enthusiastic. Take out your own private goods and process open-source components related to documents on the. NET platform. Document processing is a very common task in development, such as exporting Excel, exporting Word, and generating PDF reports. Today, let's look at the following open-source. NET projects. Do you know? Do not forget to recommend it if it is useful. At the same time, my personal abilities are limited. I hope you can add them.

. NET open-source Directory: [Directory] Directory of other. NET open-source projects in this blog

Address of the original article: Do you know these. NET open source projects? (3rd). NET open source documentation and Report Processing

1. Excle artifact NPOI

NPOI is the. NET version of the POI project. POI is an open-source Java project for reading and writing Microsoft OLE2 component documents such as Excel and WORD. NPOI provides the. NET platform with a comprehensive Excel Reading and Writing Tool. It is widely used. It should be one of the most widely exposed open-source. NET Excel read/write tools.

NPOI has the following advantages: completely free to use, including most EXCEL features (cell style, data format, formula, etc.). Supported file formats include xls, xlsx, and docx. adopt an interface-oriented design architecture (you can view NPOI. SS namespace). It also supports File Import and Export. You do not need to install Microsoft Office on the server to avoid copyright issues. It is more convenient and user-friendly than Office PIA APIs. So what are you waiting? The following is a daily report tool that I used NPOI for the first time. Cell merging is completed dynamically in the program. The process is very difficult, but the results are very good. It has been used for two years, stable and bug-free, very powerful.

Http://npoi.codeplex.com/

Https://github.com/tonyqus/npoi

Official Tutorial: http://www.npoi.info/

2. NPOI extension-NPOI. CSS

NPOI. CSS is a NPOI extension that allows you to set cell styles using CSS-like methods when using NPOI. It only supports projects of. NET4 and later versions. This extension is used to set cells and their related format styles for ease of use. Css-like methods can be used, which is very powerful. Take a look at the following code:

1	cell.CSS("Color: red; font-weight: bold; font-size: 11; font-name:; border-type: thin ;")

Https://github.com/qihangnet/npoi.css

3. yjinglee. office

Yjinglee. office is used for Excel operations on the. Net platform. It encapsulates NPOI to provide more simple and practical APIs and provides the following functions:

1. Read Excel Data and convert it to an object set
2. Write a collection to Excel and provide Excel Style definitions.

Take a look at the code for reading Excel:

12345678910

var Reports = new Collection();for (var i = 0; i < 10; i++){    Reports.Add(new Report {Id = i*100, Name = Guid.NewGuid().ToString()});}var excel = new Excel(new DefaultStyle());// Create an Excel instance and pass different style instancesexcel.CreateSheet("Test");// Create a Sheet named Testexcel.WriteObject(Reports, 0, 0);// Write a set of 0th rows in Sheet0excel.SetColumnWidth(0, 0, new [] {5, 35});// Set the column width in sequence starting from column 0th of Sheet0excel.WriteFile(Path.Combine(AppDomain.CurrentDomain.SetupInformation.ApplicationBase, "demo.xlsx"));// Save the file

4. ExcelReport Report Engine

ExcelReport is a report engine component developed based on NPOI. It separates data from styles and formats based on the separation of concerns. Enable the template to carry the style, format, and other NPOI not very good at and implement tedious information, and combine the advantages of NPOI in data processing to simplify the generation of Excel reports. At the same time, the basic elements of the report are abstracted to further simplify the process of generating an Excel report.

Https://github.com/hanzhaoxin/ExcelReport

Article: http://www.cnblogs.com/hanzhaoxin/p/4472860.html

5. Epplus

Epplus is an Open-source component that reads and writes Excel 2007/2010 files in the Open Office XML (Xlsx) file format. Compared with NPOI, it supports Xlsx earlier, while NPOI supports Excel 2003 better. Now the new version of NPOI also supports Xlsx. So there is a difference between them. I have never used Epplus, but I have heard of it for a long time. It is also very official and has been updated. Let's look at your usage requirements. You can try it. Supports a wide range, such as cell merging, cell style, charts (this NPOI is not very good at the moment), tables, data verification, formulas, VBA, and so on.

Http://epplus.codeplex.com/

6. LinqToExcel

LinqToExcel is an open-source project on the. NET platform. It mainly implements the syntax query for Excel workbooks in LINQ. LINQToXXX before the type is the most suitable for you if you are a sugar enthusiast of the LINQ syntax. For example, the following code queries the workbook header:

1234	var excel = new ExcelQueryFactory("excelFileName");var indianaCompanies = from c in excel.Worksheet<Company>()                       where c.State == "IN"                       select c;

Https://github.com/paulyoder/

7. NetOffice Components

NetOffice is a powerful component used to operate the Office, including Office, Excel, Word, Outlook, PowerPoint, Access, Project, and Visio. However, this component is not completely written separately. Instead, it calls the Microsoft Office interoperability assembly and VSTO, which is a deep encapsulation, so that you do not need to install these components, you only need to copy the corresponding assembly. Currently, a total of 16 operational assemblies are included. You can select the corresponding assembly as needed. It has several advantages:

1. There is no version limit for Office;
2. Support for Office2000, windows, and Windows is powerful enough to support all Office versions;
3. Support independent development between versions
4. The operation syntax is the same as that of Microsoft's Interoperability assembly, so it is easier to learn and use;
5. If you are familiar with the Office object model, you can use your existing PIA code without re-learning;
6. Optimized Code for some COM operations
7. It can be used in. NET2.0 or a later environment;
8. easy deployment, no registration required, no dependent assembly

For other functions, refer to the official document. If you have a strong demand for these functions, you can write an article to introduce them.

Http://netoffice.codeplex.com/

8. Docx

DocX is a lightweight. NET component used to operate Word 2007/2010 files in a very intuitive and simple way. It is fast and does not need to install Microsoft Office software. In China, free and compact WPS has enough reason for many users to give up a huge Office, which is useful in actual software development. Unfortunately, it does not support 2003, but it is always the trend of elimination, and there is no difference in the use of WPS. Currently, you can insert, delete, and replace texts in files. All text formats, such as font, underline, and highlight, are supported; supports inserting images, hyperlinks, tables, headers and footers, and custom attributes. Supports JQuery-like chained writing for convenient programming.

Compared with Excel, open-source Doc files have fewer components. This component can only barely meet some basic functions. There are still many pitfalls when encountering some advanced ones. But in general, regular support is the first step. This project is also being updated and is expected to be improved. In 2013, I wrote an article about basic usage: [original] Open-source Word read/write component DocX introduction and introduction

Http://docx.codeplex.com/

9. PDF processing component PDFsharp

You must have thought about generating documents in PDF file format. Many projects have also been used, and there must be many methods and components. However, the. NET platform does not provide much open-source resources for free. It is best to use ItextPDF, but it is not free for non-commercial users, so we should leave it out. Let's take a look at it for free. This sort Sharp is well-developed and is continuously updated. Supported functions include:

You can use the. NET programming language to dynamically create PDF documents,

It is easy to use object models to build documents,

Use C # to rewrite the design and code,

PDF files can be generated and displayed in the form or print,

The same source file can be used to modify, merge, or split PDF files,

You can control the transparency of images, embed fonts, and so on. The overall support is comprehensive, but it has not been tested in person.

Http://www.pdfsharp.net/

10. MigraDoc document Builder

MigraDoc is an open-source file generator on the. NET platform. It supports almost all text processing functions. You only need to add paragraphs, tables, or charts to the section, and use bookmarks to create links, table content, indexes, and so on. MigraDoc automatically performs paging and layout to generate PDF, XPS, and RTF document formats. In general, it is a simpler type of generic document generation tool. Its official website and PDFsharp are both in progress and are currently being updated.

Http://www.pdfsharp.net/

11. PdfReport report tool

PdfReport is a report engine that supports code-first and is built on the iTextSharp and EPPlus open-source projects. Support for. net 3.5 or above. Take a look at an image of the project:

Http://pdfreport.codeplex.com/

12. Comparison of file differences diffplex

Diffplex is an open-source C # text difference comparison software. Supports. NET 4.0, Silverlight 5.0, Windows 8.0, Windows Phone 8.0, Windows Phone Appx 8.1, and other environments. As shown in:

Https://github.com/mmanela/diffplex

13. ReportGenerator

ReportGenerator can convert XML reports generated by OpenCover, PartCover, Visual Studio, or NCover into better readable formats. The above tools are all code coverage analysis tools. The converted reports are in the following format:

1. HTML, HTMLSummary

2. XML, XMLSummary

3. Latex, LatexSummary

4. TextSummary

5. Custom reports

This component has been continuously updated. It should be helpful for people who specialize in testing. I have also seen the article using this component to display the analyzed report, but I don't quite understand it, do not go into details.

Https://github.com/danielpalme/ReportGenerator

14. BusyReports

BusyReports is a very convenient application for generating reports from SSRS Web Services. BusyReports provides a GUI for you to easily configure report parameters, emails, and file paths. The configuration information is stored in four easy-to-edit tables. This component is similar to the data-driven subscription of SQL Server, but some restrictions are deleted. This component is currently being updated. See the following GUI configuration interface:

Http://busyreports.codeplex.com/

15. Seal Report

Seal Report should be the best and most commonly used of the above. It provides a complete architecture for generating reports from any other database. This product focuses on easy installation and report design. Once installed, the report can be created and published soon. This component is fully open-source and is written in C. Its main features are: 1. dynamic SQL data source: You can use SQL or use the Seal engine to construct dynamic SQL for database query. 2. local Pivot Table: Drag and Drop elements directly in the pivot table and display them in the report. HTML5 charts are also supported. Go to the official website for details, the following shows the design and results of the two reports:

Report results:

Http://sealreport.codeplex.com/