Hi Everyone
Im reconciling data from other excel, after one transaction is reconclied , i do total and average of this transactio, after i do this, i need to color it with this color for summary row, then add one empty row of this color. How do i do this in UiPath.
After using Append Range, read the Excel data to get the last used row. Insert a new row at dt.Rows.Count + 1 to create an empty row. Then apply the required background color to that row using Set Range Color activity. This ensures colored row is added immediately after the appended data.
This coloring, somehow i tweaked it works, but when i next append, that colored row is empty. Its writing from that colored, i want bot to write i.e append datatable from next line…
How to fix this ?
you can read range, then get count of rows, then increment row by 1. Then use this range cell address to write data using write range range and give cell address , updated cell address. hope it helps.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
