https://community.blueprism.com/t5/Product-Forum/Failed-to-copy-and-paste-in-excel-sheet/m-p/60288#M13770 <P>I am getting below error while running Blue Prism code, actually i am filtering duplicate and Unique value from Main excel sheet and pasting to another excel, how ever it is running fine in Debug mode. but getting errror while running the process using Blue Prism Desktop. Any help or suggestion to fix this issue.</P> <P></P> <P><STRONG>Error : Failed to copy worksheet: Current thread must be set to single thread apartment (STA) mode before OLE calls can be made, Ensure that your main function has STAThreadAttribute marked on it.</STRONG></P> <P><BR /><BR />------------------------------<BR />Niranjan Kumar<BR />------------------------------</P> Tue, 02 Jan 2024 08:59:00 GMT NiranjanKumar 2024-01-02T08:59:00Z https://community.blueprism.com/t5/Product-Forum/Failed-to-copy-and-paste-in-excel-sheet/m-p/60288#M13770 <P>I am getting below error while running Blue Prism code, actually i am filtering duplicate and Unique value from Main excel sheet and pasting to another excel, how ever it is running fine in Debug mode. but getting errror while running the process using Blue Prism Desktop. Any help or suggestion to fix this issue.</P> <P></P> <P><STRONG>Error : Failed to copy worksheet: Current thread must be set to single thread apartment (STA) mode before OLE calls can be made, Ensure that your main function has STAThreadAttribute marked on it.</STRONG></P> <P><BR /><BR />------------------------------<BR />Niranjan Kumar<BR />------------------------------</P> Tue, 02 Jan 2024 08:59:00 GMT https://community.blueprism.com/t5/Product-Forum/Failed-to-copy-and-paste-in-excel-sheet/m-p/60288#M13770 NiranjanKumar 2024-01-02T08:59:00Z https://community.blueprism.com/t5/Product-Forum/Failed-to-copy-and-paste-in-excel-sheet/m-p/60289#M13771 <P>Hi N,</P> <P>As a workaround you could copy the from-XL into a collection, then do your duplicate filtering on that collection, and finally write the filtered results from the collection to the to-XL.</P><BR /><BR />------------------------------<BR />Happy coding!<BR />---------------<BR />Paul<BR />Sweden<BR /><BR />(By all means, do not mark this as the 'Best answer'! )<BR />------------------------------<BR /> Thu, 04 Jan 2024 11:09:00 GMT https://community.blueprism.com/t5/Product-Forum/Failed-to-copy-and-paste-in-excel-sheet/m-p/60289#M13771 PvD_SE 2024-01-04T11:09:00Z