Search results

  1. M

    Insert Bulk Data in excel

    Thanks @Aravindbabu_05 . i have extracted the data into csv file then used copy and paste action to perform the process.
  2. M

    Insert Bulk Data in excel

    Thanks @RobertJ for the response. it would be very helpful if you can elaborate or give an example of this.
  3. M

    Insert Bulk Data in excel

    Hello everyone, please help me out for this, as write collection is taking more time to write bulk data in excel
  4. M

    Insert column before last column

    Thanks @Sachin_Kharmale for the help
  5. M

    Insert column before last column

    Hi Everyone, my requirement is to insert column before the last column . For eg - if my last column is Z so i need to insert column before Z column . Any one could help me in this will be a great help.. Thanks
  6. M

    Excel - String Search

    Hi Nathan, I am also getting the same error message. Could you plz tell me how to solve this?
  7. M

    Formatting the cell value in excel with blue prism

    i am also facing the same issue .. date format is getting changed to datetime while writing to excel ... so i need to change the format of column from datetime to date format
  8. M

    Execution time out for query

    I have updated the code of Data- SQL server of Execute action with below line command and it is working fine for me..
  9. M

    Update power query in excel sheet

    Hello Everyone, My requirement is to update the power query in excel sheet every year using blue prism.. Can you please provide some methods or work around to do so . Thanks..
  10. M

    Validating Excel Headers

    Hi everyone, Could you please help me how to validate Headers of any excel or to set a value using column name .. Thanks in advance!!
  11. M

    Move email to another folder

    Thanks alot @PJj i am already using Outlook VBO , But i want to use Email-POP3/SMTP
  12. M

    Move email to another folder

    Hi Everyone, please help for moving email from one folder to another after reading that mail. Thanks
  13. M

    Insert Bulk Data in excel

    Hi Team, i have a large data in SQL which i have to get and paste same data to existing excel . I am storing the data in collection and then using the write collection to insert the data into excel. But this method is too slow . So i have tried another method using OLEDB , but it is also...
  14. M

    Set data item value to collection

    Thanks @SERBEM , yes, i have added data item in collection by using Calculation stage i have store the data item into collection i.e. [collection.Field] This worked for me .
  15. M

    Reading Excel Header into collection

    Hi @Sivangeli, After using 'Get Collection Fields' action from Collection Manipulations VBO , what is the next step? thanks
  16. M

    Set data item value to collection

    Hi every one, can anyone know how to set data item value to collection in blue prism? thanks in advance!!
Top