Mathematica Stack Exchange is a question and answer site for users of Mathematica. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Using Mathematica v9.0.1 This example is from the docs:

data1 = Table[{t, 9.8*t^2}, {t, 0, 3, .1}];
data2 = Table[{t, 9.8*t^2}, {t, 0, 5, .2}];
Export["datasets.xlsx", "Sheets" -> {"Experiment 1" -> data1, 
                                     "Experiment 2" -> data2}, "Rules"]


JLinkJava::argxs: The static method SystemConvertExcelDumpwrite was called with an incorrect number or type of arguments. The arguments, shown here in a list, were {XLSX,C:\Documents and Settings\xxx\datasets.xlsx,{Experiment 1,Experiment 2},{{{0.,0.},{0.1,0.098},<<27>>,{2.9,82.418},{3.,88.2}},{<<1>>}},{{{Null}}},{{{}}},Author->Created by Wolfram Mathematica 9.0 :}.

While the following:

Export["datasets.xlsx", {data1, data2}]

works OK, but I need sheet names.

Any idea?

share|improve this question
I get the same with 9.0.1 on Mac 10.8.4 . Said a few times here that I can't see why the docs can't be programmatically checked for these sorts of errors. Seems like poor QA standards. – Mike Honeychurch Jul 29 '13 at 2:42
Another example further down in the docs gives the same error. Very sloppy QA. – Mike Honeychurch Jul 29 '13 at 2:46
@MikeHoneychurch Yep. I posted this one just because it's somewhat easier to read, but the other syntax results in the same error – Dr. belisarius Jul 29 '13 at 3:05
Seems to work now in V10 – Mike Honeychurch Jul 16 '14 at 4:28
up vote 8 down vote accepted

The following syntax works for exporting the two sheets:

data1 = Table[{t, 9.8*t^2}, {t, 0, 3, .1}];
data2 = Table[{t, 9.8*t^2}, {t, 0, 5, .2}];
Export["datasets.xlsx", {"Experiment 1" -> data1, 
  "Experiment 2" -> data2}]

It creates an XLSX file with two seperate sheets holding the datasets:

enter image description here

However, i agree with the comments above that QA for this is indeed very poor.

share|improve this answer
Great! A pity that I had to circumvent the whole thing in a hurry :( – Dr. belisarius Jul 29 '13 at 14:23
Many thanks for that one – user 106 Jul 29 '13 at 16:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.