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?
$\begingroup$
$\endgroup$
2
-
$\begingroup$ This seems more of an Excel question than a Mathematica question. $\endgroup$m_goldberg– m_goldberg2012-11-15 05:53:37 +00:00Commented Nov 15, 2012 at 5:53
-
1$\begingroup$ I think that this question is absolute valid. This link from Wolfram can help. $\endgroup$Murta– Murta2012-11-15 14:09:47 +00:00Commented Nov 15, 2012 at 14:09
Add a comment
|
1 Answer
$\begingroup$
$\endgroup$
0
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."}} *)
