Tag Info

New answers tagged


Looks like you are looking for the Dataset format. Using "ExampleData/elements.xls" to get an example .xls file: ds = SemanticImport["ExampleData/elements.xls"] Now ds[1] and ds[All, "Name"]


Let's assume your excel sheet has three columns with headings Oct through Dez. Import it imp = Catenate @ Import["excel.xlsx"] {{"Okt", "Nov", "Dez"}, {10., 11., 12.}, {1., 2., 3.}} The Catenate is necessary to remove the outermost brackets. Get header head = imp[[1]] {"Okt", "Nov", "Dez"} Get values vals = imp[[2 ;;]] {{10., 11., ...

Top 50 recent answers are included