After performing some calculations with excel sheets I end with a tridimensional matrix a to be export to a .xlsx format and a vector q that contains the name of all the sheets (so $Length[q] = Length[a]$). In the documentation the usual way to export this named excel data is to do something like

Export["file name.xlsx", q[[1]] -> a[[1]], ..., q[[n]] -> a[[n]]] ]

But since the $Length[a]]$ is variable I do not know an automatic way to do that. I tried something like

q -> a

But Mathematica can't process in this way.

How can I do that?


  • $\begingroup$ You say the usual way to export this named and then the command says Import? Is this a typo? $\endgroup$
    – Nasser
    Jan 27, 2014 at 22:38
  • $\begingroup$ Yes, thanks, @Nasser. $\endgroup$
    – Zhozer
    Jan 28, 2014 at 1:18

1 Answer 1

a = {{{1}}, {{2}}};
q = {"one", "two"};
Export["c:\\test.xlsx", Rule @@@ Transpose@{q, a}]

Mathematica graphics

  • $\begingroup$ Fantastic, thanks, @belisarius. I was trying something more complicate. I need to use more the rule method. ^^ $\endgroup$
    – Zhozer
    Jan 28, 2014 at 22:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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