Formatting excel and add headers based on conditions

[Amol_Golhar]

Dear Team,

I have Input Excel As Below,

Expected formatting for the excel,
I am Writing this Datatables by using for each loop, in current case there are 2 tables, it may be n no. of tables with n no. of records.

Condition 1 –
If Party Name=“Total Amt Recieved” Then highlight the values in Columns “Amt in INR” and “Amt in USD”

Condition 2 –
Highlight, Bold the Headers and Add the headers for each table.

Condition 3 –
All Borders for filled till the filled rows.

Thanks & Regards,
Amol Golhar

[Anil_G (Anil Gorthi)]

@Amol_Golhar

Use format cells activity for the same…

Seqrch for party name and then bold the values of complete row using format cells

Similarly loop through the rows and check for condition as you need and if met use format cell and format the color of required cell using format cells again

Cheers

[Sharath_HK (Sharath Keshavamurthy)]

Hi @Amol_Golhar ,

you can refer to the below link for more details:

Activities - Format Cells

[Amol_Golhar]

Dear Anil,

I am able fromat the cells. Thanks for the help.

I have a one more query, how to Add headers in the excel for the specific rows.
Like in this case i am adding tables one by one in the downside by using For Each Loop.
How we can add headers for each table.

Regards,
Amol Golhar

[Anil_G (Anil Gorthi)]

@Amol_Golhar

In the table if headers are there then while writing range just tick add headers

if no …then before start of every new table…just add a dummy tbale with only headers as first row and add it before the new table

cheers