Tiny library that transforms JavaScript 2-dimensional arrays to clipboard strings compatible with spreadsheets such as Microsoft Excel, Google Docs, LibreOffice and OpenOffice
npm install sheetclipTiny library that transforms JavaScript 2-dimensional arrays to clipboard strings compatible with spreadsheets such as Microsoft Excel, Google Docs, LibreOffice and OpenOffice
var str = SheetClip.stringify(arr);
The above line will convert a 2-dimensional array:
var arr = [
['A', 'B', 'C'],
['D', 'Some\nlong\ntext', 'F'],
['G', 'H', 'I']
];
To a string:
A/tB/tC/nD/t"Some/nlong/ntext"/tF/nG/tH/tI/n
Which, pasted from clipboard to an Excel sheet will render as:
| A | B | C |
| D | Some long text | F |
| G | H | I |
var arr = SheetClip.parse(str);
The above line parses a string:
A/tB/tC/nD/t"Some/nlong/ntext"/tF/nG/tH/tI/n
that was copied to clipboard from Excel sheet:
| A | B | C |
| D | Some long text | F |
| G | H | I |
to a 2-dimensional array:
[
['A', 'B', 'C'],
['D', 'Some\nlong\ntext', 'F'],
['G', 'H', 'I']
]
This library was created with the intention to be used in Handsontable. I decided to make it a separate project in case somebody else needs it.
It does not provide you with clipboard access in JavaScript. That part still needs to be figured out by you. There are various ways to achieve it but none of them is perfect. Probably the most compatible with all the browsers is to keep a hidden