Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2010

[Date Index] [Thread Index] [Author Index]

Search the Archive

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.


  • Prev by Date: Re: manipulate time
  • Next by Date: Re: how to plot nminimized result
  • Previous by thread: Re: how to debug existing notebook in workbench?
  • Next by thread: Re: how to plot nminimized result