Message Boards Message Boards

0
|
5172 Views
|
3 Replies
|
0 Total Likes
View groups...
Share
Share this post:

Importing Excel Spread Sheet into Mathematica?

Posted 10 years ago

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

POSTED BY: Sultan Hubbard
3 Replies
Posted 10 years ago

Thanks you both for your help!

POSTED BY: Sultan Hubbard
Posted 10 years ago

I have found that Import[ ] works well unless the spreadsheet is large.

How large is your excel document?

POSTED BY: Gustavo Delfino
Posted 10 years ago

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"]
POSTED BY: David Keith
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract