Development components related to Microsoft Office and office development components

Development components related to Microsoft Office and office development components

Install the office and directly reference the COM control

C #4 provides a reference method for PIA: The Link (the compiler only embeds the required parts of PIA directly into the assembly), and the variant (variant) is considered as a dynamic type, to reduce the overhead required for forced conversion;

 

If the office is not installed, copy the related dll to the running directory and reference it directly;

The dll version to be copied should be 12 or above, and a compatible bug should be found below 12;

 

Use Office Open Xml for development: a Microsoft office-free SDK Library

 

EPPlus is a component encapsulated based on Office Open Xml.

Http://www.cnblogs.com/rumeng/p/3785748.html? Utm_source = tuicool & utm_medium = referral

 

NPOI:

Structure:

HSSF-provides the ability to read and write Microsoft Excel files. Is to operate excel2003in front of (package for RMB, the extension name is .xls

XSSF-provides the ability to read and write files in Microsoft Excel OOXML format. The extension name is .xlsx.

HWPF-read and write Microsoft Word files.

HSLF-supports reading and writing Microsoft PowerPoint files.

HDGF-read and write Microsoft Visio files.

Tutorial:

Http://www.tuicool.com/sites/JjAjq2? Pn = 0

Open Source Address: https://github.com/tonyqus/npoi/

NPOI. Examples many Examples are based on Version 1.0

 

An encapsulation library of ExcelReport Based on NPOI

Instructions for use http://www.cnblogs.com/hanzhaoxin/tag/ExcelReport%20/

 

Spire-related components are available in commercial and free versions.

Spire.xls

Http://www.cnblogs.com/aehyok/p/3749339.html

Http://www.cnblogs.com/pengze0902/p/6122311.html

Spire. Doc

Http://www.cnblogs.com/yanweidie/archive/2015/10/19/4888199.html

 

Aspose. Total commercial software

Http://baike.baidu.com/link? Url = x9DxGF7PvIR96U3Zw8jws7MYNKfIl3OR6oZi_zdI7PNZoIb4_SBFDTyrFx6zIkbc-FtGTOgPwtxITupSxuW4W7_ccSSfp-p3y6h4SoOc-CW