OpenXMLOffice.Excel 0.2.2-alpha.5

This is a prerelease version of OpenXMLOffice.Excel.
There is a newer version of this package available.
See the version list below for details.
dotnet add package OpenXMLOffice.Excel --version 0.2.2-alpha.5                
NuGet\Install-Package OpenXMLOffice.Excel -Version 0.2.2-alpha.5                
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.Excel" Version="0.2.2-alpha.5" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add OpenXMLOffice.Excel --version 0.2.2-alpha.5                
#r "nuget: OpenXMLOffice.Excel, 0.2.2-alpha.5"                
#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.Excel as a Cake Addin
#addin nuget:?package=OpenXMLOffice.Excel&version=0.2.2-alpha.5&prerelease

// Install OpenXMLOffice.Excel as a Cake Tool
#tool nuget:?package=OpenXMLOffice.Excel&version=0.2.2-alpha.5&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

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 431 3/9/2024 1.0.1 is deprecated because it is no longer maintained.
1.0.0 319 2/29/2024
0.2.9 979 2/24/2024
0.2.9-alpha.7 138 2/19/2024
0.2.9-alpha.6 71 2/19/2024
0.2.9-alpha.5 58 2/16/2024
0.2.9-alpha.4 104 2/15/2024
0.2.9-alpha.2 68 2/2/2024
0.2.9-alpha.1 60 2/2/2024
0.2.8 491 2/2/2024
0.2.8-alpha.5 55 2/2/2024
0.2.8-alpha.4 60 2/1/2024
0.2.8-alpha.3 59 1/31/2024
0.2.8-alpha.2 64 1/27/2024
0.2.8-alpha.1 51 1/27/2024
0.2.7 527 1/27/2024
0.2.7-alpha.8 60 1/25/2024
0.2.7-alpha.7 55 1/25/2024
0.2.7-alpha.6 54 1/25/2024
0.2.7-alpha.4 55 1/25/2024
0.2.7-alpha.3 53 1/25/2024
0.2.7-alpha.2 51 1/25/2024
0.2.7-alpha.1 57 1/24/2024
0.2.6 486 1/24/2024
0.2.6-alpha.3 51 1/24/2024
0.2.6-alpha.2 49 1/24/2024
0.2.6-alpha.1 58 1/22/2024
0.2.5 564 1/19/2024
0.2.5-alpha.6 59 1/19/2024
0.2.5-alpha.5 56 1/19/2024
0.2.5-alpha.4 58 1/18/2024
0.2.5-alpha.3 55 1/18/2024
0.2.5-alpha.2 57 1/18/2024
0.2.5-alpha.1 58 1/18/2024
0.2.4 551 1/17/2024
0.2.4-alpha.1 62 1/17/2024
0.2.3 572 1/12/2024
0.2.3-alpha.3 60 1/11/2024
0.2.3-alpha.2 70 1/11/2024
0.2.3-alpha.1 84 1/11/2024
0.2.2 554 1/11/2024
0.2.2-alpha.6 62 1/10/2024
0.2.2-alpha.5 59 1/9/2024
0.2.2-alpha.4 65 1/9/2024
0.2.2-alpha.3 71 1/9/2024
0.2.2-alpha.2 67 1/8/2024
0.2.2-alpha.1 68 1/8/2024
0.2.1 654 1/7/2024
0.2.1-alpha.7 76 1/7/2024
0.2.1-alpha.6 86 1/6/2024
0.2.1-alpha.5 74 1/6/2024
0.2.1-alpha.4 72 1/4/2024
0.2.1-alpha.3 73 1/3/2024
0.2.1-alpha.1 70 1/2/2024
0.2.1-alpha 585 1/2/2024
0.2.0 616 1/2/2024
0.2.0-alpha.2 73 1/2/2024
0.2.0-alpha.1 78 1/2/2024
0.2.0-alpha 632 1/2/2024
0.1.1 626 1/2/2024
0.1.0 664 1/1/2024
0.0.11 625 12/31/2023
0.0.10 671 12/29/2023
0.0.9 622 12/28/2023
0.0.8 647 12/28/2023
0.0.7 691 12/13/2023
0.0.6 726 12/11/2023
0.0.5-alpha 662 12/11/2023
0.0.4-alpha 673 12/9/2023
0.0.3-alpha 730 11/29/2023
0.0.2 719 11/28/2023 0.0.2 is deprecated because it is no longer maintained and has critical bugs.
0.0.2-alpha 736 11/29/2023 0.0.2-alpha is deprecated because it is no longer maintained and has critical bugs.
0.0.1 569 11/27/2023 0.0.1 is deprecated because it is no longer maintained and has critical bugs.