Export Matrix to excel

[Kuda Makoni]

I used spamt to create a 2000X2000 matrix. I am now trying to export the matrix but i get the following error message


spmat export matrix W using excel "C:\Documents 1\My Documents\Model - Logit\Data\lim
> dep\W2.xlsx", sheet("Sheet1"),replace
name: too many specified
r(103);

[Emad Shehata]

spmat can convert to text file

spmat export W using W2.txt

[Emad Shehata]

Take a look in this post

http://www.statalist.org/forums/foru...port-txt-files

[Kuda Makoni]

I am actually trying to export to excel, Can i transfer the matrix to the Data part

[Sergiy Radyakin]

Kuda,

if you are mentioning non-standard commands, then as per FAQ paragraph 12.1 you must describe them properly.

That said, the shortest way to export results to Excel is to use the putexcel command. Here is an example:

clear all
version 13.0
set matsize 2000
matrix M=J(2000,2000,9999)
putexcel set "C:\temp\huge_matrix.xlsx", sheet("M") replace
putexcel A1=matrix(M)

Produces a proper Excel file of size 10,058,073 bytes with the contents of the matrix.

Reference:

• putexcel

Best, Sergiy Radyakin