0
$\begingroup$

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.

$\endgroup$

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.