Border is missing during Excel Document Generation using the Server SDK.

Technical Support
,
1

Product: Server SDK (@pdftron/pdfnet-node)

Product Version: 11.3.0

If you use {{loop}}} to create an Excel Document using JSON data in the Server SDK, the Cell Style (edge, cell background color) of the sheet is not applied, is there a way to apply it? If you use loop, the Cell Style is applied normally.

1 Like
2

Hello,

Thank you for reaching out to us about this behavior. I’m not seeing what could be your issue from the existing details you have provided.

Can you please provide for me the template you are using, the JSON data you are supplying, and the current output file you are getting?

If this content is sensitive to your team, please email this to our support team privately to the email support@apryse.com and include this post in your email.

Thanks,

1 Like
3

Hello,

Thank you for your cooperation.

The first file(excel_sample.xlsx) is the template used and the second file(excel_sample.pdf) is the result.

excel_sample.xlsx (10.4 KB)
excel_sample.pdf (29.9 KB)

const { PDFNet } = require('@pdftron/pdfnet-node');
const PDFTronLicense = require('../LicenseKey/LicenseKey');

((exports) => {
  'use strict';

  exports.runOfficeTemplateTest = () => {

    const inputPath = '../TestFiles/';
    const outputPath = inputPath + 'Output/';
    const inputFilename = 'excel_sample.xlsx'
    const outputFilename = 'excel_sample.pdf'

    const main = async () => {

      PDFNet.addResourceSearchPath('../Resources');

      try {
        const options = new PDFNet.Convert.OfficeToPDFOptions();

        
        options.setApplyPageBreaksToSheet(true);
        options.setDisplayHiddenText(false)
        options.setTemplateStrictMode(true)
        
        const json = JSON.stringify({
          'sortation': "구분",
          'bp_name': "BP Name",
          'bp_label': "BP Label",
          'remark': "Remark",        
          "looptest2": [
            {
              'name': "a",
              'age': "b",
              'address': "c",       
              'remark': "d"       
            },        
            {
              'name': "a",
              'age': "b",
              'address': "c",     
              'remark': "d"                
            },        
            {
              'name': "a",
              'age': "b",
              'address': "c",     
              'remark': "d"                
            },                  
          ],
          
        });

        // Create a TemplateDocument object from an input office file.
        const templateDoc = await PDFNet.Convert.createOfficeTemplateWithPath(inputPath + inputFilename, options);
        
        

        // Fill the template with data from a JSON string, producing a PDF document.
        const pdfdoc = await templateDoc.fillTemplateJson(json);

        // Save the PDF to a file.
        await pdfdoc.save(outputPath + outputFilename, PDFNet.SDFDoc.SaveOptions.e_linearized);

        const buffer = await pdfdoc.saveMemoryBuffer(PDFNet.SDFDoc.SaveOptions.e_linearized)

        // And we're done!
        console.log('Saved ' + outputFilename, buffer);

      } catch (err) {
        console.log(err);
      }

      console.log('Done.');
    };

    PDFNet.runWithCleanup(main, PDFTronLicense.Key).catch(function (error) {
      console.log('Error: ' + JSON.stringify(error));
    }).then(function () { return PDFNet.shutdown(); });

  };
  exports.runOfficeTemplateTest();
})(exports);

Thanks.

1 Like
4

Hello,

Thank you for providing this. I don’t believe the behavior you are seeing is working as intended. The cell background color should be retained when creating the PDF file. I have reported this as an issue to our development team. I will keep you posted on a fix as I hear back from our team.

Thanks,

2 Likes
5

Our development team has provided a fix resolving the missing cell color seen here. Can you please try the latest versions of PDFNet, and see if that corrects the issue for you?

Latest official: Download PDF Library for Windows, Mac and Linux including options for .NET, Node.js, Go, Java, C/C++, C#, Ruby, Python | Apryse documentation

Release channel: Apryse Developer Portal

Developer channel: Apryse Developer Portal

Latest official builds, and Release channel, are ready for production usage, however the developer channel builds are experimental and do not get the same amount of testing and can be in a state of change.

1 Like