This content is not available in your preferred language.

The content is shown in another available language. Your browser may include features that can help translate the text.

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

Updated Jan 4, 2019

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.

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement may be required, and support options vary by country.