OpenXMLOffice.Global 0.2.2-alpha.6

.NET 7.0 This package targets .NET 7.0. The package is compatible with this framework or higher.
This is a prerelease version of OpenXMLOffice.Global.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package OpenXMLOffice.Global --version 0.2.2-alpha.6
NuGet\Install-Package OpenXMLOffice.Global -Version 0.2.2-alpha.6
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="OpenXMLOffice.Global" Version="0.2.2-alpha.6" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add OpenXMLOffice.Global --version 0.2.2-alpha.6
#r "nuget: OpenXMLOffice.Global, 0.2.2-alpha.6"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install OpenXMLOffice.Global as a Cake Addin
#addin nuget:?package=OpenXMLOffice.Global&version=0.2.2-alpha.6&prerelease

// Install OpenXMLOffice.Global as a Cake Tool
#tool nuget:?package=OpenXMLOffice.Global&version=0.2.2-alpha.6&prerelease

Status

Codacy Badge Downloads

OpenXMLOffice

OpenXMLOffice is an advanced .NET library that leverages the power of OpenXML SDK 3.0 to streamline the creation and manipulation of Office documents, with a primary focus on Excel, Word, and PowerPoint files. Our mission is to enhance the document creation experience for developers by providing intuitive namespaces, classes, and utilities. The library is designed to offer maximum efficiency and ease of use, ensuring a seamless workflow. Please note that a minimum Microsoft Office support version of 2013 is required for optimal compatibility.

Scope Details

  • Easy Creation of Office Documents: Create and manipulate Excel, Word, and PowerPoint files with ease.
  • OpenXML SDK 3.0: Built on the robust foundation of the OpenXML SDK.
  • Modular Architecture: Dedicated modules for each Office application for better manageability.

The library is available on NuGet. You can install it using the following command:

Install-Package OpenXMLOffice

dotnet add package OpenXMLOffice.Presentation

Package Details

The official release NuGet packages for OpenXMLOffice on NuGet.org:

Package Dev Status Download Prerelease
OpenXMLOffice.Presentation Active NuGet NuGet
OpenXMLOffice.Excel Active NuGet NuGet
OpenXMLOffice.Document Not Active NuGet NuGet

All project documentation is completed and regularly updated in Gitbooks. The maintained branch for documentation is the "Documents" branch within the project repository. We welcome any contributions or updates through pull requests. Your assistance is highly appreciated.

Active Features In Different DLL

OpenXMLOffice.Presentation

Control Description
Slide Allows addition of blank slides, removal of slides based on index, and rearrangement of slide positions.
Shape Enables the location and replacement of shapes by text. Facilitates size and position updates within a slide.
Table Adds and replaces existing charts. Future plans include finding and updating existing charts. Currently supports creating and updating tables, inheriting all shape functionality.
TextBox Updates or replaces existing shape text content. Adds new text boxes based on slide control with inherited options from shapes.
Picture Adds images in PNG, JPG, BMP, TIFF formats to slides. Supports replacement in existing shapes or creation of new controls within a slide.
Chart Allows users to add charts based on slide control, directly insert them, or replace existing shape controls. Supports major and sub-chart types such as column, line, pie, bar, area, and scatter. Can update the data excel from control

For charts, the following types are supported:

  • Column Chart:

    • Cluster
    • Stacked
    • 100% Stacked

  • Line Chart:

    • Cluster
    • Stacked
    • 100% Stacked
    • Cluster Marker
    • Stacked Marker
    • 100% Stacked Marker

  • Pie Chart:

    • Pie
    • Doughnut

  • Bar Chart:

    • Cluster
    • Stacked
    • 100% Stacked

  • Area Chart:

    • Cluster
    • Stacked
    • 100% Stacked

  • X Y (Scatter) Chart:

    • Scatter
    • Scatter Smooth Line Marker
    • Scatter Smooth Line
    • Scatter Line Marker
    • Scatter Line
    • Bubble

OpenXMLOffice.Excel

Control Description
Spreadsheet Enables manipulation of worksheets, including retrieval, addition, removal, and renaming of sheets.
Worksheet Facilitates manipulation of cell data, row properties (e.g., height), column properties (e.g., width), and cell data formatting.

Future Plans:

  • Styling:

    • Future releases will introduce styling options for enhanced visual representation.

  • Shared String Data Loading:

    • Planned for memory optimization, shared string data loading will be implemented in upcoming releases.

