Read Range /Write range convert string with " ' " character

[Raghavendraprasad (Raghavendraprasad Bhat)]

For you to copy over formulas in excel here are many workarounds and solutions through code, activities and hot keys are suggested. check the following links.

Copy and paste formulas

I want to copy a formula to a range of cells. The range of cells changes with each iteration of the robot by copying a row and insert copied cells. I have a defined name for the cell that I want to ctrl-c and a named range that moves with the insert. My problem is I haven’t found a way to get the robot to make either name “current”. I don’t find a select range, goto range or similar. Maybe I need to go through the menus to use goto? sort of answering my own question but it would sure mak…

Write formula in excel

I think there is a problem in your formula. [image] Using write cell you can set the value to a valid formula.

How to copy formula to the whole column

Hi @jibanjyoti i posted one question https://forum.uipath.com/t/how-to-search-specific-values-in-whole-excel-sheet/7862 can you please help on this. thank you

Fastest way to write an excel formula into an entire column

Hello folks, My requirement is to generate the Excel report every day. My doubt is once the execution is finished the excel row counter will back to its default value. If execution starts again on tommorow how does it know it should write the cell value in A4 or A5 etc. Could some suggest on the same

Hope this helps
Regards