Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/exceljs/exceljs/pull/1339 below:

[BUG] hasOwnProperty, constructor special words not serialized correctly with stream.xlsx.WorkbookWriter · Issue #1339 · exceljs/exceljs · GitHub

When trying to serialize a simple list of strings to XLSX using stream.xlsx.WorkbookWriter i get unreadable XLSX file - MS Excel complains that the file is broken. Looking inside the XML-files - it's broken for sure. Here's an example:

Lib version: 1.15.0

Run this sample code to output test.xslx file.

const ExcelJS = require('exceljs')
const filename = './test.xlsx'
const testThat = async () => {
  const workbook = new ExcelJS.stream.xlsx.WorkbookWriter({ filename, useStyles: true, useSharedStrings: true })
  const worksheet = workbook.addWorksheet('Data', {})
  const row = worksheet.addRow()
  row.values = ['hasOwnProperty', 'prototype', 'constructor']
  row.commit()
  return await workbook.commit()
}
testThat().then(result => console.log(result.modified))

Unzip xl/sharedStrings.xml and xl/worksheets/sheet1.xml files from the resulting test.xslx and pretty-print them using xmllint:

7z e test.xlsx xl/worksheets/sheet1.xml xl/sharedStrings.xml
xmllint --pretty 1 sharedStrings.xml
xmllint --pretty 1 sheet1.xml 

All 3 strings hasOwnProperty, prototype, constructor should have been added to sharedStrings.xml and referenced from the sheet1.xml file by index.

Here's what i see in the sheet1.xml now - only the prototype string has been mapped correctly, and two other strings have been replaced with the weird function ... { [native code] } which breaks MS Excel.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" mc:Ignorable="x14ac">
  <sheetFormatPr defaultRowHeight="15" outlineLevelRow="0" outlineLevelCol="0" x14ac:dyDescent="55"/>
  <sheetData>
    <row r="1" spans="1:3" x14ac:dyDescent="0.25">
      <c r="A1" t="s">
        <v>function hasOwnProperty() { [native code] }</v>
      </c>
      <c r="B1" t="s">
        <v>0</v>
      </c>
      <c r="C1" t="s">
        <v>function Object() { [native code] }</v>
      </c>
    </row>
  </sheetData>
  <pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/>
  <pageSetup orientation="portrait" horizontalDpi="4294967295" verticalDpi="4294967295" scale="100" fitToWidth="1" fitToHeight="1"/>
</worksheet>

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4