excellibrary | Excel fileformat library | Data Visualization library

I'm trying to INSERT data into a table from a database at PostgreSQL using robot framework (Database Library) in order to accomplish it

There is a column in an Excel File, which already has the SQL Script, and my ideia is for each row in that column, inserts the information into the Database.

Please find below the script:

I'm trying to update a column on one Excel File with the Current Time.

To accomplish it, I'm using Get Current Date keyword from DateTime Library and store it to the scalar ${datetime} on the script below

So problem here is that I am comparing two lists from different locations. One list is from excel and other list is from particular table which represents the imported values of the same excel values. So all values are correct; but the excel gives one or possbily more values which are "none" and from the table i get those values only empty value as astrophes ''. How can i change "None" to '' or vice versa? In this particular case "None" and '' are in the 10th value slot in lists but over time it can change because different values are put to the excel.
So how can I remove or replace/modify these "nones" to '':s or vice versa?

Excel list: [1, 'X', 'Y', 200, 1999, 'Z', 'W', 4, 'V', None, 2, 1100] Table list: [1, 'X', 'Y', 200, 1999, 'Z', 'W', 4, 'V', '', 2, 1100]

Using ExcelLibrary and ExcelRobot to get the mixture of keywords .. below is the similar approach

I have used the Get Column Values from ExcelLibrary in order to get an entire column from a particular excel file, the column was assined to @{vinrange} as [ ('A1', u'VIN') | ('A2', u'032145') | ('A3', u'051478') | ('A4', u'124578') ]

I want to do a loop in order to only get the value (2nd argument) as [ 'VIN' , '032145' , '051478' , '124578' ]

How can i accomplish that? I'm using Ride

I had trouble to install pip install robotframework-excellibrary on anaconda prompter command, I got the error Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.

I also have tried to install manually, I got the zipfile, I extracted the files into Site-packages folder, however, when I try to import the ExcelLibraryinto Ride, it also got an error

Therefore, I want to know how can I install manually correctly or install via pip without error

I'm using pythn 3.7.

I am trying to test a short Robot Framework-code to ask user the name of Excel-file as a popup-window provided by Robot Framework's Dialogs-library. The idea is that the base of the file path (that stays the same to the folder where Excel-files would be located) is hard-coded to one variable named ${EXCEL BASE PATH} then user would give the name of Excel-file to the popup-window (as name of the file would change between different files) and that changing part of the path would be stored to ${EXCEL NAME} and third part would be hard-coded file-extension .xlsx stored to ${EXCEL FILE EXTENSION} because only files with .xlsx extension would be opened and there are not any changes to file extension.

Library used for Excel handling is OpenPyxlLibrary as that supports xlsx. ExcelLibrary only supports xls.

I got this close to working but the problem is that when concatenating the full path of those three parts written above the result is not the same as the result I am looking for.

Expected result for the full path to Excel-file to be opened would be:

C:\\Users\\developer\\Robot Framework\\Excel\\TestExcel.xlsx

But instead now when logged to console it is:

C:\Users\developer\Robot Framework\Excel\ TestExcel .xlsx

So there are missing second backslashes (required by Open Pyxl Library for path) and also spare space before .xlsx

Is there any other way to construct path used by Open Pyxl Library of different parts like that than by using Catenate-keyword like tested here? If the full Excel path is hard-coded to a single variable instead that has been working great already but the problem later would be to need to change the value of that variable when Excel-file would be changed so that is why I am trying to test a solution for user to give the name of Excel-file to be opened. Because name of the file is the changing part from file to file and other parts stay the same.

Excel-file is not yet actually opened in this simplified code and I am first trying to just log the full path of Excel-file to see if that logs correctly. When the path would be correct I could add code to actually open the Excel-file.

CommonResources.robot-file (resource-file):

I want to Define variable having dynamic name.

For example

I am trying to open a Excel using Robot Framework, but I am get an error "No keyword with name 'Open Excel' found."

Can someone tell what I am doing wrong..

Thanks in Advance

My code :

I have that work on local but not in hosting because of the path. What do I need to change? I use Environment.SpecialFolder.MyDocuments that return c: on local but on hosting do this error: Could not find a part of the path 'C:\CallTool\Files\prospect_636652254790345267.xls'