Ecosyste.ms: Packages
An open API service providing package, version and dependency metadata of many open source software ecosystems and registries.
nuget.org : openxmlforlv
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: [email protected], WeChat id is same to the cell phone number Published date October 26, 2023
Registry
- Homepage
- JSON
purl: pkg:nuget/openxmlforlv
Keywords: OpenXML, Excel, LabVIEW
License: MIT
Latest release: 7 months ago
First release: 7 months ago
Downloads: 776 total
Last synced: 21 days ago