LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

TDMS files to XLSX within a cRIO program

the program i use at work produces 30-40 tdms files per operation of the machine. is there a way to automatically convert the TDMS file to a xlsx format, to save me having to do it manually, i have been trying but haven't found a way to do it yet 

0 Kudos
Message 1 of 4
(228 Views)

Hi Sam,

 


@Kool.Kid.Sam wrote:

the program i use at work produces 30-40 tdms files per operation of the machine.

is there a way to automatically convert the TDMS file to a xlsx format, to save me having to do it manually, i have been trying but haven't found a way to do it yet 


Maybe it would help to convert all your TDMS files into just one TDMS file…

Then you only need to convert one TDMS to XLSX.

 

Why do you need XLSX?

Do your TDMS files fit into the limitations of a XLSX file?

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 2 of 4
(222 Views)

TDMS to XLSX Conversion

 

However, TDM Excel Add-In for Microsoft Excel is not supported on Linux so you still have to transfer the files to the host PC for conversion. You might be able to do file transfer programmatically via FTP or WebDAV.

-------------------------------------------------------
Control Lead | Intelline Inc
0 Kudos
Message 3 of 4
(216 Views)

Yes I'd also suggest just logging to TDMS on the controller, then have a host application that pulls in the files and converts them.  There are ways to make XLSX files on the controller directly but it is a bit of a pain and uses a 3rd party tool XLR8 which I haven't seen get new updates in a while.

0 Kudos
Message 4 of 4
(161 Views)