Important Note:

  • It is advised to avoid using the library for the creation of large, repeated data files at this point.

Version History

  • v0.1.0: Cover Spreadsheet data loading and saving.
  • v0.2.0: Power Point Exisitng File Shape Based Manipulation of Tables, Text, Charts (Primary)
  • Follow project roadmap to get upto date info Link

License

This project is licensed under the MIT License - see the LICENSE file for details.

Contributing

Contributions are what make the open source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.

If you have a suggestion that would make this better, please fork the repo and create a pull request. You can also simply open an issue with the tag "enhancement". Don't forget to give the project a star! Thanks again!

  1. Fork the Project
  2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
  3. Commit your Changes (git commit -m 'Add some AmazingFeature')
  4. Push to the Branch (git push origin feature/AmazingFeature)
  5. Open a Pull Request

Please ensure you follow our PR and issue templates for quicker resolution.

Support

Your feedback and support are important. Feel free to reach out to us with any questions or suggestions.

Product Compatible and additional computed target framework versions.
.NET net7.0 is compatible.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (3)

Showing the top 3 NuGet packages that depend on OpenXMLOffice.Global:

Package Downloads
OpenXMLOffice.Excel

OpenXML Excel Integrator is a robust .NET library tailored for managing and manipulating Excel files using the OpenXML SDK. This toolkit simplifies complex tasks such as creating spreadsheets, formatting cells, and inserting formulas, charts, and pivot tables. Ideal for applications involving data analysis, report generation, and financial data processing, it allows developers to programmatically control every aspect of Excel file creation and editing. From automated report generation to data-driven spreadsheet creation, the OpenXML Excel Integrator offers a streamlined approach to handle Excel documents efficiently and accurately, enhancing your application's data management capabilities.
OpenXMLOffice.Presentation

OpenXML PowerPoint Builder is a comprehensive .NET library designed to simplify the creation of PowerPoint presentations using the OpenXML SDK. This library provides an intuitive and powerful set of helper methods and classes, enabling developers to construct slides, manipulate shapes, insert text, images, charts, and more, with minimal effort. Whether you're generating reports, automating presentation creation, or building dynamic slideshows, OpenXML PowerPoint Builder streamlines the process, making it more efficient and less error-prone. Perfect for applications requiring on-the-fly PowerPoint document generation or manipulation. Get started with ease and enhance your application's document handling capabilities.
OpenXMLOffice.Spreadsheet

