OpenXMLOffice.Global
0.2.2-alpha.3
See the version list below for details.
dotnet add package OpenXMLOffice.Global --version 0.2.2-alpha.3
NuGet\Install-Package OpenXMLOffice.Global -Version 0.2.2-alpha.3
<PackageReference Include="OpenXMLOffice.Global" Version="0.2.2-alpha.3" />
paket add OpenXMLOffice.Global --version 0.2.2-alpha.3
#r "nuget: OpenXMLOffice.Global, 0.2.2-alpha.3"
// Install OpenXMLOffice.Global as a Cake Addin #addin nuget:?package=OpenXMLOffice.Global&version=0.2.2-alpha.3&prerelease // Install OpenXMLOffice.Global as a Cake Tool #tool nuget:?package=OpenXMLOffice.Global&version=0.2.2-alpha.3&prerelease
Status
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.
Getting Started Link
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 | ||
OpenXMLOffice.Excel | Active | ||
OpenXMLOffice.Document | Not Active |
Documentation Link
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!
- Fork the Project
- Create your Feature Branch (git checkout -b feature/AmazingFeature)
- Commit your Changes (git commit -m 'Add some AmazingFeature')
- Push to the Branch (git push origin feature/AmazingFeature)
- 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 | Versions 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. |
-
net7.0
- DocumentFormat.OpenXml (>= 3.0.0)
- DocumentFormat.OpenXml.Linq (>= 3.0.0)
- LiteDB (>= 5.0.17)
NuGet packages (4)
Showing the top 4 NuGet packages that depend on OpenXMLOffice.Global:
Package | Downloads |
---|---|
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.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.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. |
|
OpenXMLOffice.Document
OpenXML Word Processor is a versatile .NET library that streamlines the creation and manipulation of Word documents using the OpenXML SDK. Designed for ease of use, it offers developers an extensive range of features for generating text, applying styles and formatting, creating tables, and managing images. Whether you're automating document creation, generating dynamic reports, or processing large volumes of text, this library provides the tools needed for precise and efficient Word document handling. Embrace the power of programmatic document creation with OpenXML Word Processor, and elevate your application's document processing functionality. |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
3.0.0-Alpha.19 | 82 | 9/18/2024 |
3.0.0-Alpha.18 | 42 | 9/18/2024 |
3.0.0-Alpha.17 | 44 | 9/10/2024 |
3.0.0-Alpha.16 | 36 | 9/8/2024 |
3.0.0-Alpha.15 | 30 | 9/8/2024 |
3.0.0-Alpha.14 | 26 | 9/8/2024 |
3.0.0-Alpha.13 | 38 | 9/5/2024 |
3.0.0-Alpha.12 | 41 | 9/5/2024 |
3.0.0-Alpha.11 | 32 | 9/4/2024 |
3.0.0-Alpha.10 | 37 | 9/3/2024 |
3.0.0-Alpha.9 | 40 | 9/3/2024 |
3.0.0-Alpha.8 | 33 | 9/3/2024 |
3.0.0-Alpha.7 | 34 | 9/3/2024 |
3.0.0-Alpha.6 | 34 | 9/3/2024 |
3.0.0-Alpha.5 | 37 | 9/3/2024 |
3.0.0-Alpha.4 | 23 | 9/3/2024 |
3.0.0-Alpha.3 | 35 | 9/3/2024 |
3.0.0-Alpha.2 | 38 | 9/3/2024 |
3.0.0-Alpha.1 | 35 | 9/3/2024 |
2.9.0 | 294 | 8/26/2024 |
2.9.0-Alpha.5 | 59 | 8/25/2024 |
2.9.0-Alpha.4 | 56 | 8/25/2024 |
2.9.0-Alpha.3 | 57 | 8/25/2024 |
2.9.0-Alpha.1 | 59 | 8/24/2024 |
2.8.0 | 227 | 8/22/2024 |
2.8.0-Alpha.13 | 137 | 8/14/2024 |
2.8.0-Alpha.12 | 51 | 8/10/2024 |
2.8.0-Alpha.11 | 54 | 8/9/2024 |
2.8.0-Alpha.10 | 33 | 8/5/2024 |
2.8.0-Alpha.9 | 39 | 8/1/2024 |
2.8.0-Alpha.8 | 38 | 8/1/2024 |
2.8.0-Alpha.7 | 28 | 7/31/2024 |
2.8.0-Alpha.6 | 37 | 7/30/2024 |
2.8.0-Alpha.5 | 27 | 7/29/2024 |
2.8.0-Alpha.4 | 47 | 7/9/2024 |
2.8.0-Alpha.3 | 76 | 6/27/2024 |
2.8.0-Alpha.2 | 71 | 6/12/2024 |
2.8.0-Alpha.1 | 56 | 6/5/2024 |
2.7.6 | 234 | 6/4/2024 |
2.7.5 | 162 | 6/1/2024 |
2.7.3 | 168 | 5/28/2024 |
2.7.2 | 161 | 5/28/2024 |
2.7.1 | 159 | 5/28/2024 |
2.7.0 | 176 | 5/26/2024 |
2.7.0-Alpha.28 | 62 | 5/17/2024 |
2.7.0-Alpha.27 | 51 | 5/16/2024 |
2.7.0-Alpha.26 | 56 | 5/16/2024 |
2.7.0-Alpha.25 | 46 | 5/16/2024 |
2.7.0-Alpha.24 | 46 | 5/15/2024 |
2.7.0-Alpha.23 | 48 | 5/15/2024 |
2.7.0-Alpha.22 | 57 | 5/15/2024 |
2.7.0-Alpha.21 | 51 | 5/15/2024 |
2.7.0-Alpha.20 | 39 | 5/15/2024 |
2.7.0-Alpha.19 | 37 | 5/15/2024 |
2.7.0-Alpha.18 | 53 | 5/14/2024 |
2.7.0-Alpha.17 | 49 | 5/14/2024 |
2.7.0-Alpha.15 | 49 | 5/14/2024 |
2.7.0-Alpha.14 | 42 | 5/14/2024 |
2.7.0-Alpha.13 | 45 | 5/13/2024 |
2.7.0-Alpha.12 | 47 | 5/12/2024 |
2.7.0-Alpha.11 | 50 | 5/10/2024 |
2.7.0-Alpha.10 | 50 | 5/10/2024 |
2.7.0-Alpha.9 | 90 | 5/7/2024 |
2.7.0-Alpha.8 | 55 | 5/7/2024 |
2.7.0-Alpha.7 | 59 | 5/6/2024 |
2.7.0-Alpha.6 | 62 | 5/5/2024 |
2.7.0-Alpha.5 | 70 | 5/5/2024 |
2.7.0-Alpha.4 | 18 | 5/3/2024 |
2.7.0-Alpha.2 | 59 | 4/24/2024 |
2.7.0-Alpha.1 | 49 | 4/22/2024 |
2.6.23 | 224 | 4/20/2024 |
2.6.21 | 191 | 4/20/2024 |
2.6.20 | 187 | 4/19/2024 |
2.6.19 | 185 | 4/19/2024 |
2.6.18 | 180 | 4/18/2024 |
2.6.17 | 205 | 4/17/2024 |
2.6.16 | 206 | 4/17/2024 |
2.6.15 | 191 | 4/17/2024 |
2.6.14 | 183 | 4/17/2024 |
2.6.13 | 196 | 4/17/2024 |
2.6.12 | 189 | 4/17/2024 |
2.6.10 | 198 | 4/17/2024 |
2.6.9 | 182 | 4/17/2024 |
2.6.7 | 207 | 4/16/2024 |
2.6.6-Alpha | 149 | 4/16/2024 |
2.6.5-Alpha | 161 | 4/16/2024 |
2.6.4-Alpha | 170 | 4/15/2024 |
2.6.3-Alpha | 162 | 4/15/2024 |
2.6.2-Alpha | 188 | 4/15/2024 |
2.6.1-Alpha | 181 | 4/15/2024 |
2.6.0-Alpha | 142 | 4/15/2024 |
2.5.0-Alpha | 96 | 4/15/2024 |
2.4.0-Alpha | 142 | 4/13/2024 |
2.3.2-Alpha | 104 | 4/13/2024 |
2.3.0-Alpha | 141 | 4/7/2024 |
2.1.8-Alpha | 130 | 4/5/2024 |
2.1.7-Alpha | 125 | 4/4/2024 |
2.1.6-Alpha | 123 | 4/4/2024 |
2.1.5-Alpha | 117 | 4/4/2024 |
2.1.4-Alpha | 122 | 4/3/2024 |
2.1.3-Alpha | 124 | 4/2/2024 |
2.1.2-Alpha | 124 | 4/2/2024 |
2.1.1-Alpha | 119 | 4/1/2024 |
2.0.1-Alpha | 127 | 3/30/2024 |
1.0.1 | 249 | 3/9/2024 |
1.0.0 | 234 | 2/29/2024 |
0.2.9 | 630 | 2/24/2024 |
0.2.9-alpha.7 | 125 | 2/19/2024 |
0.2.9-alpha.6 | 57 | 2/19/2024 |
0.2.9-alpha.5 | 60 | 2/16/2024 |
0.2.9-alpha.4 | 59 | 2/15/2024 |
0.2.9-alpha.2 | 72 | 2/2/2024 |
0.2.9-alpha.1 | 57 | 2/2/2024 |
0.2.8 | 338 | 2/2/2024 |
0.2.8-alpha.5 | 54 | 2/2/2024 |
0.2.8-alpha.4 | 61 | 2/1/2024 |
0.2.8-alpha.3 | 62 | 1/31/2024 |
0.2.8-alpha.2 | 62 | 1/27/2024 |
0.2.8-alpha.1 | 54 | 1/27/2024 |
0.2.7 | 336 | 1/27/2024 |
0.2.7-alpha.8 | 65 | 1/25/2024 |
0.2.7-alpha.7 | 55 | 1/25/2024 |
0.2.7-alpha.6 | 51 | 1/25/2024 |
0.2.7-alpha.4 | 48 | 1/25/2024 |
0.2.7-alpha.3 | 51 | 1/25/2024 |
0.2.7-alpha.2 | 57 | 1/25/2024 |
0.2.7-alpha.1 | 60 | 1/24/2024 |
0.2.6 | 314 | 1/24/2024 |
0.2.6-alpha.3 | 48 | 1/24/2024 |
0.2.6-alpha.2 | 49 | 1/24/2024 |
0.2.6-alpha.1 | 60 | 1/22/2024 |
0.2.5 | 348 | 1/19/2024 |
0.2.5-alpha.6 | 54 | 1/19/2024 |
0.2.5-alpha.5 | 58 | 1/19/2024 |
0.2.5-alpha.4 | 52 | 1/18/2024 |
0.2.5-alpha.3 | 53 | 1/18/2024 |
0.2.5-alpha.2 | 53 | 1/18/2024 |
0.2.5-alpha.1 | 56 | 1/18/2024 |
0.2.4 | 341 | 1/17/2024 |
0.2.4-alpha.1 | 58 | 1/17/2024 |
0.2.3 | 349 | 1/12/2024 |
0.2.3-alpha.3 | 56 | 1/11/2024 |
0.2.3-alpha.2 | 70 | 1/11/2024 |
0.2.3-alpha.1 | 77 | 1/11/2024 |
0.2.2 | 362 | 1/11/2024 |
0.2.2-alpha.6 | 61 | 1/10/2024 |
0.2.2-alpha.5 | 55 | 1/9/2024 |
0.2.2-alpha.4 | 68 | 1/9/2024 |
0.2.2-alpha.3 | 73 | 1/9/2024 |
0.2.2-alpha.2 | 63 | 1/8/2024 |
0.2.2-alpha.1 | 62 | 1/8/2024 |
0.2.1 | 396 | 1/7/2024 |
0.2.1-alpha.7 | 73 | 1/7/2024 |
0.2.1-alpha.6 | 79 | 1/6/2024 |
0.2.1-alpha.5 | 73 | 1/6/2024 |
0.2.1-alpha.4 | 66 | 1/4/2024 |
0.2.1-alpha.3 | 77 | 1/3/2024 |
0.2.0 | 371 | 1/2/2024 |