Hello Team,
I have a excel with few columns, I would like to update the cell of "cases assigned" column where the Last name is "Vankudre", Also I have a exact cell name in hand.
I am using this for now
"UPDATE [Sheet1$] SET [Cases Assigned]=""231"" where [Last Name]=""Vankudre""
can you please suggest me with directly updating to Excel sheet itself or do i need to update collection and update back to Excel.?
------------------------------
Praneet Vankudre
------------------------------
Hello Praneet Vankudre,
Make sure you use the right version of OLEDB drivers installed in your system.
Refer the detailed guide here: https://higherlogicdownload.s3-external-1.amazonaws.com/BLUEPRISM/56f3f77f-6c92-4a75-9e66-0b0ed2f6e054_file.pdf?AWSAccessKeyId=AKIAVRDO7IEREB57R7MT&Expires=1679575089&Signature=n9JE0jawnaJCnrBoqXLoNrC...
The Latest OLEDB Data VBO can be found here : https://digitalexchange.blueprism.com/dx/entry/3439/solution/data---oledb
Look out for Set connection String action in the Object and provide the source excel file, something like this:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:\Users\User\Desktop\Sample.xslx";Extended Properties='Excel 12.0;HDR=YES;'
"HDR=Yes;" indicates that the first row contains column names, not data. "HDR=No;" indicates the opposite.
Open the connection with Target File ready and you can directly write the operation on the excel worksheet using Execute command.
------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.
Regards,
Mukesh Kumar - Senior Automation Developer
NHS England, United Kingdom, GB
------------------------------
