How to write in Excel file using robot framework

[ashvin patil]

Hello Guys,

Can any one help me to how to write in excel file using robot frame work.

Appreciate your response.

 

[28462...@qq.com]

You can download ExcelLibrary with 'pip install excellibrary'.

[ashvin patil]

I am using latest version of Python . I already tried to install ExcelLibrary and failed to complete(Version issues) .Is there any other way ..i installed  "Robotframework-excel "  but i am not able to find the needed keyword on how to work on that.

Can you guys please help me that.

[Raphael Roems]

For 'Robotframework-excel', the library is specified as ExcelRobot in your chosen IDE,  https://github.com/zero88/robotframework-excel

An example of where a value is written to a specific cell is shown below:

Open Excel To Write ${location}
Write To Cell By Name Sheet1 E1 ${value} TEXT
Save Excel    

Kind regards

Raphael 

--
You received this message because you are subscribed to the Google Groups "robotframework-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to robotframework-u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/robotframework-users/23f7628b-ca88-43ac-bbdf-66d768e16f1en%40googlegroups.com.

[Mark]

I just use openpyxl.  Create a Custom Keyword to create the excel spreadsheet.

https://openpyxl.readthedocs.io/en/stable/ 

from openpyxl import Workbook

def create_candidate_workbook():
workbook = Workbook()
sheet = workbook.active
# FIELDS
sheet["A1"] = "Candidate_ID"
sheet["B1"] = "Type"

workbook.save(filename="test.xlsx")

[ashvin patil]

Hi  Raphael  ,

Thank you for the guidance , i followed the GitHub link for  ExcelRobot   library , but the link given for the keyword is broken. There is no active link for the keywords.

Can you please help me on that.

Regards,

Ashvin  

[Ru]

You can use RPA library. You can see lots of keywords related to excel.   https://rpaframework.org/libraries/excel_application/index.html

Isinulat ni patil....@gmail.com noong Biyernes, Disyembre 4, 2020 nang 1:11:15 AM UTC+7: