I just realized I left this thread dangling .... And I should have noted to the group, that the xlsx import *natively* will read column names in an xlsx file as field names, by selecting import by "column" instead of import by row. One caveat: It is necessary to have a column named "title" in order for the import to work at all.
On Monday, July 10, 2017 at 10:33:08 AM UTC-4, stevesuny wrote: > > > <https://lh3.googleusercontent.com/-Kc7yv9ywPFQ/WWOPT4qmswI/AAAAAAAAR8g/rIjqZm77_4EFJmPgdhMMZwtgYXFkzcNHACLcBGAs/s1600/2017-07-10_1029.png> > The basic plugin allows the integration / quick import of multiple > spreadsheets and using tags or fields for data matching. Incredibly > powerful way to use TW as front-end kind-of visualization tool. More on > that later. > > But, in the meantime, anyone has suggestions to do easily and > auto-magically move column names into the importer? In the pic above > (below?) i created a second sheet in the xlxs file that lists the > fieldname, by doing a copy/paste transpose. Better would be a default > setting to import each column name not otherwise identified as field. That > way, to import, i'd just need to specify a sheet. If sheet didn't have > title column, then fail Or allow me to indicate sheet, and to indicate > title field and tags field etc. Have my by-hand additions to plugin > override anything imported from spreadsheet. > > Anyone done something like this? > > > > > <https://lh3.googleusercontent.com/-Kc7yv9ywPFQ/WWOPT4qmswI/AAAAAAAAR8g/rIjqZm77_4EFJmPgdhMMZwtgYXFkzcNHACLcBGAs/s1600/2017-07-10_1029.png> > > -- 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+unsubscr...@googlegroups.com. To post to this group, send email to tiddlywiki@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/eefe5aae-a493-40c5-b2ce-5aea7cb4c358%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
