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.