Extacting contents from excel in Drupal

Question

hi!

I want to extract the contents of a excel file and populate them in a new post( page) . I'd like to maintain the row-column relationship.

Ex:

sample.xls

Name | Age | Sex

A | 20 | M

B | 30 | F

C | 40 | M

---

In Drupal (the one which i want)

Name | Age | Sex

A | 20 | M

B | 30 | F

C | 40 | M

Is there any module in Drupal to do that or should i create a new one for it? I wish some drupaler came across this situation :)

Any suggestions or help?

thanks..

Answer 1

There's no module for what you want to do based on your comment below the question that I'm aware of. Unfortunately when you export an Excel spreadsheet to HTML Excel will attach all kinds of formatting to the result and you probably don't want that. One trick would be to save the spreadsheet as a .csv file (comma-separated values) and then use a utility to convert the CSV file into an HTML table that you can paste into your node content. I haven't used any of the utilities in this set of Google search results but there's no shortage of ones you can try, anyway.

Answer 2

Try the FeedAPI module, it is able to parse CSV files, and you can assign data to specific fields, should do exactly what you need.

Answer 3

I think this old discussion contains the resource you need.