for import,we can do like this Import["XXX.xlsx", {"Data",1,2,3}],Mathematica will get the cell {2,3} of the "sheet1" in "XXX.xlsx". But if we want to export data from Mathematica to one Excel specific cell,How to realize?
Asked
Active
Viewed 1,382 times
2
-
Strongly related http://mathematica.stackexchange.com/a/15835/193 – Dr. belisarius Nov 19 '13 at 18:01
-
1Would padding the rest of the table with empty strings be sufficient? (Note that you cannot append to an existing XLS file, keeping all the entries. The only option is to completely overwrite it. If you need to append, you'd need to read in the data first, add the modification, then write out the whole table again.) – Szabolcs Nov 19 '13 at 19:19
-
Perhaps you could look at link where the access to individual excel cells is used for another purpose – user8074 Nov 19 '13 at 21:28