OpenXMLOffice.Excel
0.2.2-alpha.6
See the version list below for details.
dotnet add package OpenXMLOffice.Excel --version 0.2.2-alpha.6
NuGet\Install-Package OpenXMLOffice.Excel -Version 0.2.2-alpha.6
<PackageReference Include="OpenXMLOffice.Excel" Version="0.2.2-alpha.6" />
paket add OpenXMLOffice.Excel --version 0.2.2-alpha.6
#r "nuget: OpenXMLOffice.Excel, 0.2.2-alpha.6"
// Install OpenXMLOffice.Excel as a Cake Addin #addin nuget:?package=OpenXMLOffice.Excel&version=0.2.2-alpha.6&prerelease // Install OpenXMLOffice.Excel as a Cake Tool #tool nuget:?package=OpenXMLOffice.Excel&version=0.2.2-alpha.6&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
- OpenXMLOffice.Global (>= 0.2.2-alpha.6)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated | |
---|---|---|---|
1.0.1 | 417 | 3/9/2024 | |
1.0.0 | 315 | 2/29/2024 | |
0.2.9 | 723 | 2/24/2024 | |
0.2.9-alpha.7 | 136 | 2/19/2024 | |
0.2.9-alpha.6 | 69 | 2/19/2024 | |
0.2.9-alpha.5 | 57 | 2/16/2024 | |
0.2.9-alpha.4 | 100 | 2/15/2024 | |
0.2.9-alpha.2 | 66 | 2/2/2024 | |
0.2.9-alpha.1 | 58 | 2/2/2024 | |
0.2.8 | 487 | 2/2/2024 | |
0.2.8-alpha.5 | 49 | 2/2/2024 | |
0.2.8-alpha.4 | 57 | 2/1/2024 | |
0.2.8-alpha.3 | 57 | 1/31/2024 | |
0.2.8-alpha.2 | 60 | 1/27/2024 | |
0.2.8-alpha.1 | 47 | 1/27/2024 | |
0.2.7 | 525 | 1/27/2024 | |
0.2.7-alpha.8 | 58 | 1/25/2024 | |
0.2.7-alpha.7 | 53 | 1/25/2024 | |
0.2.7-alpha.6 | 52 | 1/25/2024 | |
0.2.7-alpha.4 | 51 | 1/25/2024 | |
0.2.7-alpha.3 | 50 | 1/25/2024 | |
0.2.7-alpha.2 | 49 | 1/25/2024 | |
0.2.7-alpha.1 | 54 | 1/24/2024 | |
0.2.6 | 484 | 1/24/2024 | |
0.2.6-alpha.3 | 47 | 1/24/2024 | |
0.2.6-alpha.2 | 47 | 1/24/2024 | |
0.2.6-alpha.1 | 54 | 1/22/2024 | |
0.2.5 | 562 | 1/19/2024 | |
0.2.5-alpha.6 | 54 | 1/19/2024 | |
0.2.5-alpha.5 | 54 | 1/19/2024 | |
0.2.5-alpha.4 | 56 | 1/18/2024 | |
0.2.5-alpha.3 | 54 | 1/18/2024 | |
0.2.5-alpha.2 | 55 | 1/18/2024 | |
0.2.5-alpha.1 | 57 | 1/18/2024 | |
0.2.4 | 549 | 1/17/2024 | |
0.2.4-alpha.1 | 58 | 1/17/2024 | |
0.2.3 | 570 | 1/12/2024 | |
0.2.3-alpha.3 | 59 | 1/11/2024 | |
0.2.3-alpha.2 | 69 | 1/11/2024 | |
0.2.3-alpha.1 | 83 | 1/11/2024 | |
0.2.2 | 553 | 1/11/2024 | |
0.2.2-alpha.6 | 60 | 1/10/2024 | |
0.2.2-alpha.5 | 57 | 1/9/2024 | |
0.2.2-alpha.4 | 62 | 1/9/2024 | |
0.2.2-alpha.3 | 68 | 1/9/2024 | |
0.2.2-alpha.2 | 65 | 1/8/2024 | |
0.2.2-alpha.1 | 66 | 1/8/2024 | |
0.2.1 | 652 | 1/7/2024 | |
0.2.1-alpha.7 | 70 | 1/7/2024 | |
0.2.1-alpha.6 | 82 | 1/6/2024 | |
0.2.1-alpha.5 | 71 | 1/6/2024 | |
0.2.1-alpha.4 | 71 | 1/4/2024 | |
0.2.1-alpha.3 | 71 | 1/3/2024 | |
0.2.1-alpha.1 | 67 | 1/2/2024 | |
0.2.1-alpha | 584 | 1/2/2024 | |
0.2.0 | 614 | 1/2/2024 | |
0.2.0-alpha.2 | 72 | 1/2/2024 | |
0.2.0-alpha.1 | 77 | 1/2/2024 | |
0.2.0-alpha | 631 | 1/2/2024 | |
0.1.1 | 608 | 1/2/2024 | |
0.1.0 | 658 | 1/1/2024 | |
0.0.11 | 623 | 12/31/2023 | |
0.0.10 | 669 | 12/29/2023 | |
0.0.9 | 620 | 12/28/2023 | |
0.0.8 | 645 | 12/28/2023 | |
0.0.7 | 689 | 12/13/2023 | |
0.0.6 | 714 | 12/11/2023 | |
0.0.5-alpha | 660 | 12/11/2023 | |
0.0.4-alpha | 671 | 12/9/2023 | |
0.0.3-alpha | 728 | 11/29/2023 | |
0.0.2 | 716 | 11/28/2023 | |
0.0.2-alpha | 734 | 11/29/2023 | |
0.0.1 | 567 | 11/27/2023 |