Developers Forum

the other cell calcuations are correct, but i figured out that when a cell comes as left aligned, it shows “#VALUE” Also this happens when I open csv file in the excel.xlsx Some columns are aligned well, and others are not. So when I do some calculations, it shows me #value, why does it happen? One thing i figured out that when a cell has comma, it does this on the machine. On other machine it doesnt get left aligned. I look at region language, and customiseFormat-seperators are same

Hi Everyone, I want to paste information from one excel to another excel.Data is on many rows and many columns.How can I paste many data into excel? Thank you.

Hi ,I have an automation requirement below, Could you please help if this is feasible using AAV11 ?1.I need to open SSMS in a server/machine and click on connect icon ,enter the details to connect with server2.Run SQL Script and take the screen shot of the results window.(Note: If we have multiple results need to scroll down the window/page and take the screenshot)3.Right click on one of the tables and go to properties and take the screenshot of results window.4.Now whatever the screenshots took above ,come back to an excel sheet and paste it one by one.5.Disconnect from the server and connect to another server and perform the same steps again for multiple servers.As per the commands available in v11 I believe we can connect to database and perform some operations in the backend. Just wondering if we can perform the foreground operations which I mentioned above with SQL .Please suggest.Thanks,Avinash 

in excel how to remove duplicate values from an column?

On one machine, the csv seems in right format, but another machine the csv file seems not so.example:what should i change for the machine which shows me the csv file as the second screenshot?

Hello.I have a project to connect my Control Room (Cloud Automation Anywhere) to the company's Active Direct (AD).I'm checking the AA360 documentation and I haven't found anything on how to perform the procedure.Has anyone done this process or have any articles on how to do it?

I need to merge 50 PDFs from a folder into a single PDF. I’m using Automation Anyhwere v11.

Hi @raheel.ashraf ,   I hope you have by mistakenly mentioned Community edition. Because, for the community edition, you just have to install only the BOT agent and community edition link will be shared with you through your registered email ID. yes I mistakenly mentioned community edition, its enterprise edition that you get from the automation anywhere partner portal.

how to extract error message from sap using a360? it is showing at the bottom of the screen with red indicator. 

As a beginner I run through the Automation360 video “Getting started with building bots”. Capturing a csv table and paste into Excel doesn´t go well. Everything is pasted in column A, not column separated as the csv file describes. So the bot doesn´t find correct data in column A and B etc. How should I make the bot separate the columns directly in Excel? The parameters are: ANSI, comma separated, .csv file.  

I want to read an email subject and message of the mail and write it into an csv/txt file ?

I'm using recorder capture to capture an element on one of the website (Organization specific), but object is not getting highlighted and properties are not captured properly.Code behind the website shows my target elements are enclosed within IFRAME. I tried with all the different technologies of Recorder capture but unable to capture.I cannot use Image Recognition & OCR to work with this has more elements on screen along with a grid that can have multiple data rows based on the filter.I need to capture properties of these elements to move further. Can you please advise on this?

Hi all,          I would like to know if there a way to find the old community(aPeople) post? Whenever I do a google search I find exactly what I am looking for. Upon clicking the link I am navigated to the new pathfinder community and the post is missing or irrelevant . Please refer to the attachments. Google SearchPathfinder Community Search 

it does not let me log on the text file, i hadnt had this error before 

Al ingresar al servidor que sera el bot creator y darle conectar a dispositivo local da errorEl control room ya esta como forma segura, se agrego en la linea del archivo host la linea para que sea segura y funciona con el https 

I uninstalled the bot agent, used the uninstall.batch file on C:\Program Files\Automation Anywhere\Bot Agent while i was trying to install the bot agent, it gave this error” Unable to connect to the Control Room and it may be due to not being able validate the SSL certificate presented by the Control Room.This may be due to multiple reasons. To continue, please 1. Check to see if the SSL certificate has been added to the Java Key Store that is bundled with the bot agent. Then, try again.If you continue to see this message, please contact your system administrator.” what should i do next?

I want to update license. Please tell me steps 

How can I fetch data between two date ranges using select query?For eg I want the records that lie in the month of Oct 2022-Dec 2022. I am using below select query : select * from [Sheet1$$] where [Date] BETWEEN #10/1/2022# AND #12/31/2022#  the query is giving me records of every year for the months of Oct-Dec instead I want the records for just 3 months (Oct,Nov,Dec) of the year 2022.P.S. - I am using excel as database

While creating the WLM queue, I defined the template structure inaccurately and would like to revise the template, or delete it in order to completely redo the template

The send email command is failing with the below error. Username '' in email setting option and From Email 'xxxx@xxx.com' within Send Email command should be same.Please ensure both emails are same and try again.

Cannot delete device, as it is part of an active bot deployment ,,I am stucked in this , please help

A stock market exchange website has a list of all stocks, and I want to click on all of them to get information.How do I acheive that?I know how to capture one stock, by opening the site and clicking on one stock, but how do I repeat the same thing for all stocks?The table contating the stocks contatin some rows that aren’t stocks, some extra information that I don’t need to click on.Thanks in advance.

Hello Everyone,I want to convert any given date format to d/m/yyyy.the input value may be Jan 1, 2023, 1 Jan 2023, 1-1-2023,,,, meaning the format is not fixed.So I want to convert the given date to fixed format ex d/m/yyyy so we can work with the date further. Any Idea how to do it?

Hi Guys, In an excel sheet I have column where there dates in the format as below :12/26/202211/12/20215/5/202110/10/2020……. etc.I want to use select query (excel as database) where I want to filter records using the year only. Basically, I want to build a query something like this : select * from [Sheet1$$] where ‘Date’ <> 2021. In the above query what I am trying to do is filter the records where year is 2021 and leave rest of the records. Need some help on how to achieve this. Thanks in advance :)

Hi Guys, While running the code in a production server (unattended mode), I am getting an error when it is trying to run a basic select query in an excel and getting an error as below : The connection for viewing your linked Microsoft Excel worksheet was lost. I am getting this error on the exact same line where the select query is written and I was not getting this kind of error before (not even once!) . Surprisingly when I log in to the VM & run the code again, it runs fine. Any suggestions or resolutions please ?