SS&C Blue Prism Community

AdarshKappettu · 20-06-20

Hi,I am importing some data from Excel into a collection. I wish to filter the collection on Entry date today. The date in the collection is in MM/dd/yyyy text format.Kindly suggest a syntax to filter the collection.Thank you.Adarsh-----------------...

AdarshKappettu · 04-04-20

Hello,I am posting some entries in SAP and reading a document number generated by SAP. How can I get the data read from SAP in the Object to be transferred back to process and append Data Collection in the process.RegardsAdarsh-----------------------...

AdarshKappettu · 06-04-20

Hi Zdeněk Kabátek,Thank you. I will try this.Adarsh------------------------------Adarsh Kappettu------------------------------

AdarshKappettu · 12-03-20

Thank you Mr.Zdeněk for the screenshots. I will try this approach.------------------------------Adarsh Kappettu------------------------------

AdarshKappettu · 12-03-20

Hi Zdeněk Kabátek,Yes, I used the Excel VBO as below:1.Create Instance2.Open Workbook3.Activate sheet4.Select Data range5. DeleteAt stage 5 Delete is get the "HRESULT...." error.ThanksAdarsh------------------------------Adarsh Kappettu--------------...

AdarshKappettu · 11-03-20

Hi,I tried Select- Delete VBO to delete rows in a Excel file. However I get "HRESULT .xxxxx " error. I want to clear all data in the sheet and write new data from the Collection. Kindly suggest how to proceed.ThanksAdarsh-----------------------------...

SS&C Blue Prism Community

User Statistics

User Activity

Filter Collection by date

Get output from an object into a Data collection in the Process

RE: Get output from an object into a Data collection in the Process

RE: How to delete Top 10 rows from Excel

RE: How to delete Top 10 rows from Excel

RE: How to delete Top 10 rows from Excel