Excel file needs to be repaired after saving #3092

New Issue

felix0110 · 2024-03-25T09:11:10Z

felix0110 commented

2024-03-25 09:11:10 +00:00

I have my project running xlsx with this issues. The biggest and most problematic of these is the fact that whenever I save my workbook and then attempt to open it. I get this problem:

   var workbook = XLSX.readFile(
            `./templates/test.xlsx`,
            {
              cellHTML: true,
              cellStyles: true,
              cellDates: true,
              cellNF: false,
              cellText: false,
            }
          );
          var sheetNames = workbook.SheetNames;

          workbook.SheetNames.forEach(function (sheetName) {
            var worksheet = workbook.Sheets[sheetName];

            for (var i = 1; i <= 100; i++) {
              var border = {
                top: { style: "thin", color: "FF000000" },
                right: { style: "thin", color: "FF000000" },
                bottom: { style: "thin", color: "FF000000" },
                left: { style: "thin", color: "FF000000" },
              };
              var fill = {
                patternType: "solid", // none / solid
                fgColor: { rgb: "FFC0C0C0" },
                // bgColor: {rgb: "FFC0C0C0"}
              };
              worksheet[XLSX.utils.encode_cell({ r: i, c: 0 })] = {
                v: result["HospitalID"],
                s: { border: border, fill: fill },
              };
              worksheet[XLSX.utils.encode_cell({ r: i, c: 2 })] = {
                v: result["Code"],
                s: { border: border, fill: fill },
              };
              worksheet[XLSX.utils.encode_cell({ r: i, c: 1 })] = {
                v: result["Name"],
                s: { border: border, fill: fill },
              };
            }

            result[sheetName] = XLSX.utils.sheet_to_json(worksheet);
          });

          var wopts = { bookType: "xlsx", type: "buffer" };
          var wbout = XLSX.write(workbook, wopts);
          res.setHeader(
            "Content-disposition",
            "attachment; filename=" +
              `test.xlsx`
          );
          res.setHeader(
            "Content-type",
            "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
          );
          res.charset = "UTF-8";
          res.write(wbout, "binary");
          res.end(null, "binary");

I have my project running xlsx with this issues. The biggest and most problematic of these is the fact that whenever I save my workbook and then attempt to open it. I get this problem: ![image](/attachments/b5fae212-7cce-41f0-8ac1-a41686dbb7c0) ``` var workbook = XLSX.readFile( `./templates/test.xlsx`, { cellHTML: true, cellStyles: true, cellDates: true, cellNF: false, cellText: false, } ); var sheetNames = workbook.SheetNames; workbook.SheetNames.forEach(function (sheetName) { var worksheet = workbook.Sheets[sheetName]; for (var i = 1; i <= 100; i++) { var border = { top: { style: "thin", color: "FF000000" }, right: { style: "thin", color: "FF000000" }, bottom: { style: "thin", color: "FF000000" }, left: { style: "thin", color: "FF000000" }, }; var fill = { patternType: "solid", // none / solid fgColor: { rgb: "FFC0C0C0" }, // bgColor: {rgb: "FFC0C0C0"} }; worksheet[XLSX.utils.encode_cell({ r: i, c: 0 })] = { v: result["HospitalID"], s: { border: border, fill: fill }, }; worksheet[XLSX.utils.encode_cell({ r: i, c: 2 })] = { v: result["Code"], s: { border: border, fill: fill }, }; worksheet[XLSX.utils.encode_cell({ r: i, c: 1 })] = { v: result["Name"], s: { border: border, fill: fill }, }; } result[sheetName] = XLSX.utils.sheet_to_json(worksheet); }); var wopts = { bookType: "xlsx", type: "buffer" }; var wbout = XLSX.write(workbook, wopts); res.setHeader( "Content-disposition", "attachment; filename=" + `test.xlsx` ); res.setHeader( "Content-type", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" ); res.charset = "UTF-8"; res.write(wbout, "binary"); res.end(null, "binary"); ```

image.png

10 KiB

sheetjs commented

2024-03-26 07:43:30 +00:00

https://docs.sheetjs.com/docs/demos/net/server/express you should only need:

var wbout = XLSX.write(workbook, wopts);
res.attachment("test.xlsx");
res.status(200).end(wbout);

Please confirm you are using the latest version of the library. Review the installation notes https://docs.sheetjs.com/docs/getting-started/installation/nodejs . If this issue still affects the latest version, please share the generated file and we can reopen the issue.

https://docs.sheetjs.com/docs/demos/net/server/express you should only need: ```js var wbout = XLSX.write(workbook, wopts); res.attachment("test.xlsx"); res.status(200).end(wbout); ``` Please confirm you are using the latest version of the library. Review the installation notes https://docs.sheetjs.com/docs/getting-started/installation/nodejs . If this issue still affects the latest version, please share the generated file and we can reopen the issue.

sheetjs closed this issue

2024-03-26 07:43:31 +00:00

felix0110 commented

2024-03-26 08:02:23 +00:00

https://docs.sheetjs.com/docs/demos/net/server/express you should only need:
var wbout = XLSX.write(workbook, wopts);
res.attachment("test.xlsx");
res.status(200).end(wbout); 
Please confirm you are using the latest version of the library. Review the installation notes https://docs.sheetjs.com/docs/getting-started/installation/nodejs . If this issue still affects the latest version, please share the generated file and we can reopen the issue.

The version is the latest version 0.18.5.

Even i change as follow, the same error occurs.

var wbout = XLSX.write(workbook, wopts);
res.attachment("test.xlsx");
res.status(200).end(wbout);

> https://docs.sheetjs.com/docs/demos/net/server/express you should only need: > > ```js > var wbout = XLSX.write(workbook, wopts); > res.attachment("test.xlsx"); > res.status(200).end(wbout); > ``` > > Please confirm you are using the latest version of the library. Review the installation notes https://docs.sheetjs.com/docs/getting-started/installation/nodejs . If this issue still affects the latest version, please share the generated file and we can reopen the issue. The version is the latest version 0.18.5. Even i change as follow, the same error occurs. ``` var wbout = XLSX.write(workbook, wopts); res.attachment("test.xlsx"); res.status(200).end(wbout); ```

Sign in to join this conversation.