Skip to main content
New Participant
Nov 21, 2023 11:18 AM UTC
Question

Need headers row color for Excel Document using Export Data Store Entity to Excel Smart Service

Hi,

I Need to Generate a new excel document using Export Data Store Entity to Excel Smart Service.

How can we generate a new document with headers colored ??

Can we add color to a cell using Parameters: custom cell position and custom cell values, if yes how??

    4 replies

    annap0005
    Participating Frequently
    Nov 23, 2023 6:21 AM UTC

    You can create the template with whatever formatting(headers color) you required and use documentToUpdate:cons!XXX_DOC, includeHeader :false(),
    startingCell:"A2"  parameters

    New Participant
    Nov 23, 2023 7:25 AM UTC

    Hi Anna , 

    But it updates the same document, I need a new document generated with formatted headers whenever the smart service is Triggered

    annap0005
    Participating Frequently
    Nov 23, 2023 10:21 AM UTC

    you can use copy document smart service.. copy that use in export plugin.

    prakhars0731
    Inspiring
    Nov 23, 2023 9:45 AM UTC

    In the smart service datastoreentity to excel  has new document properties you can use that I have attached ss for that.