Export to csv, tab as column delimiter

Tags: #<Tag:0x00007efc608ee1b8>
#1

Hi,

I’m trying to export (and download as file) to csv using ‘\t’ as column delimiter so that you can open the file in Excel, However it seems like ‘\t’ is not supported? Is this correct, or is it a bug? Is there a workaround?

-Thanks!

#2

Hi @tore_senneseth
I’ll mark your idea as a feature as it’s not currently supported.

#3

Hi @tore_senneseth, you can provide your custom column delimiter in method settings like this:

exportPlugin.downloadFile('csv', {
      columnHeaders: true,
      rowHeaders: true,
      columnDelimiter: '\t'
});
#4

Not sure which one of you replied first, but ‘\t’ does not seem to work as a columnDelimiter.
Probably because of the escape charachter…?
You can try it in your own example: https://docs.handsontable.com/pro/1.2.0/demo-export-file.html

#5

@tore_senneseth @budnix I’m marking this issue as a bug.

#6

Well, actually, when I export to file using ‘;’ as the columnDelimiter, the exported file is tab delimited…

#7

I’ve prepared simplified demo at http://jsfiddle.net/9Lf0n9wh/1/ (different column delimiter). Can you once again confirm that this is not working as expected? Looking into a exported file’s content it seams that they both have correct column delimiter.

#8

Wow…totally sorry, looks like I screwed up! I was using Excel to open the .csv files and had been screwing around with the delimiter settings for the OS to test some issues not related to this stuff. I had totally forgotten about that. Sorry you had to waste your time on this one, my bad!

#9

No problem. It’s important that everything is clear now :relaxed:

#10