Data From Table is not Exporting Properly to Excel

Updated Apr 24, 2018

Reported In

Software

  • LabVIEW

Issue Details

When I right click on a table and click the option "Export>Export data to Excel" an excel sheet opens with the data, but the data does not export correctly. The second to last column is a date field and the last column is a notes field and for multiple rows the notes field gets overridden with the value in the Date field.

Solution

If cells within the table contain any long strings, there is the potential that those cells are too long to be exported properly using the right click - export to excel functionality.

Instead the Report Generation Toolkit can be used to properly export the entire table to excel, including the cells containing particularly long strings.

Below is basic example of the Export to Excel functionality of the Report Generation Toolkit.

WAS THIS ARTICLE HELPFUL?

Not Helpful