XLS-UTILS inserts commas in the text area

Plugins
1

I have been using XLS-UTILS to create some tiddlers. However, when I try and populate the text area, the imported text has commas between all the words replacing the spaces.

Has anyone else noticed this? Do I need to format the text in a particular way in the worksheet cell for this to import correctly?

This is what is in the cell:

Here is some text.

This is what appears in the tiddler text area:

Here,is,some,text.,

2

I have not seen this but it may help if you can demonstrate this on a tiddlyhost wiki. Can you test to see if "Here is some text." would operate differently?

It appears to be delimiting it as CSV based on space.

3

Here is a Tiddlyhost https://excel-import.tiddlyhost.com/

I have set up the import template but in this case cannot get xls-utils to work at all!

I cannot upload the excel workbook here, but this is all the worksheet ‘People’ contains:

ppl_ID Title1 Biography
1118 Test Here is some text.
4

Hi @myfta I would like to investigate this, but it would be helpful if it were easier to replicate the problem. Would you be able to use a file transfer service like wetransfer.com to share a TW along with a sample XLSX?

5

I have the TW here https://excel-import.tiddlyhost.com/ but it is now not working at all!

Here is a link to the test Excel file Send Big Files up to 5GB Securely. Tresorit Send: Secure, Fast & Free