Advertisement
Guest User

Untitled

a guest
Sep 17th, 2014
190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. firstSheet=Import[NotebookDirectory[]<>"data.xlsx",{"Sheets","SomeData"}];
  2. secondSheet=Import[NotebookDirectory[]<>"data.xlsx",{"Sheets","SomeMoreData"}];
  3.  
  4. firstSheet = SemanticImport[NotebookDirectory[]<>"data.xlsx",
  5. {"String", "Date", "String", "Number"}]
  6.  
  7. SemanticImport[{NotebookDirectory[]<>"data.xlsx", {"Sheets", "SomeMoreData"}},
  8. {"String", "Date", "String", "Number"}]
  9.  
  10. {firstSheet, secondSheet} = Import[NotebookDirectory[]<>"data.xlsx", "XLSX"]
  11.  
  12. {firstSheet, secondSheet} =
  13. SemanticImport[NotebookDirectory[]<>"data.xlsx",
  14. {"String", "Date", "String", "Number"}]
  15.  
  16. sheets = Import["sample.xlsx", "Sheets"]
  17. (*{"DataSet1", "DataSet2"}*)
  18.  
  19. data = Import["sample.xlsx", "Data"]
  20. (*{{{"Country", "Value"}, {"AR", 10.}, {"BE", 20.}, {"SG", 30.}, {"TW",
  21. 40.}}, {{"City", "Value", "Color"}, {"Amsterdam", 10.,
  22. "Blue"}, {"London", 20., "Red"}, {"Paris", 30., "Yellow"}}}*)
  23.  
  24. Set[Evaluate[Symbol[#] & /@ sheets], data];
  25. DataSet1
  26. (*{{"Country", "Value"}, {"AR", 10.}, {"BE", 20.}, {"SG", 30.}, {"TW",
  27. 40.}}*)
  28. DataSet2
  29. (*{{"City", "Value", "Color"}, {"Amsterdam", 10., "Blue"}, {"London",
  30. 20., "Red"}, {"Paris", 30., "Yellow"}}*)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement