Search the Community
Showing results for tags 'excel'.
-
How to sort list keyword when I found two words. And I want to remove at least 2 words from the list. Example: Can anyone help me?
-
Brand new owner of Ubot. Today Sunday - 9-25. so, many many questions but will start with one... I can use what ever file type is best, according to consensus... I have many variables that i am choosing to get from a txt file. the file contains 1000's of items in the list. I just need to choose one of them.. no problem so far but, I have and excel csv file that contains city state zip and area code. four columns but 10000 rows. When i run the bot, i want to grab - create 10 different variables, randomly from files but i need to get the CITY STATE ZIP AND AREA CODE from the csv
-
Do I need to have Microsoft office in order to work with CSV or Tables? I downloaded OpenOffice and it doesn't seem to be compatible.
-
Hey guys, It has been a while since I've been on the forums. I am having a little issue with a form filling bot I am working on for some data entry work. I am trying to test each individual node in reference to a particular column, and everytime I run the node I get the following error: Error: Conversion from string "" to type 'Integer' is not valid. Trying to figure out what the issue is. Any suggestions?
-
Dear Botters... I have a list of merchants ( business owners ) on an excel file that operate in the United States, and they have opted to give their email, address, phone, name, company name to receive information. My goal right now is to develop a Bot that will assign variables to the email, address, phone, name, and company name, then populate those variables into an email to be blasted. Now since these are merchants who have requested information, by sending them an email introducing my services I should be protected by any SPAM laws because I can prove that these people provided the in
-
Who I am: I new Ubot user What I want to do: Automate the import from Appointment Plus (my scheduling software) to Salesforce (my CRM) What I have done so far: I got the bot to log into appointment plus and build the report but when I click run report nothing happens. Normally an excel file would start to download or there would be a pop up asking to you to save or open the excel file depending on which browser you are using. What I have tried: I tried added the allow pop up command. Any help would be greatly appreciated.
-
Here is what Im trying to do: add list to list(%GET THE NAME FROM A VARIABLE, $plugin function("TableCommands.dll", "$list from table", &data, "Column", #column number), "Don\'t Delete", "Global") Why: I want to create 10 lists from 1 CSV file but there are certain commands I use on all columns: Add list to list set lists position clear list the set variable to the first list item If I could choose the name of the list from a variable that would be set from another list I could then just loop everything Im open to ideas, thanks
-
Please help if you can. I have an Excel filed saved in the .CSV format and I have used the "create table from file" command to make said file into a table to be manipulated in UBOT. I have seen a command that allows a user to set the value in a particular cell of a table "Set table cell" however I want to know if there is a way to get the value at that particular cell in order to use it for other function. I have been reading different descriptions with the resource pdf documents, however I have not be able to find what i need.