I use test equipment that stores information in MS Excel. Can I somehow get it to use Calc instead?
The program is UE Systems, DMS program. DMS is a SQL based program, that generates its reports to a spreadsheet.
I’ve contacted UE’s Chief Software/Tech Specialist and he is interested if I can resolve this, but has no knowledge of how to make it work.
Thank you for assistance, Bill
Does your DMS program actually require that MS Excel be installed on the computer (and you want to change that to LO Calc) or does it simply generate its reports in .xls format?
It appears to require it. If there’s thereks an option, I haven’t found it. Currently I only have Calc installed.
This looks like an ancient program as the video shows it running on Windows XP. It’s probably written in VBA or C# and directly calling Excel functions that are only available when Excel is installed on your computer. It also means that other than generating an Excel file on disk and then opening in Libre Office, you are out of luck. If the program is sucking data from the spreadsheet back into he database, you are guaranteed to be out of luck without a total rewrite targeting Libre Office.
“I’ve contacted UE’s Chief Software/Tech Specialist and he is interested if I can resolve this, but has no knowledge of how to make it work.” Not a good sign!
Hello,
Took a quick look at the Create a Report in Excel found here :
Now, according to what I have seen, and don’t really know what database is actually being used, you can output data in .csv format (comma separated) which is easily input into Calc.
Also, and may be incorrect here, it is basically selected data which is exported to Excel or a .csv file. The selected data is determined so as to constitute a report.
Your question is not going to generate much response as this is a specialized situation - using probes and ultrasound equipment. It is also difficult for any non-user to get their hands on the software or specific data for testing. Fortunately there is some info in the on-line videos.
Agree; Probably 3 options:
I will try the suggestions. If anyone is interested, the DMS program is a free download and comes with a sample test route. http://www.uesystems.com/products/software You do have to create an account, but that is simple.
Thanks for the info but it appears this is for Windows and I only use Linux now.
Open calc. File open spreadsheet.
To automatically have the excel file open in calc, you need to set the files association for .XLS to use Calc. You can probably right click on the file and select open with and choose always use this program for this file.
The exact method depends on your windows version. My wording is not precise because I use Linux these days and am not in a windows environment to see the exact process.