Hello, folks.
In a rather old TWClassic, I found this function that converted pasted
cells from spreadsheet (either excel or google sheets) into a TW Table.
I was wondering if anyone has code that works in TW5? (I seem to have
pasted the source into my old tiddler, but that wiki seems to be gone...).
Thanks in advance for any help!
//steve.
----------------
(code snipped found in old tiddlywiki)
<html>
<p align="center">
<textarea id="xclToTw" rows="10" cols="60"></textarea><br />
<button onclick="(function(){var
ta=document.getElementById('xclToTw'); displayMessage('original: ' +
ta.value); ta.value=ta.value.replace(/^|$|\t/gm, '|');})();" >
Translate</button>
</p>
</html>
!!! Usage
This function will insert {{{|}}} at the beginning and end of each line,
and in between each column of your spreadsheet data. To use,
# Copy spreadsheet rows/columns.
# Paste in box above. Click Translate.
# Select and copy contents of box above.
# Paste into new tiddler and name the new tiddler.
#Save.
Hint: adding an {{{h}}} to the end of the first row will make your table
sortable.
[[Source|http://oldwiki.tiddlywiki.org/wiki/How_To/Converting_Excel_Spreadsheets_to_TiddlyWiki_Tables]]
--
You received this message because you are subscribed to the Google Groups
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit
https://groups.google.com/d/msgid/tiddlywiki/fedfad96-59bd-4c22-b346-0c608500a6a0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
