Shikha Ahirwar Posted March 8, 2016 Report Share Posted March 8, 2016 I am unable to open excel files in labview. can anyone help me out? Quote Link to comment
ned Posted March 8, 2016 Report Share Posted March 8, 2016 Are these Excel files, or delimited text files that you usually open in Excel? What have you already tried in LabVIEW? Show us your code. What will you do with the data in the file after you open it? Quote Link to comment
Shikha Ahirwar Posted March 9, 2016 Author Report Share Posted March 9, 2016 I have tried opening with read spreadsheet function. It was showing random data. Excel files are delimited.After I read the files, I have to use it use in my analysis code. Quote Link to comment
hooovahh Posted March 9, 2016 Report Share Posted March 9, 2016 We still haven't seen any code, we still haven't seen any example Excel files. Quote Link to comment
Jordan Kuehn Posted March 9, 2016 Report Share Posted March 9, 2016 Try re-saving your excel file as a .csv file. Quote Link to comment
Shikha Ahirwar Posted March 10, 2016 Author Report Share Posted March 10, 2016 actually I have a software which export my experiment results to excel files. but do to my analysis labview doesn't reads excel files Quote Link to comment
Jordan Kuehn Posted March 10, 2016 Report Share Posted March 10, 2016 Please respond to the various replies ^. A sample file would go a long way. Quote Link to comment
Rolf Kalbermatter Posted March 11, 2016 Report Share Posted March 11, 2016 actually I have a software which export my experiment results to excel files. but do to my analysis labview doesn't reads excel files Native Excel files are using a proprietary format, either binary (pre Office 2012 or so) or compressed XML. Both formats are not something that is easily read in LabVIEW although there is a Toolkit which can read and write XLS files directly. Another approach is to use ActiveX to interface to Excel and access the files like that. There are several libraries out there which wrap the ActiveX nodes to make it easier, since the ActiveX object hierarchy of MS Offce software is rather involved and not trivial to understand. But in order for this to work you need to have Excel installed on the computer you use such a library. For the rest it really would help to give more info as was asked multiple times in this thread already. It's rather frustrating to see multiple requests for extra info and then seeing that you keep providing further information in piece meal fashion and if you keep doing that the readyness to help you further will quickly diminish also for future requests you may have. If the files are however in tab or comma separated text format then the Read Spreadsheet file function will work perfectly. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.