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
Trying to load a matrix from an Excel file with xlsLoadVars
I always use the below to load my data. But it is very cumbersome because I use xlsx file.
capt = 24; nvar = 32; load ytemp[capt,nvar]=c:\set1.txt;
So I tried to use the following command: xlsLoadVars("set1.xlsx");
It works. But it loaded 32 vectors (24 by 1). The dataset is 24 by 32.
How can I load the dataset file(xlsx) to a 32 by 24 matrix??
Please let me know!
The spreadSheetReadM command is will read in Excel data as a matrix. For example if you want to read a 24x5 matrix from the cells starting at B2 from a file named set1.xlsx:
my_matrix = spreadSheetReadM("set1.xlsx", "B2:F25", 1);
You can use the function xlsMakeRange to find the spreadsheet row number and column header that correspond to a numerical row/column combination. For example, to find out the spreadsheet row/column for the 24th row and the 32nd column:
print xlsMakeRange(24, 32);
More information on reading and writing Excel data can be found here.