Export Data to Excel in Table Form

[nursyfnz]

Hi, is it possible if I want to export data in table form from NI Vision to Excel?

The current exported data that I got is just values and no table/border created. 

[1100fps]

"Write Delimited Spreadsheet" should do it.   You might have to convert numeric data to text if there are mixed fields.

No borders, just filled cells. although There are a whole series of excel specific VIs that can do much more. 

[nbabajan]

Hi,

How exactly are you exporting the data, and does "no table/border created" mean that all the data is being written in a single cell?

[nursyfnz]

I used "Data Logging" in Vision Builder. Then, I export the data to Excel. The data is written correctly according to its column and row as per below. However, there is no border (line) created.

I want the data to be exported automatically with border (line) as shown below. Please advise.

  

[nbabajan]

Unfortunately, the "Data Log" tool seems to not give such opportunity. Although you can create a LabVIEW VI and try using the "Run LabVIEW VI" tool to programmatically create the borders.

These might be handy

Run LabVIEW VI FAQs ,

Custom Cell Borders in Excel with the Report Generation Toolkit