LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

read from spreadsheet file no error in/out ???

Hello All,

Does anybody know of a good reason why the read/write spreadsheet file VIs do not have error in/out? (the only version I can check this on at the moment is LV 8.5).

I suppose the underlying question is why does the "read lines from file.vi" which is a subvi of the "read spreadsheet" not have error in/out. Instead it has a hard coded GUI based general error handler, which seems a terrible way to deal with any errors?

Odd...
0 Kudos
Message 1 of 4
(3,459 Views)
Both of these functions are very, very old and I suspect the reason they have never been changed would be that modifying the connector pane to accommodate error in/out connections would break a lot of older programs. I usually make my own version with error handling and get rid of the general error handler as well. It wasn't until 8.2 that the Write/Read Spreadsheet functions could handle anything other than SGL and one of the first things I did when a new version came out was to update my own polymorphic VI.
Message 2 of 4
(3,439 Views)
Thanks Dennis, I thought that may be the case. Seems odd though that the end user would have to make new functions instead of new ones being included in the palette.
0 Kudos
Message 3 of 4
(3,427 Views)

I came here with a google search, so I post a solution.

 

Instead of not wiring "file path, dialog if empty",

wire the "file dialog" to it.

 

It has error out, booleans for "canceled", "exists" etc.

Then place the read from spreadsheet in a case.

Message 4 of 4
(3,122 Views)