Hi! I am a University Student at Grand Valley State University, in the Psychology Department. I was recently attempting to import data raw data from an Excel Spread sheet into Mathematica and was unable to do so. Is it possible that I could get some assistance in doing this?
Contact Info: hubbards@mail.gvsu.edu
Hi Sultan,
If you import a file with a file name having the Excel extension (xls or xlsx) then Mathematica will import it as a list structure. The top of the structure is a list containing the worksheets. Inside each worksheet is a list of lists, where each inner list is a row. When importing a spreadsheet, Mathematica will recognize text representing numbers and read them as such. If this doesn’t work for you, I suggest you post an example with the Mathematica code in the spikey box and the spreadsheet attached.
Best,
David
data = Import["MySpreadsheet.xlsx"]
I have found that Import[ ] works well unless the spreadsheet is large.
How large is your excel document?
Thanks you both for your help!