topic Re: How to Take Excel sheet screenshot using BluePrism in Product Forum

topic Re: How to Take Excel sheet screenshot using BluePrism in Product Forum https://community.blueprism.com/t5/Product-Forum/How-to-Take-Excel-sheet-screenshot-using-BluePrism/m-p/121381#M53407 <P>To take a screenshot, you can build a quick Screenshot utility.</P><P>Refer to this <A href="https://community.blueprism.com/t5/Product-Forum/Procedure-to-take-screenshot/td-p/90384/page/2" target="_self">thread</A> for the same.</P> Wed, 09 Jul 2025 06:01:05 GMT Tejaskumar_Darji 2025-07-09T06:01:05Z How to Take Excel sheet screenshot using BluePrism https://community.blueprism.com/t5/Product-Forum/How-to-Take-Excel-sheet-screenshot-using-BluePrism/m-p/121377#M53405 <P>Hi Team,</P><P>We have a requirement to take Excel sheet body screenshot.</P><P>If anyone worked on this type of requirement. Please share your thoughts here.</P><P>we tried to use global send keys (send hot keys) but, didn't get any result</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AbhiChattar_1-1751998115829.png" style="width: 400px;"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/41167i39C0DA52A0B64A39/image-size/medium/is-moderation-mode/true?v=v2&px=400" role="button" title="AbhiChattar_1-1751998115829.png" alt="AbhiChattar_1-1751998115829.png" /></span></P><P>Above image is for reference , we want like this screenshot.</P><P>Thanks.</P><P> </P> Tue, 08 Jul 2025 18:10:10 GMT https://community.blueprism.com/t5/Product-Forum/How-to-Take-Excel-sheet-screenshot-using-BluePrism/m-p/121377#M53405 Abhi-Chattar 2025-07-08T18:10:10Z Re: How to Take Excel sheet screenshot using BluePrism https://community.blueprism.com/t5/Product-Forum/How-to-Take-Excel-sheet-screenshot-using-BluePrism/m-p/121381#M53407 <P>To take a screenshot, you can build a quick Screenshot utility.</P><P>Refer to this <A href="https://community.blueprism.com/t5/Product-Forum/Procedure-to-take-screenshot/td-p/90384/page/2" target="_self">thread</A> for the same.</P> Wed, 09 Jul 2025 06:01:05 GMT https://community.blueprism.com/t5/Product-Forum/How-to-Take-Excel-sheet-screenshot-using-BluePrism/m-p/121381#M53407 Tejaskumar_Darji 2025-07-09T06:01:05Z Re: How to Take Excel sheet screenshot using BluePrism https://community.blueprism.com/t5/Product-Forum/How-to-Take-Excel-sheet-screenshot-using-BluePrism/m-p/121394#M53411 <P>Hi <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/64129">@Abhi-Chattar</a> <BR /><BR />Please find the below custom code for taking screenshot of specified range from excel,</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SayeedBinAbdullah_4-1752046804169.png" style="width: 400px;"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/41175i504EC03AFF37C53B/image-size/medium/is-moderation-mode/true?v=v2&px=400" role="button" title="SayeedBinAbdullah_4-1752046804169.png" alt="SayeedBinAbdullah_4-1752046804169.png" /></span></P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SayeedBinAbdullah_0-1752046556131.png" style="width: 400px;"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/41171iBA1B1ACFE673EBF1/image-size/medium/is-moderation-mode/true?v=v2&px=400" role="button" title="SayeedBinAbdullah_0-1752046556131.png" alt="SayeedBinAbdullah_0-1752046556131.png" /></span></P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SayeedBinAbdullah_3-1752046723876.png" style="width: 400px;"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/41174i940FB697D351BA04/image-size/medium/is-moderation-mode/true?v=v2&px=400" role="button" title="SayeedBinAbdullah_3-1752046723876.png" alt="SayeedBinAbdullah_3-1752046723876.png" /></span></P><P><U><STRONG>Code To Paste as action in Excel VBO</STRONG></U></P><DIV><process name="__selection__MS Excel VBO - Extended" type="object"></DIV><DIV>  <subsheet subsheetid="79c86942-907e-49a6-b9ba-81f9983ee3d4" type="Normal" published="True"></DIV><DIV>    <name>Take Screenshot of Worksheet</name></DIV><DIV>    <view></DIV><DIV>      <camerax>-157</camerax></DIV><DIV>      <cameray>-11</cameray></DIV><DIV>      <zoom version="2">1.25</zoom></DIV><DIV>    </view></DIV><DIV>  </subsheet></DIV><DIV>  <stage stageid="126e45cc-1e0a-4990-9e87-e1b3c08abaf9" name="Take Screenshot of Worksheet" type="SubSheetInfo"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <loginhibit onsuccess="true" /></DIV><DIV>    <display x="-255" y="-150" w="150" h="90" /></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="a6b1d797-c9ef-4970-aedd-3362caade9b2" name="Start" type="Start"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <loginhibit onsuccess="true" /></DIV><DIV>    <display x="-60" y="-180" /></DIV><DIV>    <inputs></DIV><DIV>      <input type="text" name="Workbook Name" narrative="The name of the workbook in which the sheet exists." stage="Workbook name" /></DIV><DIV>      <input type="text" name="Worksheet Name" narrative="The name of the sheet which should be activated." stage="Worksheet name" /></DIV><DIV>      <input type="number" name="handle" narrative="The integer handle identifying the instance on which the worksheet which should be activated resides. " stage="handle" /></DIV><DIV>      <input type="text" name="Cell reference" stage="Cellref" /></DIV><DIV>      <input type="text" name="Image Path" stage="outputPath" /></DIV><DIV>      <input type="text" name="Range" stage="excel_range" /></DIV><DIV>    </inputs></DIV><DIV>    <onsuccess>f590d27f-4248-44ed-9115-99146bd7ded7</onsuccess></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="f590d27f-4248-44ed-9115-99146bd7ded7" name="Screenshot of Worksheet" type="Code"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <loginhibit onsuccess="true" /></DIV><DIV>    <display x="-60" y="-105" /></DIV><DIV>    <inputs></DIV><DIV>      <input type="text" name="Workbookname" expr="[Workbook name]" /></DIV><DIV>      <input type="text" name="Worksheetname" expr="[Worksheet name]" /></DIV><DIV>      <input type="flag" name="Createifmissing" expr="[createifmissing]" /></DIV><DIV>      <input type="number" name="handle" expr="[handle]" /></DIV><DIV>      <input type="text" name="excel_range" expr="[excel_range]" /></DIV><DIV>      <input type="text" name="outputPath" expr="[outputPath]" /></DIV><DIV>    </inputs></DIV><DIV>    <outputs></DIV><DIV>      <output type="flag" name="Success" stage="Success" /></DIV><DIV>      <output type="text" name="Message" stage="Message" /></DIV><DIV>      <output type="flag" name="sheetexists" stage="sheetexists" /></DIV><DIV>    </outputs></DIV><DIV>    <onsuccess>f058cc41-b545-4a0d-b0da-44866911aa34</onsuccess></DIV><DIV>    <code><![CDATA[Dim ws as Object = GetWorksheet(handle,workbookname,worksheetname,createifmissing)</DIV><DIV>sheetexists = ws IsNot Nothing </DIV><DIV> </DIV><DIV>Try</DIV><DIV> </DIV><DIV>If sheetexists then </DIV><DIV>ws.Activate()</DIV><DIV>Dim range As Microsoft.Office.Interop.Excel.Range = CType(ws.Range(excel_range), Microsoft.Office.Interop.Excel.Range)</DIV><DIV> </DIV><DIV> </DIV><DIV>        ' Copy as picture to clipboard</DIV><DIV>range.CopyPicture(Excel.XlPictureAppearance.xlScreen, Excel.XlCopyPictureFormat.xlBitmap)</DIV><DIV> </DIV><DIV>        ' Wait for clipboard to be populated</DIV><DIV>        Threading.Thread.Sleep(1000)</DIV><DIV> </DIV><DIV>        If Clipboard.ContainsImage() Then</DIV><DIV>            Dim img As Image = Clipboard.GetImage()</DIV><DIV>            img.Save(outputPath, Imaging.ImageFormat.Png)</DIV><DIV>        End If</DIV><DIV>End If</DIV><DIV>            Success = True</DIV><DIV> </DIV><DIV>Catch e As Exception</DIV><DIV><SPAN>Success = False</SPAN></DIV><DIV><SPAN>Message = e.Message</SPAN></DIV><DIV>End Try]]></code></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="299d3901-a2f2-4887-b883-ee0689cf903c" name="Workbook name" type="Data"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <loginhibit onsuccess="true" /></DIV><DIV>    <display x="-300" y="-15" w="120" h="30" /></DIV><DIV>    <datatype>text</datatype></DIV><DIV>    <initialvalue /></DIV><DIV>    <private /></DIV><DIV>    <alwaysinit /></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="4e31a3db-9a9d-4752-8505-2eb29de13e80" name="Worksheet name" type="Data"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <loginhibit onsuccess="true" /></DIV><DIV>    <display x="-300" y="15" w="120" h="30" /></DIV><DIV>    <datatype>text</datatype></DIV><DIV>    <initialvalue /></DIV><DIV>    <private /></DIV><DIV>    <alwaysinit /></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="ddd8738d-0a4e-4e09-b943-e8e137cabdae" name="Cellref" type="Data"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <loginhibit onsuccess="true" /></DIV><DIV>    <display x="-300" y="135" w="120" h="30" /></DIV><DIV>    <datatype>text</datatype></DIV><DIV>    <initialvalue /></DIV><DIV>    <private /></DIV><DIV>    <alwaysinit /></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="2850c03d-80a6-4d7b-a281-acd4e9470c4e" name="Image" type="Data"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <loginhibit onsuccess="true" /></DIV><DIV>    <display x="-300" y="45" w="120" h="30" /></DIV><DIV>    <datatype>text</datatype></DIV><DIV>    <initialvalue /></DIV><DIV>    <private /></DIV><DIV>    <alwaysinit /></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="3e318712-b5b7-4fb0-a567-c41ab41f670f" name="createifmissing" type="Data"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <loginhibit onsuccess="true" /></DIV><DIV>    <display x="-300" y="75" w="120" h="30" /></DIV><DIV>    <datatype>flag</datatype></DIV><DIV>    <initialvalue>False</initialvalue></DIV><DIV>    <private /></DIV><DIV>    <alwaysinit /></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="5260124a-e9ca-42c0-8829-b5ef11978493" name="handle" type="Data"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <loginhibit onsuccess="true" /></DIV><DIV>    <display x="-300" y="105" w="120" h="30" /></DIV><DIV>    <datatype>number</datatype></DIV><DIV>    <initialvalue /></DIV><DIV>    <private /></DIV><DIV>    <alwaysinit /></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="8106969e-bdfb-4a93-b844-48ce34580dc1" name="sheetexists" type="Data"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <loginhibit onsuccess="true" /></DIV><DIV>    <display x="-165" y="-15" w="120" h="30" /></DIV><DIV>    <datatype>flag</datatype></DIV><DIV>    <initialvalue /></DIV><DIV>    <private /></DIV><DIV>    <alwaysinit /></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="f058cc41-b545-4a0d-b0da-44866911aa34" name="End" type="End"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <loginhibit onsuccess="true" /></DIV><DIV>    <display x="-60" y="-15" /></DIV><DIV>    <font family="Tahoma" size="10" style="Regular" color="000000" /></DIV><DIV>    <outputs></DIV><DIV>      <output type="flag" name="Success" stage="Success" /></DIV><DIV>      <output type="text" name="Message" stage="Message" /></DIV><DIV>    </outputs></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="b65c9c94-75c3-468f-a973-c71d85c4464a" name="excel_range" type="Data"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <display x="-165" y="15" w="120" h="30" /></DIV><DIV>    <datatype>text</datatype></DIV><DIV>    <initialvalue /></DIV><DIV>    <private /></DIV><DIV>    <alwaysinit /></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="15ed13d2-b4b6-4961-8ed1-4d8799aedc89" name="outputPath" type="Data"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <loginhibit /></DIV><DIV>    <display x="-165" y="45" w="120" h="30" /></DIV><DIV>    <datatype>text</datatype></DIV><DIV>    <initialvalue /></DIV><DIV>    <private /></DIV><DIV>    <alwaysinit /></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="eb89ed27-cbb0-4516-a3d8-2814e8bde85f" name="Success" type="Data"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <display x="15" y="-105" /></DIV><DIV>    <datatype>flag</datatype></DIV><DIV>    <initialvalue /></DIV><DIV>    <private /></DIV><DIV>    <alwaysinit /></DIV><DIV>  </stage></DIV><DIV>  <stage stageid="8c56773d-cad8-4a9b-94b8-75e50ad815a7" name="Message" type="Data"></DIV><DIV>    <subsheetid>79c86942-907e-49a6-b9ba-81f9983ee3d4</subsheetid></DIV><DIV>    <display x="90" y="-105" /></DIV><DIV>    <datatype>text</datatype></DIV><DIV>    <initialvalue /></DIV><DIV>    <private /></DIV><DIV>    <alwaysinit /></DIV><DIV>  </stage></DIV><DIV></process></DIV><DIV> </DIV><DIV>Best Regards,</DIV><DIV>Sayeed Bin Abdullah</DIV> Wed, 09 Jul 2025 07:41:36 GMT https://community.blueprism.com/t5/Product-Forum/How-to-Take-Excel-sheet-screenshot-using-BluePrism/m-p/121394#M53411 SayeedBinAbdullah 2025-07-09T07:41:36Z