zbig_k Posted October 1, 2010 Report Share Posted October 1, 2010 Hello Every time I try to "export operands description" to an Excel file I get the message UnOpOpr1 "The Excel file you have selected cannot support the exported values", even if it's a Help/Examples or newly opened project. I tried this on 3 PCs running Windows NT, Windows 7 and Windows XP with the same result, somebody help me please ? Quote Link to comment Share on other sites More sharing options...
R.Mozes Posted October 3, 2010 Report Share Posted October 3, 2010 Hello, Which VisiLogic version are you using? Did you try to export the operand by using VisiLogic V8.6.2 (latest)? If you do, please send your project to support@unitronics.com and we'll try to fix the problem. BR, Reuven Quote Link to comment Share on other sites More sharing options...
MVP 2023 Joe Tauser Posted October 4, 2010 MVP 2023 Report Share Posted October 4, 2010 What are the 8.6.2 version changes over 8.6.1? Joe T. Quote Link to comment Share on other sites More sharing options...
zbig_k Posted October 6, 2010 Author Report Share Posted October 6, 2010 Hello, Which VisiLogic version are you using? Did you try to export the operand by using VisiLogic V8.6.2 (latest)? If you do, please send your project to support@unitronics.com and we'll try to fix the problem. BR, Reuven I've just istalled V8.6.2 version, opened a couple of Example projects and still have the same problem. Regards zbig Quote Link to comment Share on other sites More sharing options...
Phil Salkie Posted October 6, 2010 Report Share Posted October 6, 2010 Using 8.6.2 - If I export a file with the extension ".xls", then I get a properly formatted file containing no operand descriptions at all - this used to work, and now doesn't. If I export a file with the extension ".xlsx" I get the same message as you got - "The Excel file you have selected cannot support the exported values" - I've never actually seen VisiLogic make a proper .xlsx file. I believe this has all been broken for a while, I have just been re-using old export files, modifying them, and then importing to my new projects, so I forgot to report it. It used to be that it was necessary to have Microsoft Excel installed on the machine in order to export or import .xls files, I assume this is still the case. Quote Link to comment Share on other sites More sharing options...
zbig_k Posted October 16, 2010 Author Report Share Posted October 16, 2010 Hello, Which VisiLogic version are you using? Did you try to export the operand by using VisiLogic V8.6.2 (latest)? If you do, please send your project to support@unitronics.com and we'll try to fix the problem. BR, Reuven Hello Reuven I am still looking for an answer to my question. I have a very simple project to do, it is a tank filled with water which is maintained at some temperature during some period of time. The problem is there are 10 of them tanks, so I have to copy the same operands for each one of them, only the number of tank changes. With an Excel file it is simple and fast,. Regards Zbig Quote Link to comment Share on other sites More sharing options...
zbig_k Posted October 16, 2010 Author Report Share Posted October 16, 2010 Using 8.6.2 - If I export a file with the extension ".xls", then I get a properly formatted file containing no operand descriptions at all - this used to work, and now doesn't. If I export a file with the extension ".xlsx" I get the same message as you got - "The Excel file you have selected cannot support the exported values" - I've never actually seen VisiLogic make a proper .xlsx file. I believe this has all been broken for a while, I have just been re-using old export files, modifying them, and then importing to my new projects, so I forgot to report it. It used to be that it was necessary to have Microsoft Excel installed on the machine in order to export or import .xls files, I assume this is still the case. Hello Phil, I have Excel istalled of course but I have only the extension ".xls" available when I try to export the operands, it worked with the old versions of Vision but not anymore. Regards Zbig Quote Link to comment Share on other sites More sharing options...
Emil Posted October 18, 2010 Report Share Posted October 18, 2010 Hi Zbig, We are checking the problem with export ot Excel. Meantime I have a "crazy" idea: You can make a data table with row for each tank. The column properties will be "address of". You will set there theq addresses of the real operands for relevant tank. Then, in Ladder, you wil make a subroutine, which wil lhold "tank logic" - with "temporary operands". You will make a loop - reading real data for relevant tank to "temporary operands" > run the logic to proceed them > write results from temporary operands to relevant tank.Then you will increase the pointer and will go to te next tank. This way with one sub and one DT you will complete your application. Quote Link to comment Share on other sites More sharing options...
kartan Posted May 24, 2012 Report Share Posted May 24, 2012 Is there any chance to get this problem fixed? I'm tired to write same strings many time.. Quote Link to comment Share on other sites More sharing options...
Peter van Hoof Posted May 30, 2012 Report Share Posted May 30, 2012 I believe it has to do with the version of Excel installed, I have Excel 2010 installed with the latest version of Visilogic and it works flawless. Perhaps download a 30 day trial version from Microsoft would help http://office.microsoft.com/en-us/try/ YMMV Peter van Hoof Quote Link to comment Share on other sites More sharing options...
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.
Note: Your post will require moderator approval before it will be visible.