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

Updated Jan 4, 2019

Reported In


  • LabVIEW Full
  • LabVIEW Professional
  • LabVIEW Report Generation Toolkit


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?


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.