Posted by npkashyap on July 7, 2012 at 6:29am
Can soomeone tell me about a Drupal Module to upload an Excel spreadsheet which the CMS will convert to an HTML table and apply Custom CSS styling.
Can soomeone tell me about a Drupal Module to upload an Excel spreadsheet which the CMS will convert to an HTML table and apply Custom CSS styling.
Comments
http://drupal.org/project/she
http://drupal.org/project/sheetnode
Digit Professionals
Alternatively
You may be able to do it this way, depending on the structure of your spreadsheet:
1) Create a content type with fields that represent the columns in your spreadsheet.
2) Use the Feeds module to import your spreadsheet (Feeds supports CSV files natively, or there's an XLS parser).
3) Now every row in your spreadsheet is a node in Drupal (of the content type you set up in step 1)
4) Use Views to output the nodes in any way you want, including as an HTML table with classes for CSS etc.
You may also want to check out the Data module - perhaps another method there.
Maybe this sounds like a lot of steps, but you get some nice benefits: can set Feeds to update Drupal data if the spreadsheet contents change, total flexibility in Views for the output etc.