How to append data to csv file in Robot Framework?

Question

I would like to append data to .csv file which is not empty in Robot Framework now, but I meet some questions.

I installed CSVLibrary from 's4int' of 'robotframework-CSVLibrary' in github and it has a keyword named 'Append To Csv File'. I can append data into .csv file but there are some issues with the format.

First I have an empty csv file and I run my scripts in Robot Framework.

*** Settings ***
Library           Selenium2Library
Library           CSVLibrary

*** Variables ***

*** Test Cases ***
test
${list}=    Create List    apple    pear
Append To Csv File    ${file_path}    ${list}

The file is looked like this:

enter image description here

But I expect is:

! enter image description here

How can I append data to show like what I expect? Is my format wrong? Or is there any other way to realize it? Thanks a lot.

What is the result by using Append To Csv File ${file_path} @{list}? — Jan Kovařík
– Jan Kovařík, Commented Jul 17, 2017 at 9:03

Bryan Oakley · Accepted Answer · 2017-07-17 15:47:49Z

6

It appears that with the library you are using, Append to csv file requires a list of lists. Each list represents a row, and each sublist represents the columns in the row.

Since you want "apple" and "pear" to be on the same row, you need to put those in a list, and then put that list in another list.

*** Test Cases ***
test
    ${list}=    Create List    apple    pear
    ${data}=    create list    ${list}
    Append To Csv File    ${file_path}    ${data}

answered Jul 17, 2017 at 15:47

Bryan Oakley

389k53 gold badges582 silver badges739 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

madelaine Over a year ago

I found use "${list}= Create List \ apple pear" can solve.

kbr85 · Accepted Answer · 2019-07-03 10:51:10Z

If you need to clear the file first and then write another data to it, then you can use below keyword for your robot framework script.

You can directly use the code and create a library with the name CSVLibrary.py and start using it. Then you can call it to your script. Provide the file path with \\ slash to work in the robot framework. eg: E:\\FOLDER1\\FOLDER2. You can give the data in the same way your were giving ${list}=Create List apple pear.

import csv

class CSVLibrary():   

def Clear_file(self, filepath):                    #  Clear_file :it will clear your file. 
 with open(filepath, 'w+') as f:
     obj1=csv.writer(f)

def Append_file(self, filepath, data):             #  Append_file :it will append the data you wanted to in your script. 
  with open(filepath, 'a') as f:
      obj1=csv.writer(f)
      obj1.writerow(data)

Collectives™ on Stack Overflow

How to append data to csv file in Robot Framework?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related