I'm importing data from Excel. It appears that the sheet number needed in the Import statement is taken from the order that the sheets appear in the open Excel file. I need to import 2 of the sheets from an Excel file. I'd like to do it via the names of the sheets, or at least by some attribute that won't change if I add or delete other sheets or re-order the existing sheets. Can this be done?
$\begingroup$
$\endgroup$
2
-
2$\begingroup$ Yes, the XLSX documentation page tells you how. $\endgroup$– Sjoerd C. de VriesAug 1, 2013 at 13:49
-
$\begingroup$ I am embarrassed. I looked again and there it was. $\endgroup$– Mitchell KaplanAug 1, 2013 at 21:10
Add a comment
|
1 Answer
$\begingroup$
$\endgroup$
(*show all sheets*)
Import["D:\\allstuff.xls", "Sheets"]
{"portf", "notes", "calc", "xirr", "tx", "JTrade", "Yahoo"}
Import["D:\\stuff.xls", {"Sheets", "portf", 6}]
(*gets 6th row of sheet named "portf"*)
Leave off the 6 to get the whole sheet or say 6,2 to get one cell at 6,B.
