05-30-2012 10:59 AM
Hi Fabi,
You beat me to it! I was just experimenting with the same method. Nice find!
Brian
06-05-2012 08:06 AM
Hello everybody!
Now my program and the excel tool is working quite well. I've got a problem after some time (about 80 loops) and I get an error (see attachment).
Unfortunately the error message is in German, I try to translate the important part:
"Error -2146959355 is failed at the start of the server
in Signalmessung......vi"
It also says that it is an undefined error code.
Can someone help me or is someone having the same error?!
Thank you very much in advance!
Fabi
06-06-2012 10:01 AM - last edited on 07-10-2024 02:55 PM by Content Cleaner
Hi Fabi,
Try the solutions in this KnowledgeBase and let me know the results:
http://digital.ni.com/public.nsf/allkb/1C025F018CB5761686256C56007DD258?OpenDocument
DylanC
09-07-2012 02:42 AM
The vi seems to be suitable for my needs to import tdms into excel without having to save each imported file separately.
Unfortunately i don't have Labview 2011, only Labview 8.6 so that i cannot open the vi.
Is there the possibility to save the vi for a older labview version? I cannot say if your vi contains functions specific to Labview 2011?
Yours
09-10-2012 08:42 AM
Hi Sneff,
Another option that you have is to post it in http://forums.ni.com/t5/Version-Conversion/bd-p/VersionConversion if you need it converted.
Regads,
03-12-2014 03:46 PM
I tried running the VI and each time I receive a mesage box saying that "A file named 'tdms.xlx' already exists, do you want to replace it?' However there is no file with that name. I choose to replace it anyway, and no Excel file is created. Any tips? Thanks!
03-12-2014 04:09 PM
@fliphkd778 wrote:
I tried running the VI and each time I receive a mesage box saying that "A file named 'tdms.xlx' already exists, do you want to replace it?' However there is no file with that name. I choose to replace it anyway, and no Excel file is created. Any tips? Thanks!
Wow. How could no one have called me out in the last 4 years telling me it doesn't work? I have since made many improvements to the import function for added cell coloring, pane freezing and a few other functions, and I assumed this old version worked fine. Turns out it never worked.
The version I posted here has a bug where it tries to replace the file name to have the .xlsx extension, but instead of using the normal file name uses the file name "TDMS".
Attached is the fixed version that should work.
Unofficial Forum Rules and Guidelines
Get going with G! - LabVIEW Wiki.
17 Part Blog on Automotive CAN bus. - Hooovahh - LabVIEW Overlord
03-12-2014 04:31 PM
Hoovahh,
That was wicked fast! Works perfectly now; thanks!
04-28-2014 02:06 PM - last edited on 07-10-2024 02:55 PM by Content Cleaner
Okay I've been meaning to update this for a while. I've cleaned up the code, and added a bunch of new functionality for things like row/column freezing, replacing the summary worksheet, conditional cell formatting, and adjusting column widths. I've uploaded my changes as a document here. Feedback is appreciated.
Unofficial Forum Rules and Guidelines
Get going with G! - LabVIEW Wiki.
17 Part Blog on Automotive CAN bus. - Hooovahh - LabVIEW Overlord
07-10-2014 02:21 AM
Thanks a lot for the .vi! Very useful! I haven't found a way to do it for all the files in the folder. Still have to select files one by one. Any idea on how I could do all files at once?