markup - How can I convert an Excel table into Trac Wiki Table format? -
i've seen copy & paste converters mediawiki or html format. not find 1 converts trac wiki format (wikiformattting) uses pipes separate cells, such as:
||cell 1||cell 2||cell 3|| ||cell 4||cell 5||cell 6||
you save excel sheet csv file. command prompt (assuming running windows xp or newer) type command:
for /f "tokens=1,2,3 delims=," %a in (mycsvfile.csv) ((echo ^|^|%a^|^|%b^|^|%c^|^|) >> mywikifile.txt)
the number of tokens depends on how many columns have. 26 columns way in single pass increasing number of tokens , adding corresponding number of variable names %d, %e, etc.
Comments
Post a Comment