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 '14 at 22:38
  • $\begingroup$ Yes, thanks, @Nasser. $\endgroup$
    – Zhozer
    Jan 28 '14 at 1:18
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 '14 at 22:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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