OpenXmlForLV 1.0.2

.NET Framework 4.8 
dotnet add package OpenXmlForLV --version 1.0.2
NuGet\Install-Package OpenXmlForLV -Version 1.0.2
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="OpenXmlForLV" Version="1.0.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add OpenXmlForLV --version 1.0.2
#r "nuget: OpenXmlForLV, 1.0.2"
#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 OpenXmlForLV as a Cake Addin
#addin nuget:?package=OpenXmlForLV&version=1.0.2

// Install OpenXmlForLV as a Cake Tool
#tool nuget:?package=OpenXmlForLV&version=1.0.2

OpenXmlForLV

Summary

A simplified version of Excel operation using Microsoft's OpenXML, specifically used for LabVIEW applications which only requires a small set of Excel functionalities to generate some data.

  1. set value to a specified cell, only 4 kinds of data, string, bool, number and date.
  2. create fill info usually with foreground RGB color and background indexed color
  3. create font info
  4. create cell format with specified fill info and font info, also with horizental alignment
  5. set cell format into some cells
  6. best fit the cell's column width

That's all, LabVIEW applications usually require only above functionalities, no need to delete fill, font or cell format.

This library uses OpenDocument DLL, very fast and efficient, higher performance than using Excel Interop.

How to use

Just include OpenXmlForLV.dll in your project of .net type

There is an .net application OpenXmlForLV.WpfApp.exe to show the UI and output of OpenXmlForLV.dll

There is an LabVIEW project ExcelForLV.lvproj to show how to use OpenXmlForLV

how to use in LabVIEW

  1. unzip the zip package under sub folder 'labview' to anywhere
  2. unzip the zip package under sub folder 'assemblies' to C:\Windows (or anywhere if you changed the reference path in LabVIEW VI)
  3. open the VI: ExcelForLVExample.vi and run, study the VI to see how it works

Tricks

define the infrastructure with best matches to those objects in OpenDocument, like

  1. Workbook
    1. WorksheetStyle
      1. CellFormat
      2. Fill
      3. Font
    2. Worksheets
      1. Rows
        1. Cells
      2. Columns

Author

Patrick Gamp

For technique support or business, please call the cell phone ++0086-18603016232, email: patrickgamp@hotmail.com, WeChat id is same to the cell phone number

Published date

October 26, 2023

Product Compatible and additional computed target framework versions.
.NET Framework net48 is compatible.  net481 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.2 389 10/27/2023
1.0.1 189 10/26/2023
1.0.0 209 10/26/2023

Added how to setup in LabVIEW