Excel Macro reads from attached excel file.
{excel:file=^filename.xls}
- The macro does not handle fancy formatting well. So worksheets should be simple.
- For more information about this macro go here
- Currently the macro does not convert .xslt (new excel type) files.
- Note; you can sort columns by clicking on heading reload the page to reset to the excel file state.
| Number | Date | Person | New Column |
|---|---|---|---|
| 1 | 6-Mar | Doe, Jane | abcdefg |
| 2 | 7-Mar | Smith, Paul | ghijkellksad |
| 3 | 8-Mar | Jones, Alan | ghijkellksad |
| 4 | 9-Mar | Mitchell, Peter | ghijkellksad |
| 5 | 10-Mar | Brown, Ada | ghijkellksad |
| 6 | 11-Mar | Newman, Joan | ghijkellksad |
| 7 | 12-Mar | Cartwright, Hal | ghijkellksad |
| 8 | 13-Mar | Falk, Ed | ghijkellksad |
| 9 | 14-Mar | Wright, Jane | ghijkellksad |
| 10 | 15-Mar | Smith, James | ghijkellksad |
| 11 | 16-Mar | Roberts, Sarah | ghijkellksad |
| 12 | 17-Mar | Haverty, Sean | ghijkellksad |
| 13 | 6-Apr | Neuman, Albert | ghijkellksad |
| Sheet 2 | |
|---|---|
| Number | Name |
| 1 | Brown |
| 2 | Brett |
| 3 | Jones |
| 4 | Frye |
| 5 | Smith |
| 6 | Smith |
| 7 | Smith |
| 8 | Smith |
| 9 | Smith |
| 10 | Smith |
| 11 | Smith |
| 12 | Smith |
| 13 | Smith |
| 14 | Smith |
| 15 | Smith |
| 16 | Smith |