OpenXmlPowerTools2023 1.1.0

This Repository: https://github.com/danbetts/OpenXmlPowerTools2023

NuGet package: https://www.nuget.org/packages/OpenXmlPowerTools2023

News

This repository was forked from Erik White's as of 01 October 2023. There were over four years of pull requests pending that have been incorporated.

This branch has been detached from the original fork, as the intention is to go in a bit of a different direction, which will result in significant changes to the code base, making cross-pull requests difficult.

Moving forward

Stage 1 - General and Word Document - DONE

1. Migrate to NET 6.0
2. Restructure project into clear features
3. Break up word document super class into SOLID classes
4. Break up PowerTools super classes into common utilities
5. Extract common code where appropriate
6. Implement build pattern for document builder, and clean up process code

Stage 2 - Migrate unit tests to MSTest2 - DONE

Stage 3 - Spreadsheet - PLANNED

1. Break up spreadsheet super classes into SOLID classes
2. Implement build pattern for spreadsheet builder, and clena up process code

Stage 4 - Powerpoint

1. Break up powerpoint super classes into SOLID classes
2. Implement build pattern for spreadsheet builder, and clena up process code

Open-XML-PowerTools

The Open XML PowerTools provides guidance and example code for programming with Open XML Documents (DOCX, XLSX, and PPTX). It is based on, and extends the functionality of the Open XML SDK.

It supports scenarios such as:

• Splitting DOCX/PPTX files into multiple files.
• Combining multiple DOCX/PPTX files into a single file.
• Populating content in template DOCX files with data from XML.
• High-fidelity conversion of DOCX to HTML/CSS.
• High-fidelity conversion of HTML/CSS to DOCX.
• Searching and replacing content in DOCX/PPTX using regular expressions.
• Managing tracked-revisions, including detecting tracked revisions, and accepting tracked revisions.
• Updating Charts in DOCX/PPTX files, including updating cached data, as well as the embedded XLSX.
• Comparing two DOCX files, producing a DOCX with revision tracking markup, and enabling retrieving a list of revisions.
• Retrieving metrics from DOCX files, including the hierarchy of styles used, the languages used, and the fonts used.
• Writing XLSX files using far simpler code than directly writing the markup, including a streaming approach that enables writing XLSX files with millions of rows.
• Extracting data (along with formatting) from spreadsheets.

Copyright (c) Microsoft Corporation 2012-2017 Portions Copyright (c) Eric White Inc 2018-2019

Licensed under the MIT License. See License in the project root for license information.

Open-Xml-PowerTools Content

Erik White put a lot of work into creating content for Powertools, and it's still the best resources around.

There is a lot of content about Open-Xml-PowerTools at the Open-Xml-PowerTools Resource Center at OpenXmlDeveloper.org

See:

• DocumentBuilder Resource Center
• PresentationBuilder Resource Center
• WmlToHtmlConverter Resource Center
• DocumentAssembler Resource Center

Build Instructions

Prerequisites:

• Visual Studio 2022
• Net 6 SDK, Runtime
• ASP.NET Core Runtime

Build

With Visual Studio:

• Open OpenXmlPowerTools2023.sln in Visual Studio
• Rebuild the project
• Build the solution. To validate the build, open the Test Explorer. Click Run All.
• To run an example, set the example as the startup project, and press F5.

With .NET CLI toolchain:

• Run dotnet build OpenXmlPowerTools2023.sln

Change Log

Version 1.0 : October 14, 2023

• Brought in outstanding valid PRs that introduce many fixes and features. See the initial commit for details.
• Migrated to Net 6.0 and Framework 4.8.
• Significant refactor of project structure to make the project easier to maintain moving forward

Previous Project Fork: https://github.com/OpenXmlDev/Open-Xml-PowerTools Version 4.6 : November 16, 2020

• Various small bug fixes

This project has adopted the Microsoft Open Source Code of Conduct. For more information, see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.