Development components related to Microsoft Office and office development components

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.