Write an Array of Mixed Data Types to Excel Using the Report Generation Toolkit

Updated Feb 6, 2018

Reported In

Software

  • LabVIEW Full
  • LabVIEW Professional
  • LabVIEW Report Generation Toolkit

Other

Microsoft Office Excel

Issue Details

I have the Report Generation Toolkit and I want to write an array of numeric and string data to Excel. How do I write an array of data to Excel that contains these mixed data types?

Solution

In order to write an array of mixed data types to Microsoft Office Excel, first convert each array to a spreadsheet string using the Array to Spreadsheet String VI and combine the strings into a single array. Then, using the Spreadsheet String to Array VI, create an array of strings which you can use to write to Excel using the Report Generation Toolkit. See the screenshot below as an example:

Additional Information

The example above was created to use Microsoft Office 2007. Due to the dynamic nature of the VIs, it may be required that you replace the Report Generation Toolkit specific VIs to ensure it is compatible with your version of Office. The image is also representative of Report Generation Toolkit for LabVIEW 2011. Previous versions of Report Generation Toolkit VIs may appear differently.

WAS THIS ARTICLE HELPFUL?

Not Helpful