Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- firstSheet=Import[NotebookDirectory[]<>"data.xlsx",{"Sheets","SomeData"}];
- secondSheet=Import[NotebookDirectory[]<>"data.xlsx",{"Sheets","SomeMoreData"}];
- firstSheet = SemanticImport[NotebookDirectory[]<>"data.xlsx",
- {"String", "Date", "String", "Number"}]
- SemanticImport[{NotebookDirectory[]<>"data.xlsx", {"Sheets", "SomeMoreData"}},
- {"String", "Date", "String", "Number"}]
- {firstSheet, secondSheet} = Import[NotebookDirectory[]<>"data.xlsx", "XLSX"]
- {firstSheet, secondSheet} =
- SemanticImport[NotebookDirectory[]<>"data.xlsx",
- {"String", "Date", "String", "Number"}]
- sheets = Import["sample.xlsx", "Sheets"]
- (*{"DataSet1", "DataSet2"}*)
- data = Import["sample.xlsx", "Data"]
- (*{{{"Country", "Value"}, {"AR", 10.}, {"BE", 20.}, {"SG", 30.}, {"TW",
- 40.}}, {{"City", "Value", "Color"}, {"Amsterdam", 10.,
- "Blue"}, {"London", 20., "Red"}, {"Paris", 30., "Yellow"}}}*)
- Set[Evaluate[Symbol[#] & /@ sheets], data];
- DataSet1
- (*{{"Country", "Value"}, {"AR", 10.}, {"BE", 20.}, {"SG", 30.}, {"TW",
- 40.}}*)
- DataSet2
- (*{{"City", "Value", "Color"}, {"Amsterdam", 10., "Blue"}, {"London",
- 20., "Red"}, {"Paris", 30., "Yellow"}}*)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement