Recent content by Aparna

Hi RPA_1 Use this C# code in code stage, it will delete empty columns in collections with out knowing column name. Input: Collection In Output: Collection Out Code: DataTable table = Collection_In; List<DataColumn> listToDelete = new List<DataColumn>(); bool deleteColumn = false; foreach...

Hi Sivagelli, I have the same issue that Excel Workbook has 64 Columns 67845 Rows, I want split this data in to different worksheet with in the same workbook. I'm not able to understand the below method that you mentioned. Please help me how to do this. Loop Start Create Worksheet Use Copy...

@cs.andras Thanks a lot..

Hi bot1robot, Thanks for the reply, My Excel sheet having a formula if I use "Get Worksheet Range as Collection" method it is showing internal error. Thanks! Aparna.

Hi bot1, Thanks for the reply, will try & let you know...:) Regards, Aparna.

I am unable to send the Excel data, due to access issue...:)

My Excel is having a formula, if I use " Get Worksheet Range as Collection" the data is not copying in-between range.

Thanks Harish, I am not good at Coding. Do you have any Code for this? Thanks! Aparna.

Hi Harish, Thanks for the reply... I want to delete Column4, Column5, Column6 in Collections, By using Utility manipulation delete column action I can delete only one column but I want to delete all 3 columns. Column1 Column2 Column3 Column4 Column5 Column6 A...

Hi Junjie, Did you resolve this problem, I do have same issue, I want to delete empty columns in collections. If you know the solution please let me know... Thanks in advance... Aparna.

Hi All, I am working on Excel data, copying all Excel data in to collections. Once I copied all data in to collections it is copying extra empty columns also, I want to delete extra columns in collections. I tried business object utility-collection manipulation using Delete column action. By...

Thanks VJR..

I am having small doubt, username and password we are storing credentials tab in blue prism. But if lot of sensitive Data like Account I'd, SSN in banking sector where we can store these kind of Data. Thanks in advance....

Hi, I am working on web application using chrome. I am not able select the drop down. I did object cloning for click option in drop-down, not able to select inside drop down elements, after cloning I don't have option call "select item by index" or " select item by text". How to resolve this is...

Thanks for the reply. I tried both the ways, it's like flashing application, it's not highlighting any text box.