Create new worksheet in excel

Build with Robocorp RPA Framework
#1

Hi, I am trying to create a new excel and create a new worksheet and finding it difficult to figure out the exist_ok argument in creating a worksheet.

The issue here is when I use true or false with the sheet name already exist it is not throwing any error.

The code goes like below:
*** Keywords ***
Create new excel
Create Workbook fmt=xlsx
Create Worksheet Data None True False
Save Workbook ${filename}

#2

I tried creating two sheet with same name and exists_ok=False, but it seems to fail

image
image1782×912 92.5 KB

1 Like
#3

Hi @Teppo, I haven’t tried this scenario of creating two worksheets at the same time.
Let’s say excel already has a sheet named Data but I am trying to create it again?
Will that throw any error?

Thanks for your reply.

#4

Yes it does
image
You probably saw an error as given example has exist_ok set to True
Create Worksheet Data None True False

2 Likes
#5

Hi @Raivo and @Teppo
I got it. The reason is I was creating a new excel every time.
Thanks for your response.

1 Like