https://community.blueprism.com/t5/University-Forum/Is-it-possible-to-leave-an-entire-column-blank-in-the-collection/m-p/97707#M3249 <P class="MsoNormal">Hi,</P> <P class="MsoNormal"><SPAN lang="EN-US">I am working on use case where I need to collect data from excel file and to store in a collection properties. After that, I need to check the "Result" column. If there is any value, I need to make it clear or blank. If anyone can provide any solution, it would be a great support.</SPAN></P> <P class="MsoNormal"><SPAN lang="EN-US"></SPAN></P> <P class="MsoNormal"><SPAN lang="EN-US">I have one idea. To Create another macro excel file and to run the macro file using Blue Prism to make the cell in excel file blank. But I am looking for a solution where I can make the result column blank from collection properties.&nbsp;<SPAN>&nbsp;</SPAN></SPAN></P> <P class="MsoNormal"><SPAN lang="EN-US"><span class="lia-inline-image-display-wrapper" image-alt="35532.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/37429i64C8FA5567F072FB/image-size/large?v=v2&amp;px=999" role="button" title="35532.png" alt="35532.png" /></span></SPAN></P> <P class="MsoNormal"><SPAN><BR /></SPAN><SPAN lang="EN-US"></SPAN></P> <P class="MsoNormal"><SPAN lang="EN-US"></SPAN></P> Wed, 03 May 2023 14:21:26 GMT Anonymous 2023-05-03T14:21:26Z https://community.blueprism.com/t5/University-Forum/Is-it-possible-to-leave-an-entire-column-blank-in-the-collection/m-p/97707#M3249 <P class="MsoNormal">Hi,</P> <P class="MsoNormal"><SPAN lang="EN-US">I am working on use case where I need to collect data from excel file and to store in a collection properties. After that, I need to check the "Result" column. If there is any value, I need to make it clear or blank. If anyone can provide any solution, it would be a great support.</SPAN></P> <P class="MsoNormal"><SPAN lang="EN-US"></SPAN></P> <P class="MsoNormal"><SPAN lang="EN-US">I have one idea. To Create another macro excel file and to run the macro file using Blue Prism to make the cell in excel file blank. But I am looking for a solution where I can make the result column blank from collection properties.&nbsp;<SPAN>&nbsp;</SPAN></SPAN></P> <P class="MsoNormal"><SPAN lang="EN-US"><span class="lia-inline-image-display-wrapper" image-alt="35532.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/37429i64C8FA5567F072FB/image-size/large?v=v2&amp;px=999" role="button" title="35532.png" alt="35532.png" /></span></SPAN></P> <P class="MsoNormal"><SPAN><BR /></SPAN><SPAN lang="EN-US"></SPAN></P> <P class="MsoNormal"><SPAN lang="EN-US"></SPAN></P> Wed, 03 May 2023 14:21:26 GMT https://community.blueprism.com/t5/University-Forum/Is-it-possible-to-leave-an-entire-column-blank-in-the-collection/m-p/97707#M3249 Anonymous 2023-05-03T14:21:26Z https://community.blueprism.com/t5/University-Forum/Is-it-possible-to-leave-an-entire-column-blank-in-the-collection/m-p/97708#M3250 <P>Hi Ekram- Please find the the answered thread here : <A href="https://community.blueprism.com/question/is-it-possible-to-leave-an-entire-column-blank-in-the-collection-properties-1" target="test_blank">https://community.blueprism.com/question/is-it-possible-to-leave-an-entire-column-blank-in-the-collection-properties-1</A><BR /><BR />Regards,<BR />Mukesh</P> Wed, 03 May 2023 15:40:16 GMT https://community.blueprism.com/t5/University-Forum/Is-it-possible-to-leave-an-entire-column-blank-in-the-collection/m-p/97708#M3250 Mukeshh_k 2023-05-03T15:40:16Z