Aptech Systems, Inc. Worldwide Headquarters
Aptech Systems, Inc.
2350 East Germann Road, Suite #21
Chandler, AZ 85286
Ready to Get Started?
Request Quote & Product Information
Training & Events
Step-by-step, informative lessons for those who want to dive into GAUSS and achieve their goals, fast.
Have a Specific Question?
Q&A: Register and Login
Premier Support and Platinum Premier Support are annually renewable membership programs that provide you with important benefits including technical support, product maintenance, and substantial cost-saving features for your GAUSS System or the GAUSS Engine.
Join our community to see why our users are considered some of the most active and helpful in the industry!
Where to Buy
Recent Tagsapplications character vectors CML CMLMT Constrained Optimization datasets dates dlibrary dllcall error error handling errors Excel FANPACMT file i/o floating network GAUSS Engine graphics GUI hotkeys installation Java API license licensing linux loading data matrices matrix matrix manipulation Maxlik MaxLikMT Memory optimization Optmum output PQG graphics procs RAM random numbers string functions strings structures threading Time Series writing data
Time Series 2.0 MT
Find out more now
Time Series MT 2.1
Error when trying to export matrix to excel: Could not access specified range in file
I am using Gauss 14 and attempting to export a large matrix to excel using the following:
vls = reshape(error(0),9,1);
ret = xlsWrite(results, "a.xlsx", "A1", 1, vls);
where results is a matrix approximately 570000x6. I keep getting the error message "Could not access specified range in file: a.xlsx" Could someone please tell me how to fix this problem? Thanks
It may be that the standard COM interface between GAUSS and Excel on Windows cannot handle 570,000 rows. GAUSS 13 and newer also comes with the capability to read and write XLS and XLSX files directly. This method can write that many rows.
To turn off the COM interface and have GAUSS read and write XLS/XLSX files directly you need to comment out three lines inside of your xls.src file. You can open this file by entering:
from the GAUSS command prompt. GAUSS will know which directory to look in. You need to comment out these lines:
#ifOS2WIN #define USECOMEXCEL 1 #endif
from the GAUSS command line. Then you should be able to read and write any size file that the XLS or XlSX format can handle.
Thank you for the response. After doing that, I now get the input message "Incorrect input: range too large." Thoughts?
I have it working now. I think your hypothesis about the matrix being too large was correct. Thank you for the help.