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
convert FMT file to xls or txt file
I have matrix files that I would like to save as xls or txt files. Is there anyone who knows how to do?
Let's say that you have some data in a file called my_variable.fmt and you want to save it if a file named my_xls_file.xls. You can accomplish that like this:
//load the matrix from the .fmt file load my_variable; //write it to an Excel file xlsWrite(my_variable, "my_xls_file", "A1", 1, "");
More explanation of how to read and write Excel files in GAUSS can be found here.
To write the data to a .txt file you use the output function and the print function like this:
//load the matrix from the .fmt file load my_variable; //set output to print to 'my_txt_file.txt' //(reset means if the file exists write over it) output file=output.txt reset; //print 'my_variable' sending output to //the screen and 'my_txt_file.txt' print my_variable; //turn output to file off so no more //print statements go to this file output off;