XLSX Import Tool - Documentation & Example

189 views
Skip to first unread message

stevesuny

unread,
Mar 10, 2017, 10:41:39 PM3/10/17
to TiddlyWiki
Hi folks, as part of the class I teach where we use TiddlyWiki to design and write interactive text -- there is an open class at DesignWriteStudio -- I've developed some documentation and examples for using the xlsx import tool.

This tool, currently in the 5.1.14 pre-release version, does amazing things. For example, using the importhtml function in google sheets, it is straightforward to import any table from the Web (Wikipedia...) and make a nicely interactive front-end.

If you're interested, check out the tutorial. Let me know if it works, or if it could be improved. Thanks!

//steve.

stevesuny

unread,
Mar 10, 2017, 10:52:13 PM3/10/17
to TiddlyWiki
Really, it's a plugin, not a tool :)

 -- the XSLX Utilities Plugin --

Alex Hough

unread,
Mar 11, 2017, 2:28:06 AM3/11/17
to TiddlyWiki
Hi Steve,

the video doesn't seem to be working for me (Mac Chrome)



Alex

--
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 tiddlywiki+unsubscribe@googlegroups.com.
To post to this group, send email to tiddl...@googlegroups.com.
Visit this group at https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/078e25f6-184f-4413-a4d1-adea02c114ef%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

oleghbond

unread,
Mar 12, 2017, 4:04:45 AM3/12/17
to TiddlyWiki
Hi, Steve,

cool tool. 

At the moment I've got a couple of questions:
  1. Is this tool associated specificly with updog.co?
  2. Would it considered to provide with inverse operation: export from TW to XLSX?
  3. Ideally it would be great to obtain controllable sync between TW and Google Spreadsheet directly. What about that?
Sincerely,
Olegh

субота, 11 березня 2017 р. 05:41:39 UTC+2 користувач stevesuny написав:

stevesuny

unread,
Mar 13, 2017, 9:18:01 AM3/13/17
to TiddlyWiki
Fixed video; lost macro tiddler (somehow). Thanks for letting me know.


On Saturday, March 11, 2017 at 2:28:06 AM UTC-5, AlexHough wrote:
Hi Steve,

the video doesn't seem to be working for me (Mac Chrome)



Alex
On 11 March 2017 at 03:52, stevesuny <stev...@gmail.com> wrote:
Really, it's a plugin, not a tool :)

 -- the XSLX Utilities Plugin --



On Friday, March 10, 2017 at 10:41:39 PM UTC-5, stevesuny wrote:
Hi folks, as part of the class I teach where we use TiddlyWiki to design and write interactive text -- there is an open class at DesignWriteStudio -- I've developed some documentation and examples for using the xlsx import tool.

This tool, currently in the 5.1.14 pre-release version, does amazing things. For example, using the importhtml function in google sheets, it is straightforward to import any table from the Web (Wikipedia...) and make a nicely interactive front-end.

If you're interested, check out the tutorial. Let me know if it works, or if it could be improved. Thanks!

//steve.

--
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 tiddlywiki+...@googlegroups.com.

To post to this group, send email to tiddl...@googlegroups.com.
Visit this group at https://groups.google.com/group/tiddlywiki.

stevesuny

unread,
Mar 13, 2017, 9:24:38 AM3/13/17
to TiddlyWiki
Thanks for the questions. I am the evangelist for this tool; Jeremy built it as a plugin. Note it requires the pre-release 5.1.14 version of TW.


On Sunday, March 12, 2017 at 4:04:45 AM UTC-4, oleghbond wrote:
Hi, Steve,

cool tool. 

At the moment I've got a couple of questions:
  1. Is this tool associated specificly with updog.co?

No. I am using updog as a host : any google drive or dropbox folder can be registered with updog.co and can serve a wiki using https://updogsitename.updog.co/wikiname.html, with all of the auto-sync features of google drive / dropbox.

 
  1. Would it considered to provide with inverse operation: export from TW to XLSX?

No, not at all. Though the export-to-json or export-to-csv on advanced search, via a filter collection, provides this functionality.
  1. Ideally it would be great to obtain controllable sync between TW and Google Spreadsheet directly. What about that?

I would agree. Hope that happens. There is some chatter about this on the group; haven't kept up with it for a few months tho.

 
Reply all
Reply to author
Forward
0 new messages