When importing from an Excel file for the data contained in column 3 and rows 2 through 58, for example, one can use the following command:

d=Import["file.xlsx", {"Data", 1, Range[2, 58], 3}]

I would like to do the "reverse." That is, export to the file.xlsx to the same column and row range:

As a simple test example, I have tried

test=Column[Table[i^2 , {i, 0, 56}]];Export["file.xlsx", test, {"Data", 1, Range[2, 58], 3}]

But it fails, as does, incidentally,

test=Table[i^2 , {i, 0, 56}];Export["file.xlsx", test, {"Data", 1, Range[2, 58], 3}]

Any suggestions on how to do this simply?

PS: Currently, I simply Export["file1.xlsx", test] and then copy and paste into file.xlsx within Excel. I am trying to cut out the intermediate step.


Your Answer

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

Browse other questions tagged or ask your own question.