# \#banking **URL:** https://community.automationedge.com/tag/banking/6.md [Latest](https://community.automationedge.com/latest.md) · [Categories](https://community.automationedge.com/categories.md) · [Tags](https://community.automationedge.com/tags.md) --- ## [How to read password protected excel file dynamically](https://community.automationedge.com/t/how-to-read-password-protected-excel-file-dynamically/10254)
**Author:** [@Deepak\_Y](https://community.automationedge.com/u/Deepak_Y)\ **Replies:** 6\ **Last updated:** [November 29, 2023, 1:19pm UTC](https://community.automationedge.com/t/how-to-read-password-protected-excel-file-dynamically/10254 "2023-11-29T13:19:53Z")
Hello Team, I want to read xlsx file which is password protected, it is working when I’m passing the file name and password statically. But when I’m passing the file name dynamically and keeping the password static in … --- ## [FileCheck-20min](https://community.automationedge.com/t/filecheck-20min/10972)
**Author:** [@Deepak\_Y](https://community.automationedge.com/u/Deepak_Y)\ **Replies:** 3\ **Last updated:** [November 17, 2023, 5:53am UTC](https://community.automationedge.com/t/filecheck-20min/10972 "2023-11-17T05:53:50Z")
Hello Team, For 20 min, I want to continuously check if file exists or not, if file exists than data validation and if not exist than check for it again and again until file found and if 20 min exceeds then abort and s… --- ## [How to handle the page loading issuse in GUI automation](https://community.automationedge.com/t/how-to-handle-the-page-loading-issuse-in-gui-automation/11138)
**Author:** [@Gobikrishnan](https://community.automationedge.com/u/Gobikrishnan)\ **Replies:** 4\ **Last updated:** [November 2, 2023, 10:30am UTC](https://community.automationedge.com/t/how-to-handle-the-page-loading-issuse-in-gui-automation/11138 "2023-11-02T10:30:34Z")
Hi connection, I’m automating the netbanking site for payout process. Major issue is i can’t able match the site loading time eveny tough im using the web delay and until wait. can you suugest any other alternative pl… --- ## [PDF to Text Conversion Issue](https://community.automationedge.com/t/pdf-to-text-conversion-issue/1247)
**Author:** [@SouravC](https://community.automationedge.com/u/SouravC)\ **Replies:** 3\ **Last updated:** [July 24, 2023, 5:27am UTC](https://community.automationedge.com/t/pdf-to-text-conversion-issue/1247 "2023-07-24T05:27:15Z")
Hi, I am trying to convert a PDF file to a Text file using the ‘PDF to Text’ operation but it is neither processing the PDF nor converting it into the text file. Can you please help? The process is running successfully,… --- ## [Automation of batch jobs/scripts/commands](https://community.automationedge.com/t/automation-of-batch-jobs-scripts-commands/9787)
**Author:** [@jmr](https://community.automationedge.com/u/jmr)\ **Replies:** 1\ **Last updated:** [June 19, 2023, 10:46am UTC](https://community.automationedge.com/t/automation-of-batch-jobs-scripts-commands/9787 "2023-06-19T10:46:42Z")
Hi All, Can we automate batch jobs with AutomationEdge? The batch jobs uses scripts and commands to be executed and scheduled to run on Start-of-day and End-of-day. --- ## [Is a complex web automation possible with process studio?](https://community.automationedge.com/t/is-a-complex-web-automation-possible-with-process-studio/6404)
**Author:** [@Deepak\_Y](https://community.automationedge.com/u/Deepak_Y)\ **Replies:** 2\ **Last updated:** [December 5, 2022, 10:11am UTC](https://community.automationedge.com/t/is-a-complex-web-automation-possible-with-process-studio/6404 "2022-12-05T10:11:27Z")
Need to automate a complex multi web application (banking related) Can it be done with process studio, as it is not stable when I did a simple webpage automation for data filling. It crashed multiple times --- ## [How to aplay pivot on Excel file in process studio](https://community.automationedge.com/t/how-to-aplay-pivot-on-excel-file-in-process-studio/660)
**Author:** [@dayal.tilekar](https://community.automationedge.com/u/dayal.tilekar)\ **Replies:** 2\ **Last updated:** [August 30, 2022, 3:02am UTC](https://community.automationedge.com/t/how-to-aplay-pivot-on-excel-file-in-process-studio/660 "2022-08-30T03:02:00Z")
How to apply pivot on Excel files in process studio ,is any step available to apply pivot ? --- ## [Future is bright with Conversational RPA And AI in Electronic Health Records(EHR)](https://community.automationedge.com/t/future-is-bright-with-conversational-rpa-and-ai-in-electronic-health-records-ehr/5593)
**Author:** [@Swapnil\_27](https://community.automationedge.com/u/Swapnil_27)\ **Replies:** 0\ **Last updated:** [March 15, 2022, 2:44pm UTC](https://community.automationedge.com/t/future-is-bright-with-conversational-rpa-and-ai-in-electronic-health-records-ehr/5593 "2022-03-15T14:44:59Z")
A growing number of administrative challenges continue to impede operational efficiency and patient satisfaction for healthcare providers. Some of the most common healthcare challenges that are grappling healthcare prov… --- ## [Automation Takes Over the Risks of Underwriters to Create a Stout Loan Management System](https://community.automationedge.com/t/automation-takes-over-the-risks-of-underwriters-to-create-a-stout-loan-management-system/4923)
**Author:** [@Swapnil\_27](https://community.automationedge.com/u/Swapnil_27)\ **Replies:** 0\ **Last updated:** [October 12, 2021, 9:50am UTC](https://community.automationedge.com/t/automation-takes-over-the-risks-of-underwriters-to-create-a-stout-loan-management-system/4923 "2021-10-12T09:50:50Z")
The necessity for insurance companies to appropriately deploy their underwriting resources is becoming more apparent. Any insurance company can boost its efficiency and profitability by simply leveraging relevant technol… --- ## [The Power Of Chatbots For The Banking Industry](https://community.automationedge.com/t/the-power-of-chatbots-for-the-banking-industry/5520)
**Author:** [@Swapnil\_27](https://community.automationedge.com/u/Swapnil_27)\ **Replies:** 0\ **Last updated:** [March 3, 2022, 10:33am UTC](https://community.automationedge.com/t/the-power-of-chatbots-for-the-banking-industry/5520 "2022-03-03T10:33:22Z")
As the business dynamics go roller-coaster in the banking industry, customer expectations are changing at an unprecedented rate. Even though digital or app-based banking and RPA in financial services have taken over the… --- ## [Compare 2 excel file data - Like option use in compare the row value](https://community.automationedge.com/t/compare-2-excel-file-data-like-option-use-in-compare-the-row-value/4710)
**Author:** [@sManikandansampath](https://community.automationedge.com/u/sManikandansampath)\ **Replies:** 6\ **Last updated:** [November 9, 2021, 7:50am UTC](https://community.automationedge.com/t/compare-2-excel-file-data-like-option-use-in-compare-the-row-value/4710 "2021-11-09T07:50:58Z")
Dear Team, Excel1 - NEFT\_Name Excel2 - Cust\_Name 1.Search excel2 with Like option in column NEFT\_Name. if matched, should return. ex., compare the value “Sun Market” and return as “Sun Marketing Ltd”. Stream Lookup- … --- ## [AADHAAR Card Masking Made Easy with Intelligent Document Processing](https://community.automationedge.com/t/aadhaar-card-masking-made-easy-with-intelligent-document-processing/4828)
**Author:** [@Swapnil\_27](https://community.automationedge.com/u/Swapnil_27)\ **Replies:** 0\ **Last updated:** [September 27, 2021, 4:33am UTC](https://community.automationedge.com/t/aadhaar-card-masking-made-easy-with-intelligent-document-processing/4828 "2021-09-27T04:33:17Z")
Ever since the government has introduced the AADHAAR card as a unique identification number, it is considered an important document for the proof of identification for all citizens. Its regulations are governed by UIDAI,… --- ## [Need to call Tally API for reconciliation from process studio](https://community.automationedge.com/t/need-to-call-tally-api-for-reconciliation-from-process-studio/1048)
**Author:** [@Shital\_Nair](https://community.automationedge.com/u/Shital_Nair)\ **Replies:** 2\ **Last updated:** [July 30, 2021, 6:53pm UTC](https://community.automationedge.com/t/need-to-call-tally-api-for-reconciliation-from-process-studio/1048 "2021-07-30T18:53:57Z")
Hi, Need to call Tally API from process studio for reconciliation process. In this process we have to update data in tally application from excel through process studio. --- ## [Provide Plugin to count the Row and allocates 70 percentage rows](https://community.automationedge.com/t/provide-plugin-to-count-the-row-and-allocates-70-percentage-rows/2769)
**Author:** [@Rahul](https://community.automationedge.com/u/Rahul)\ **Replies:** 1\ **Last updated:** [July 1, 2021, 11:16am UTC](https://community.automationedge.com/t/provide-plugin-to-count-the-row-and-allocates-70-percentage-rows/2769 "2021-07-01T11:16:40Z")
Hi team, Any plugin is available to count the total row and allocates 70 percentage rows in data massaging activity. Regards, Rahul hande --- ## [How to create Pivot table](https://community.automationedge.com/t/how-to-create-pivot-table/3786)
**Author:** [@Rahul](https://community.automationedge.com/u/Rahul)\ **Replies:** 1\ **Last updated:** [June 30, 2021, 10:00am UTC](https://community.automationedge.com/t/how-to-create-pivot-table/3786 "2021-06-30T10:00:53Z")
Dear Team, Please provide the plugin to create pivot table . Regards, Rahul hande --- ## [IS There a way to solve CAPTCHA with AE or API from third Parties? Has anyone try it?](https://community.automationedge.com/t/is-there-a-way-to-solve-captcha-with-ae-or-api-from-third-parties-has-anyone-try-it/840)
**Author:** [@fbaldin](https://community.automationedge.com/u/fbaldin)\ **Replies:** 8\ **Last updated:** [May 31, 2021, 4:55pm UTC](https://community.automationedge.com/t/is-there-a-way-to-solve-captcha-with-ae-or-api-from-third-parties-has-anyone-try-it/840 "2021-05-31T16:55:10Z")
Hi, There are a lot of CAPTCHA API in the market, has anyone broke this Captcha using AE? As an example here a simple captcha that I need to break: https://cpom.prefeitura.sp.gov.br/prestador/SituacaoCadastral --- ## [Automation Edge not taking AE\_Home path set in environment variables](https://community.automationedge.com/t/automation-edge-not-taking-ae-home-path-set-in-environment-variables/3428)
**Author:** [@girish.gholap](https://community.automationedge.com/u/girish.gholap)\ **Replies:** 1\ **Last updated:** [May 20, 2021, 6:56pm UTC](https://community.automationedge.com/t/automation-edge-not-taking-ae-home-path-set-in-environment-variables/3428 "2021-05-20T18:56:23Z")
We are trying to implement HA setup where AE\_Home will be on NFS path which will be shared drive. However,AE gives error “path mentioned does not exist”. From logs,it is observed that it is removing seperators"/" specif… --- ## [Internet Explorer - Web Driver (WebGUI Automation)](https://community.automationedge.com/t/internet-explorer-web-driver-webgui-automation/3226)
**Author:** [@kaushal.kamble](https://community.automationedge.com/u/kaushal.kamble)\ **Replies:** 2\ **Last updated:** [May 4, 2021, 6:16am UTC](https://community.automationedge.com/t/internet-explorer-web-driver-webgui-automation/3226 "2021-05-04T06:16:07Z")
Hello, I am facing an intermittent Internet Explorer web driver related issue where my IE Web Driver is not consistent in starting an instance (Launch IE browser to process WebGUI automation further) of IE. We have obse… --- ## [SAP Business One](https://community.automationedge.com/t/sap-business-one/2567)
**Author:** [@gahana](https://community.automationedge.com/u/gahana)\ **Replies:** 1\ **Last updated:** [September 22, 2020, 4:25am UTC](https://community.automationedge.com/t/sap-business-one/2567 "2020-09-22T04:25:27Z")
Hello Team, I want to automate SAP Business One but its not an application, i am accessing the SAP through an URL. So how can I automate SAP? What is the best approach? --- ## [Web page screenshot](https://community.automationedge.com/t/web-page-screenshot/2422)
**Author:** [@Rahul](https://community.automationedge.com/u/Rahul)\ **Replies:** 2\ **Last updated:** [July 30, 2020, 6:32am UTC](https://community.automationedge.com/t/web-page-screenshot/2422 "2020-07-30T06:32:47Z")
In process studio having any plugin utility to take screenshot of some part of web page and save it in destination folder. --- ## [The Role of RPA in Streamlining the Bank Reconciliation Process 📝](https://community.automationedge.com/t/the-role-of-rpa-in-streamlining-the-bank-reconciliation-process/2300)
**Author:** [@aesupport](https://community.automationedge.com/u/aesupport)\ **Replies:** 0\ **Last updated:** [July 3, 2020, 9:23am UTC](https://community.automationedge.com/t/the-role-of-rpa-in-streamlining-the-bank-reconciliation-process/2300 "2020-07-03T09:23:00Z")
A large number of financial organizations invest most of their time in managing things. Irrespective of the size, location, and the number of transactions in question, the scenario remains the same throughout when… --- ## [Captcha problem : DBC Image](https://community.automationedge.com/t/captcha-problem-dbc-image/2279)
**Author:** [@zack](https://community.automationedge.com/u/zack)\ **Replies:** 4\ **Last updated:** [June 29, 2020, 9:11am UTC](https://community.automationedge.com/t/captcha-problem-dbc-image/2279 "2020-06-29T09:11:59Z")
How to resolve captcha using DBC: Image. It’s fine if someone share Workflow of configuration. --- ## [Google Vision OCR](https://community.automationedge.com/t/google-vision-ocr/1647)
**Author:** [@karloa](https://community.automationedge.com/u/karloa)\ **Replies:** 1\ **Last updated:** [February 21, 2020, 3:00pm UTC](https://community.automationedge.com/t/google-vision-ocr/1647 "2020-02-21T15:00:19Z")
Hi Team, Have ever tried the Google Vision OCR Plugin in the Process Studio? On the Google Vision Part, I’m getting error " Invalid API Key". Do you now what are the steps that it should be in Generating the API Key? …