Formatting the multiple output excel files

Question

Hi ,

Could someone help me with formatting ( as a proper table, heading highlighted color ) the 6 multiple sheets which i get in output.

i have attached the work flow where i'm getting 6 multiple output as separate sheets. i have used block until done to write as 6 separate sheets one after another.

i have attached my OUTPUT as well along with Workflow.

Fuel Verification - After T.yxmd

Fuel Verification after T Template.xlsx

snavee16 · Answer

Hi Sir,

Attached the format in output data which i' looking for.

Basically what i need is my output data should have the below things.

1. Header bold

2.Header color.

3. Term "CHECK" in price & Gallon Mismatch should be highlighted in RED color.

Price & Gallon Match.PNG

Price & Gallon MisMatch.PNG

Workflow.PNG

danilang · Answer

hi @snavee16

I think you forgot to attach the input files for your workflow.

Also, your output template has no formatting.  It's only data.  Can you provide a sample of the formatted output that you're looking for.

Dan