Write range with same format in uipath

[SURESH_P]

Hi All,

Thanks in advance…!

How to write range activity using in UiPath with format from excel

Like Excel having data with format but using write range output will be without format. I require the same with format

[supermanPunch (Arpan)]

@SURESH_P

Like Excel having data with format but using write range output will be without format.

Hi @SURESH_P ,

We usually prepare the Excel Templates (Formatting +headers as is and empty the rows) before hand and then write the data to that template file (Or a Copy of the Template renamed to required file name) from the second row onwards.

Is this something that could be checked from your end and let us know if it is a feasible approach for your case?

If not, let us know what is the challenge and maybe we would require to check with VBA Codes.

Also, Maybe the Format Cells activity could be checked as well, if the data is less.
Some examples using the Activity :

How to format cells based on their value (ie negative numbers in red)

This was done using UiPath.Excel.Activities 2.16.2 - it may work with older versions, I don’t know when these activities were introduced. It likely works with newer versions also. This particular code I’m showing sets negative numbers to red, but you could of course also put a Format Cells activity into the Then block to format positive numbers green, for example. Basic steps: Excel Process Scope Use Excel File – For Each Excel Row — If to determine positive or negative ---- Format Cell…

[Anil_G (Anil Gorthi)]

@SURESH_P

one way to acheive is…first use copy paste range activity and paste the first row till where you need

then use write range activity from workbook…it would retain the formats

Alternate approaches are present as well…

cheers

[jack.chan]

in your excel template, do the following

1. right click column, click format cells, then select Text and click OK
   

   

2. highlight the same column then click Data->text to columns,
   under column data format select Text

3. now everything you write in that column will be in text format hence same format
   

4. you need to repeat this for other columns where the format is not the same.

you can try my component

Excel Activities for Processing and Filtering - RPA Component | UiPath...

use this function, it lets you apply the above steps for one or more columns

[Kartheek_Battu]

Hello @SURESH_P

1. Use the “Excel Application Scope” activity to open your Excel file (set “Visible” to “False” to make it run in the background).
2. Within the “Excel Application Scope,” use the “Write Range” activity to write your data to the Excel sheet.
3. In the “Write Range” activity, set “PreserveFormat” to “True” to ensure that the formatting in your data is retained in the output Excel file.

Thanks & Cheers!!!