Processor for tab/csv seperated tables to enable cut´n paste from Excel and OpenOffice

[anonymous]

Hi,

Cut and paste tables from excel would be simpler than to write two vertical bars before each element.

Example tab seperated values copied from NeoOffice:

123	123	123	123
234	234	234	234

would become

123	123	123	123
234	234	234	234

[Alec Thomas]

Try this macro out:

from trac.util import escape
from StringIO import StringIO
import csv

def execute(hdf, txt, env):
    sniffer = csv.Sniffer()
    reader = csv.reader(StringIO(txt), dialect=sniffer.sniff(txt))
    out = StringIO()
    out.write('<table class="wiki">\n')
    for row in reader:
        out.write('<tr>')
        for col in row:
            out.write('<td>%s</td>' % escape(col))
        out.write('</tr>\n')
    out.write('</table>\n')
    return out.getvalue()

[Alec Thomas]

Added as CsvMacro.