https://community.blueprism.com/t5/Product-Forum/How-to-duplicate-worksheet-in-excel-with-out-spying/m-p/44370#M861 Hello,<BR /><BR />How to duplicate worksheets with out spying the&nbsp;<BR /><BR />I have a worksheet with lot of conidtional formating and have different color with out reading and writing is there way we can exactly duplicate the worksheet but with out spying?<BR /><BR />------------------------------<BR />Harish Mogulluri<BR />developer<BR />Ics<BR />America/New_York<BR />------------------------------<BR /> Mon, 15 Nov 2021 06:19:00 GMT harish.mogulluri 2021-11-15T06:19:00Z https://community.blueprism.com/t5/Product-Forum/How-to-duplicate-worksheet-in-excel-with-out-spying/m-p/44370#M861 Hello,<BR /><BR />How to duplicate worksheets with out spying the&nbsp;<BR /><BR />I have a worksheet with lot of conidtional formating and have different color with out reading and writing is there way we can exactly duplicate the worksheet but with out spying?<BR /><BR />------------------------------<BR />Harish Mogulluri<BR />developer<BR />Ics<BR />America/New_York<BR />------------------------------<BR /> Mon, 15 Nov 2021 06:19:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-duplicate-worksheet-in-excel-with-out-spying/m-p/44370#M861 harish.mogulluri 2021-11-15T06:19:00Z https://community.blueprism.com/t5/Product-Forum/How-to-duplicate-worksheet-in-excel-with-out-spying/m-p/44371#M862 Hello Harish,<BR /><BR />you can use below action from ms excel VBO, it will create a copy of the worksheet, later you can rename the duplicate sheet as required.<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="19858.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/20005i27BA1C107538672F/image-size/large?v=v2&amp;px=999" role="button" title="19858.png" alt="19858.png" /></span><BR /><BR />------------------------------<BR />MuraliKrishna<BR />Senior Consultant - Automation Developer<BR />------------------------------<BR /> Mon, 15 Nov 2021 06:28:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-duplicate-worksheet-in-excel-with-out-spying/m-p/44371#M862 krishna.kodimurali9 2021-11-15T06:28:00Z https://community.blueprism.com/t5/Product-Forum/How-to-duplicate-worksheet-in-excel-with-out-spying/m-p/44372#M863 Thank you. I didn't notice that action.so I have one another question can we highlight ( some color)&nbsp; cell in excel? With out spying?<BR /><BR />------------------------------<BR />Harish Mogulluri<BR />developer<BR />Ics<BR />America/New_York<BR />------------------------------<BR /> Mon, 15 Nov 2021 14:19:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-duplicate-worksheet-in-excel-with-out-spying/m-p/44372#M863 harish.mogulluri 2021-11-15T14:19:00Z https://community.blueprism.com/t5/Product-Forum/How-to-duplicate-worksheet-in-excel-with-out-spying/m-p/44373#M864 <SPAN style="color: #000080;">Hi Harish,</SPAN><BR /><BR /><SPAN style="color: #000080;">You can achieve the highlighting of cells in multiple ways. If you have the excel file ready as a template you can perhaps set the conditional formatting rules in the excel file directly. As you keep populating the cells in the excel file from Blue Prism process, the cells will get highlighted automatically based on the conditional formatting rule that have set previously.</SPAN><BR /><BR /><SPAN style="color: #000080;">If you want to dynamically set the cell color, extend the Excel VBO capability by creating an additional action using code stage with below parameters and code:</SPAN><BR /><BR /><SPAN style="color: #800000;"><STRONG>Input:</STRONG></SPAN><BR /><BR /><SPAN style="color: #000080;">handle : The current excel instance that holds you excel session.</SPAN><BR /><SPAN style="color: #000080;">row_reference : The row number of the cell that you want to highlight.</SPAN><BR /><SPAN style="color: #000080;">column_reference: The column number of the cell that you want to highlight.</SPAN><BR /><SPAN style="color: #000080;">red_value: The value of the Red tone pixel ranging from 0 to 255.</SPAN><BR /><SPAN style="color: #000080;">green_value: The value of the Green tone pixel ranging from 0 to 255.</SPAN><BR /><SPAN style="color: #000080;">blue_value: The value of the Blue tone pixel ranging from 0 to 255.</SPAN><BR /><BR /><SPAN style="color: #800000;"><STRONG>Code:</STRONG></SPAN><BR /><BR /><SPAN><CODE>GetWorkbook(handle,Nothing).ActiveSheet.Cells(row_reference,column_reference).Interior.Color = RGB(red_value, green_value, blue_value)</CODE><BR /><BR /><BR /></SPAN><SPAN style="color: #000080;">Before using this code use the keep the excel handle activated by using Create Instance, Open Instance or Attach activity and open your desired workbook and activate the worksheet where you want to perform this operation. Depending on your use case and logic you can either call this action once or maybe in a loop as per some condition that you want to set for highlighting by passing dynamic row and column number for the cells.</SPAN><BR /><BR />------------------------------<BR />Regards,<BR />Devneet Mohanty<BR />Intelligent Automation Consultant<BR />Blueprism 6x Certified Professional<BR />Website: <A href="https://devneet.github.io/" target="test_blank">https://devneet.github.io/</A><BR />Email: devneetmohanty07@gmail.com<BR />------------------------------<BR /> Tue, 16 Nov 2021 04:11:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-duplicate-worksheet-in-excel-with-out-spying/m-p/44373#M864 devneetmohanty07 2021-11-16T04:11:00Z