Anthology of Ideas

This was an extremely quick project to turn spreadsheet data into an XHTML table. The plugin is quite simple to use, just copy some data from a spreadsheet ( or the visible part of an XHTML table) and paste it into a blog post between the tags [table] and [/table] (make sure that columns are tab separated and rows are on their own line). This is a no frills plugin. The first row is used as the column names and is added to a thead tag. Anything can be added to the [table] tag after “table” and it will become the table’s caption. EX [table "This is an example table"]

So this:

1. [table "This is an example table"]
2. gf sfg sfcx dfg
3. asd sd dsfs
4. xcv fds sgdf
5. dfg dfg dfg
6. dfg dfg dfg
7. [/table]

Becomes:

Installation:

1. Copy and Paste the contents of the texbox below into a .php file.
2. Upload and activate.

1. <?php
2. /* Plugin Name: Tabeler Plugin URI: http://anthologyoi.com/plugins/ Description: This plugin allows you to copy data directly from a spreadsheet and paste it into your blog, and will automatically create a table for it. Version: 0.1 Author: Aaron Harun. Author URI: http://anthologyoi.com */
4. add_filter('the_content','tabler_find',1);
5. add_filter('the_excerpt','tabler_find',1);
7. function tabler_find($content) {
8. return preg_replace_callback('!\[table([^]]*)\](?:\r\n|\n|\r|)([\S\s]*? [\S\s]*?)(?:\r\n|\n|\r|)\[/table\]!ims', 'tabler_callback', $content);
9. }
12. function tabler_callback($matches) {
14. $pos_table = $matches[2];
16. if(strpos($pos_table,chr(13)) !== FALSE){
17. $rows = explode(chr(13),$pos_table);
18. }else{
19. $rows = explode("\n",$pos_table);
20. }
22. if(is_array($rows)){
23. if($rows > 1){
24. $table .= '<table>';
26. foreach($rows as $row){
27. $i++;
28. $cols = explode(" ",$row);
30. if($i==1)
31. $table .= '<thead>';
33. $table .= '<tr>';
35. foreach($cols as $col){
36. $table .= '<td>'.$col.'</td>';
37. }
39. $table .= '</tr>';
41. if($i==1){
42. $table .= '</thead>';
44. $table .= '<tbody>';
45. }
46. }
47. $table .= '</tbody>';
49. $table .= '</table>';
51. return $table;
52. }
53. }
54. }
56. ?>
57. Use the following to copy and paste the code.
    <?php /* Plugin Name: Tabeler Plugin URI: http://anthologyoi.com/plugins/ Description: This plugin allows you to copy data directly from a spreadsheet and paste it into your blog, and will automatically create a table for it. Version: 0.1 Author: Aaron Harun. Author URI: http://anthologyoi.com */ add_filter('the_content','tabler_find',1); add_filter('the_excerpt','tabler_find',1); function tabler_find($content) { return preg_replace_callback('!\[table([^]]*)\](?:\r\n|\n|\r|)([\S\s]*? [\S\s]*?)(?:\r\n|\n|\r|)\[/table\]!ims', 'tabler_callback', $content); } function tabler_callback($matches) { $pos_table = $matches[2]; if(strpos($pos_table,chr(13)) !== FALSE){ $rows = explode(chr(13),$pos_table); }else{ $rows = explode("\n",$pos_table); } if(is_array($rows)){ if($rows > 1){ $table .= '<table>'; foreach($rows as $row){ $i++; $cols = explode(" ",$row); if($i==1) $table .= '<thead>'; $table .= '<tr>'; foreach($cols as $col){ $table .= '<td>'.$col.'</td>'; } $table .= '</tr>'; if($i==1){ $table .= '</thead>'; $table .= '<tbody>'; } } $table .= '</tbody>'; $table .= '</table>'; return $table; } } } ?>

Bookmark