How to export data from excel specific cells into Mathematica? Given that the spreadsheet tab is named XYZ and that I have several cells at various locations in the same column in Excel that I want to export?
Asked
Active
Viewed 2,389 times
3
-
This seems more of an Excel question than a Mathematica question. – m_goldberg Nov 15 '12 at 05:53
-
1I think that this question is absolute valid. This link from Wolfram can help. – Murta Nov 15 '12 at 14:09
1 Answers
4
This is verbatim from the docs on XLSX:
Example excel file with two sheets:
Export["sheets.xlsx", {{"MySheet1" -> {Range[10]},
"MySheet2" -> {{"This is a string."}}}}, {{"Sheets"}}]
To import the cell at row 1, column 4 of MySheet1:
Import["sheets.xlsx", {"Sheets", "MySheet1", 1, 4}]
(* 4 *)
Import the second sheet:
Import["sheets.xlsx", {"Sheets", 2}]
(* {{"This is a string."}} *)
kglr
- 394,356
- 18
- 477
- 896