Problems with .xlsx Exporting
- To: mathgroup at smc.vnet.net
- Subject: [mg114774] Problems with .xlsx Exporting
- From: "Blackwell, Keith" <Keith.Blackwell at rbccm.com>
- Date: Thu, 16 Dec 2010 05:51:23 -0500 (EST)
V8 supports xlsx files now. But whenever I try to export a set of data
that has more than 255 columns, I get the error msg for .xls exporting.
Dimensions[BigMatrix]={1000,500}
Export["BigMatrix.xlsx", BigMatrix];
Export::toomany3: Cannot export to XLS. The number of columns exceeds
the limit of this format. >>
However, if do :
Dimensions[LittleMatrix]={1000,255}
Export["LittleMatrix.xlsx", LittleMatrix];
It works.
Any suggestions would be appreciated,
Keith
________________________________________
This E-Mail (including any attachments) may contain privileged or confident=
ial information. It is intended only for the addressee(s) indicated above.
The sender does not waive any of its rights, privileges or other protection=
s respecting this information.
Any distribution, copying or other use of this E-Mail or the information it=
contains, by other than an intended recipient, is not sanctioned and is pr=
ohibited.
If you received this E-Mail in error, please delete it and advise the sende=
r (by return E-Mail or otherwise) immediately.
This E-Mail (including any attachments) has been scanned for viruses.
It is believed to be free of any virus or other defect that might affect an=
y computer system into which it is received and opened.
However, it is the responsibility of the recipient to ensure that it is vir=
us free.
The sender accepts no responsibility for any loss or damage arising in any =
way from its use.
E-Mail received by or sent from RBC Capital Markets is subject to review by=
Supervisory personnel.
Such communications are retained and may be produced to regulatory authorit=
ies or others with legal rights to the information.
IRS CIRCULAR 230 NOTICE: TO COMPLY WITH U.S. TREASURY REGULATIONS, WE ADVI=
SE YOU THAT ANY U.S. FEDERAL TAX ADVICE INCLUDED IN THIS COMMUNICATION IS N=
OT INTENDED OR WRITTEN TO BE USED, AND CANNOT BE USED, TO AVOID ANY U.S. FE=
DERAL TAX PENALTIES OR TO PROMOTE, MARKET, OR RECOMMEND TO ANOTHER PARTY AN=
Y TRANSACTION OR MATTER.