Message Boards Message Boards

6 Replies
2 Total Likes
View groups...
Share this post:

How to export matrices from Mathematica to Excel?

Posted 10 years ago

Hello everyone,

I am working on matrices in Mathematica and want it to be exported to a spreadsheet. Please find attachment of a notebook with matrices am working on. I would be glad if anyone could help me. Thank you.



6 Replies

Hello Mohamed, I am also new to Mathematica. Can I ask you how did you calculate the path matrix (M) in your attached file?

POSTED BY: Nehal Elshaboury

If this is a Trial edition, then to export you need to

a) convince someone in WRI Sales to get you an Export-enabled license, or

b) check with the university IT office if a regular copy of Mathematica is available through the university.

POSTED BY: Bruce Miller

I have activated the full version. Still it shows 10 days left. Is it because of the trial version?

Posted 10 years ago

From Help:

The currently supported export formats:

In[1]:= $ExportFormats

Out[1]= {"3DS", "ACO", "AIFF", "AU", "AVI", "Base64", "Binary", "Bit", "BMP", "Byte", \
"BYU", "BZIP2", "C", "Character16", "Character8", "Complex128", "Complex256", \
"Complex64", "CSV", "DICOM", "DIF", "DIMACS", "DOT", "DXF", "EMF", "EPS", \
"ExpressionML", "FASTA", "FITS", "FLAC", "FLV", "GIF", "Graph6", "Graphlet", \
"GraphML", "GXL", "GZIP", "HarwellBoeing", "HDF", "HDF5", "HTML", \
"Integer128", "Integer16", "Integer24", "Integer32", "Integer64", "Integer8", \
"JPEG", "JPEG2000", "JSON", "JVX", "KML", "LEDA", "List", "LWO", "MAT", \
"MathML", "Maya", "MGF", "MIDI", "MOL", "MOL2", "MTX", "MX", "NASACDF", "NB", \
"NetCDF", "NEXUS", "NOFF", "OBJ", "OFF", "Package", "Pajek", "PBM", "PCX", \
"PDB", "PDF", "PGM", "PICT", "PLY", "PNG", "PNM", "POV", "PPM", "PXR", \
"QuickTime", "RawBitmap", "Real128", "Real32", "Real64", "RIB", "RTF", "SCT", \
"SDF", "SND", "Sparse6", "STL", "String", "SurferGrid", "SVG", "SWF", \
"Table", "TAR", "TerminatedString", "TeX", "Text", "TGA", "TGF", "TIFF", \
"TSV", "UnsignedInteger128", "UnsignedInteger16", "UnsignedInteger24", \
"UnsignedInteger32", "UnsignedInteger64", "UnsignedInteger8", "UUE", \
"VideoFrames", "VRML", "VTK", "WAV", "Wave64", "WDX", "WMF", "X3D", "XBM", \
"XHTML", "XHTMLMathML", "**XLS**", "**XLSX**", "XML", "XYZ", "ZIP", "ZPR"}
POSTED BY: rionilo
Export["mfile.csv", m]

This can then be opened with Excel.

POSTED BY: Terrence Honan

But in his attached notebook it says "Export is not available in this version of the Wolfram Language", so probably he is using a trial version.

POSTED BY: Rolf Mertig
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
or Discard

Group Abstract Group Abstract