Mathematica 9 is now available
Student Support Forum
-----
Student Support Forum: 'Excel Export Problems in Mathematica 8' topicStudent Support Forum > General > "Excel Export Problems in Mathematica 8"

Next Comment >Help | Reply To Topic
Author Comment/Response
Ameya
05/21/12 10:28am

Hello,

I am facing some problems with exporting data to Excel format. I have a list with dimensions 12000x3 and I use the following code (Here I have generated an example list of random integers with dimensions 12000x3):

Export["Test.xlsx",RandomInteger[100,{12000,3}]],"Data"]

but I get the following error:
Export::fmterr: Invalid XLS format.>>

After some investigation I found an archive thread with the same problem, http://forums.wolfram.com/mathgroup/archive/2011/Feb/msg00110.html

It seems that others have faced this problem too . However, I could not find any solution this except for some tweaking the Java parameters. I do not wish to tweak any default parameters.

Can somebody tell me why this problem still arises and what is a simple solution to it? The problem seems to be with large datasets because when I export 1200x3 list then it works fine.

It is really an annoying problem and I hope the Mathematica development team takes care of this as soon as possible.

Thanks and Regards,
Ameya

URL: ,

Subject (listing for 'Excel Export Problems in Mathematica 8')
Author Date Posted
Excel Export Problems in Mathematica 8 Ameya 05/21/12 10:28am
Re: Excel Export Problems in Mathematica 8 Forum Modera... 05/21/12 11:25am
Re: Excel Export Problems in Mathematica 8 Bill Simpson 05/21/12 10:40pm
Re: Re: Excel Export Problems in Mathematica 8 Ameya 05/22/12 11:05am
Next Comment >Help | Reply To Topic