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 dlibrary dllcall econometrics error error codes error handling errors Excel file i/o floating network GAUSS Engine GAUSS Light graphics GUI hotkeys installation Java API license licensing linux loading data loops matrices matrix manipulation Maxlik MaxLikMT Memory multidimensional array optimization Optmum output panel data PQG graphics procs random numbers strings structures threading writing data
Time Series 2.0 MT
Find out more now
Time Series MT 2.1
Find out more now
Write large matrix to Excel
I would like to write a large matrix from GAUSS into Excel.
I can do this if the matrix is not to large using the following code:
xlswritem(y, "y.xlsx", "a2", 1, "");
where y is the name of the matrix (a 100 by 600 matrix) in GAUSS and the excel filename is y.xlsx.
If I increase the columns of y it does not work anymore.. So I cannot write a 600 by 1000 matrix into excel.
How can I make it work?
Recent versions of GAUSS should have no limitation on the size of matrix you read and write from an Excel file other than those imposed by Excel. Here is a test example that should work as a test:
x = rndn(600, 1000); ret = xlsWriteM(x,"y.xlsx", "A2", 1, ""); z = xlsReadM("y.xlsx", "A2", 1, ""); print "rows of z = " z; print "cols of z = " z;
After this snipped, z should have the same contents as the original x. If this does not work, it is most likely because you have an older version of GAUSS (probably older than version 10) or you have an older version of Excel installed on your machine.
If you have GAUSS 13 or GAUSS 14 you can comment out these lines towards the top of your xls.src file:
#ifOS2WIN #define USECOMEXCEL 1 #endif
The xls.src file is located in your
Commenting out those lines will cause GAUSS to directly read and write Excel files rather than interfacing with the Excel application which will remove that as a possible problem.
Let me know if this is does not solve your problem.