从Google文档电子表格粘贴时获取不一致的制表符分隔符宽度(Getting inconsistent tab delimiter width when pasting from Google docs spreadsheet)

 我正在尝试为某些人创建一个小工具，他们需要做的就是复制电子表格的内容，然后将其粘贴到文本框中，这将为他们嵌入文章创建一个很好的表格。 
 
 我设法做了所有事情，但Google文档在文本编辑器中复制和粘贴数据时，似乎在值之间得到了制表符分隔符的大小（宽度）错误。 所以，而不是得到4个默认空格，我在某些情况下得到2，到目前为止，我设法找出原因是一些单元格包含带空格的字符串。 出于某种原因，这似乎混淆了Google文档，从而提供了错误的间距，这反过来又毁了我的剧本。 
 
 我知道我可以在这里使用逗号分隔值，但问题是我们试图让人们能够简单地复制和粘贴。 请看下面的示例输出： 
 
School Name Location    Type    No. eligible pupils
 
 在此示例中，学校名称是一个单元格，位置是另一个单元格，类型是另一个，合格的学生是最后一个。 很明显，第一个细胞在右侧没有必要的空间。 
 
 有任何想法吗？ 我考虑过将占用空间超过1的所有空格转换为逗号，但这可能会导致用户可能实际使用的情况2 ...这将无法再次使用。 

I am trying to create a gadget for some people, where all they need to do is really copy the contents of a spreadsheet, then paste it in a textbox, which will in turn create a nice table for them to embed in their articles.
 
I managed to do everything, however Google docs, when copying and pasting data in a text editor, seems to get the size (width) of the tab delimiter wrong between values. So, instead of getting 4 spaces that is the default, i am getting 2 in some cases and so far i managed to find out that the reason is that some of the cells contain strings with spaces. For some reason, this seems to confuse Google docs, thus supplying wrong spacings, which in turn, ruin my script.
 
I know i can use comma separated values here, but the issue is we are trying to give people the ability to simply copy and paste. Look at the example output below:
 
School Name Location    Type    No. eligible pupils
 
In this example, School Name is one cell, Location is another, Type is another and No. eligible pupils is the last one. It is clear that the first cell does not have the necessary space on the right.
 
Any ideas? I thought about converting all blank spaces that take more than 1 space to commas, but this might lead to a situation users might actually use 2... which would not work again.

原文：https://stackoverflow.com/questions/34768881