Posted by bakr on February 21, 2010 at 5:55pm
2 followers
Jump to:
| Project: | Views Excel Export |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
Would it be nice to support the colors of "table highlighter" module right into the exported excel file
cheeers
Comments
#1
Same as: Export information from a node to Excel with formatting
http://drupal.org/node/725616
Proposed solution:
#2
A small patch can do the trick:
Only convert the styles into inline markup.
It should work, proven trick :)
#3
Another Shortcut
I have used the "Table Alternate Row" Module.
After inspecting the code generated the the xls feed from generated by the views module, I noticed it is indeed and html file with an xls file extension.
Particularly, I have observed that the above mentioned module did inject the odd/even class per row.
Where as the table highlighter module did not, as the feed does not know about it.
The idea of having a common share of codebase between table highlighter and table alternate row comes in mind.
As for theming for excel, the styles should/could be referenced in the top of the xls (actually html) file as usual, whether inline or ref.
Excel in turn, should pick up the color formats. and theme the rows accordingly.
I have put a comment under the "Table alternate rows" module here
#4
Cross-linked:
http://drupal.org/node/726918#comment-2653010
#5
Please take a look here http://drupal.org/node/262338
There is a way to import into excel as html.