Skip to main content
A
aswink0004
November 21, 2023
Question

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

  • November 21, 2023
  • 4 replies
  • 0 views

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
    annap0005
    November 23, 2023

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

    A
    aswink0004Author
    November 23, 2023

    Hi Anna , 

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

    annap0005
    annap0005
    November 23, 2023

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

    prakhars0731
    prakhars0731
    November 23, 2023

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

    Terms & ConditionsAccessibility statement