OpenXML Excel Integrator is a robust .NET library tailored for managing and manipulating Excel files using the OpenXML SDK. This toolkit simplifies complex tasks such as creating spreadsheets, formatting cells, and inserting formulas, charts, and pivot tables. Ideal for applications involving data analysis, report generation, and financial data processing, it allows developers to programmatically control every aspect of Excel file creation and editing. From automated report generation to data-driven spreadsheet creation, the OpenXML Excel Integrator offers a streamlined approach to handle Excel documents efficiently and accurately, enhancing your application's data management capabilities.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
2.7.0-Alpha.28 8 5/17/2024
2.7.0-Alpha.27 35 5/16/2024
2.7.0-Alpha.26 39 5/16/2024
2.7.0-Alpha.25 33 5/16/2024
2.7.0-Alpha.24 33 5/15/2024
2.7.0-Alpha.23 34 5/15/2024
2.7.0-Alpha.22 41 5/15/2024
2.7.0-Alpha.21 37 5/15/2024
2.7.0-Alpha.20 25 5/15/2024
2.7.0-Alpha.19 23 5/15/2024
2.7.0-Alpha.18 40 5/14/2024
2.7.0-Alpha.17 37 5/14/2024
2.7.0-Alpha.15 36 5/14/2024
2.7.0-Alpha.14 30 5/14/2024
2.7.0-Alpha.13 33 5/13/2024
2.7.0-Alpha.12 36 5/12/2024
2.7.0-Alpha.11 39 5/10/2024
2.7.0-Alpha.10 39 5/10/2024
2.7.0-Alpha.9 59 5/7/2024
2.7.0-Alpha.8 44 5/7/2024
2.7.0-Alpha.7 42 5/6/2024
2.7.0-Alpha.6 48 5/5/2024
2.7.0-Alpha.5 51 5/5/2024
2.7.0-Alpha.4 6 5/3/2024
2.7.0-Alpha.2 50 4/24/2024
2.7.0-Alpha.1 43 4/22/2024
2.6.23 148 4/20/2024
2.6.21 133 4/20/2024
2.6.20 132 4/19/2024
2.6.19 128 4/19/2024
2.6.18 121 4/18/2024
2.6.17 155 4/17/2024
2.6.16 146 4/17/2024
2.6.15 143 4/17/2024
2.6.14 137 4/17/2024
2.6.13 120 4/17/2024
2.6.12 128 4/17/2024
2.6.10 129 4/17/2024
2.6.9 126 4/17/2024
2.6.7 141 4/16/2024
2.6.6-Alpha 101 4/16/2024
2.6.5-Alpha 101 4/16/2024
2.6.4-Alpha 102 4/15/2024
2.6.3-Alpha 101 4/15/2024
2.6.2-Alpha 133 4/15/2024
2.6.1-Alpha 124 4/15/2024
2.6.0-Alpha 93 4/15/2024
2.5.0-Alpha 58 4/15/2024
2.4.0-Alpha 92 4/13/2024
2.3.2-Alpha 62 4/13/2024
2.3.0-Alpha 92 4/7/2024
2.1.8-Alpha 79 4/5/2024
2.1.7-Alpha 76 4/4/2024
2.1.6-Alpha 81 4/4/2024
2.1.5-Alpha 76 4/4/2024
2.1.4-Alpha 75 4/3/2024
2.1.3-Alpha 82 4/2/2024
2.1.2-Alpha 81 4/2/2024
2.1.1-Alpha 84 4/1/2024
2.0.1-Alpha 85 3/30/2024
1.0.1 178 3/9/2024
1.0.0 194 2/29/2024
0.2.9 335 2/24/2024
0.2.9-alpha.7 98 2/19/2024
0.2.9-alpha.6 50 2/19/2024
0.2.9-alpha.5 52 2/16/2024
0.2.9-alpha.4 51 2/15/2024
0.2.9-alpha.2 62 2/2/2024
0.2.9-alpha.1 45 2/2/2024
0.2.8 290 2/2/2024
0.2.8-alpha.5 47 2/2/2024
0.2.8-alpha.4 52 2/1/2024
0.2.8-alpha.3 54 1/31/2024
0.2.8-alpha.2 56 1/27/2024
0.2.8-alpha.1 41 1/27/2024
0.2.7 297 1/27/2024
0.2.7-alpha.8 49 1/25/2024
0.2.7-alpha.7 45 1/25/2024
0.2.7-alpha.6 44 1/25/2024
0.2.7-alpha.4 42 1/25/2024
0.2.7-alpha.3 43 1/25/2024
0.2.7-alpha.2 46 1/25/2024
0.2.7-alpha.1 51 1/24/2024
0.2.6 275 1/24/2024
0.2.6-alpha.3 40 1/24/2024
0.2.6-alpha.2 40 1/24/2024
0.2.6-alpha.1 50 1/22/2024
0.2.5 309 1/19/2024
0.2.5-alpha.6 47 1/19/2024
0.2.5-alpha.5 47 1/19/2024
0.2.5-alpha.4 44 1/18/2024
0.2.5-alpha.3 46 1/18/2024
0.2.5-alpha.2 45 1/18/2024
0.2.5-alpha.1 47 1/18/2024
0.2.4 307 1/17/2024
0.2.4-alpha.1 49 1/17/2024
0.2.3 324 1/12/2024
0.2.3-alpha.3 48 1/11/2024
0.2.3-alpha.2 62 1/11/2024
0.2.3-alpha.1 68 1/11/2024
0.2.2 329 1/11/2024
0.2.2-alpha.6 55 1/10/2024
0.2.2-alpha.5 48 1/9/2024
0.2.2-alpha.4 52 1/9/2024
0.2.2-alpha.3 62 1/9/2024
0.2.2-alpha.2 57 1/8/2024
0.2.2-alpha.1 56 1/8/2024
0.2.1 363 1/7/2024
0.2.1-alpha.7 65 1/7/2024
0.2.1-alpha.6 70 1/6/2024
0.2.1-alpha.5 66 1/6/2024
0.2.1-alpha.4 57 1/4/2024
0.2.1-alpha.3 69 1/3/2024
0.2.0 346 1/2/2024