New User: 1st Post: Can I use excel spreadsheets inside Tiddly please

[paulda...@gmail.com]

Hi all,

New User with my 1st Post. Please be kind.

Can I use excel spreadsheets inside Tiddly please?

Yours Faithfully

Paul

[Birthe C]

Welcome Paul,

I am sure someone knowing more about it will answer you. Meanwhile you might be interested in seeing 

this https://tiddlywiki.com/prerelease/editions/xlsx-utils/

Birthe

[paulda...@gmail.com]

Thanks Birthe!

Very kind of you to reply.

Thank you also for your link.

I had seen it and tried to implement it, but stopped when I realised that it appears to only allow for the viewing, and not the modifying of the excel file in Tiddly . . .

Have you used it?

Thanks

Paul

[Birthe C]

Sorry Paul,

I have not tried it. But I think it is all about importing into tiddlers and work with them, you would not be able to work directly on your excel file.

Birthe

[TonyM]

Paul,

Perhaps you can explain more what you want to do, of course the best place for excel files is in excel, perhaps even online excel, what do you mean by in tiddlywiki?. Excel can be imported and turned into Tiddlers, tags and fields, but excel also imports/exports CSV and tiddlywiki can import/export csv. There are other ways to generate output from excel that can be used in tiddlywiki, eg screen capture, html files, now with Evans formula and other tools you can also do many things in tiddlywiki you can do in a spreadsheet.

Regards
Tony

[Jon]

Hi Paul,

I use this: http://rboue.tiddlyspot.com/ which gives an excel-like spreadsheet within Tiddlywiki.

However, I don't think you can copy & paste to and from excel.

Jon

[Steven Schneider]

Hi Paul, I'm a big fan of xlsx import; you work in excel (or google sheets & download xlsx) which is optimized for formulas etc. and import to TW. It is not live, of course. //steve.

[Mat]

Like others say; please clarify exactly what you mean.

There is "excel like" functionality in TW, most notably Evan Balsters recently unleashed "Formulas". You can also use e.g iframes to get a "peek window" to an external excel document. Or you can import excel files, e.g in csv format, to convert the data into tiddlers. There may be yet other approaches.

<:-)

[paulda...@gmail.com]

Thank you, yes I think you are correct.

[paulda...@gmail.com]

Hi Tony, thank you for your response.

Am migrating a lot of my data over to Tiddly. The ability to tag and hierachically organise data with content that is immediately word searchable is awesome.

A lot of my information though is in spreadsheets. Wish I could access the spreadsheets inside Tiddly. As I wish to share some the excel spreadsheets with others i need the spreadsheets to remain in excel format, not tiddly format.

Thank you for all your suggestions.

Yours Faithfully

Paul

[paulda...@gmail.com]

Hi.

XLSX import looks good but it is hard for me to work out exactly how to install it and the requirement for "Each sheet is expected to consist of a single header row followed by multiple content rows, each consisting of an independent record" means that spreadsheets not formatted like that will not work.

None of my excel spreadsheets are formatted as needed by XLSX import.

Hmmm still thinking what to do . . .

[paulda...@gmail.com]

Hi Jon,

May I ask, after importing an excel file to tiddly view xlsx import, does the tiddly view of the excel file authomatically change each time you alter the excel file thank you?

Yours Faithfully

Paul

Does xlsx import change the 

On Saturday, January 27, 2018 at 4:20:47 AM UTC+11, Steven Schneider wrote:

[Jon]

Hi Paul,

I've only used the plugin to create a spreadsheet (with excel-like functionality) within the tiddlywiki. I'm not aware of any ability to import/export (the last time I tried, I couldn't copy and paste data to and from excel)

Regards

Jon