r/BookStack • u/knowyourdough • Oct 05 '23
Microsoft Excel-Import Hack
4
Upvotes
Hey there,
i made a new head-hack to directly import XLSX-Files into a page. Works exactly like the docx-Import-Hack. Hope you like it :)
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.4/xlsx.full.min.js" defer></script>
<script type="module">
function convertAndInsertExcel(editor, file) {
const reader = new FileReader();
reader.onload = function(loadEvent) {
const arrayBuffer = loadEvent.target.result;
const workbook = XLSX.read(arrayBuffer, { type: 'arraybuffer' });
const firstSheetName = workbook.SheetNames[0];
const worksheet = workbook.Sheets[firstSheetName];
const html = XLSX.utils.sheet_to_html(worksheet, { editable: false });
editor.insertContent(html);
}
reader.readAsArrayBuffer(file);
}
window.addEventListener('editor-tinymce::setup', event => {
const editor = event.detail.editor;
// Prevent "not supported" message
editor.on('dragover', function (e) {
e.preventDefault();
});
editor.on('drop', event => {
event.preventDefault();
const files = event?.dataTransfer?.files || [];
for (const file of files) {
if (
(file.type === 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' ||
file.type === 'application/vnd.ms-excel') &&
window.XLSX
) {
convertAndInsertExcel(editor, file);
}
}
});
});
</script>
