Error while creating the excel file

Help Studio
, ,
1

YT channel opertions main.zip (58.7 KB)
ERROR: Read Range: The sheet Hydrabad shopping does not exist in workbook

image
image1686×830 62.3 KB

the excel file which is created by the main file is showing error.

2

Hi @Adithyeshwar_goud

Try giving the below syntax in Write Range Workbook.

DateTime.Now.ToString("yyyy-MM-dd")+".xlsx"

Regards

3

yes i have given the same syntax
if possible check the main file that i have given in the post

4

Hello @Adithyeshwar_goud
Try this
To Create the new excel file, Write reange workbook activity is enough. Dont use the Craete file activity. Remove the Create file activity. Just pass the path to Write range, It will create the excel file if it des not exist.
Remove it—> image

1 Like
5

now an other error raised:
Read Range: The sheet Hydrabad shopping does not exist in workbook C:\Users\gouda\OneDrive\Desktop\rpazone\2024-01-13.xlsx.

it is not creating new sheet with the input name

6

@Adithyeshwar_goud
It means that the Sheet name is not Exist.
It seems that you Write data in different file and read data from different file.

image
image598×544 16.7 KB

7

@Adithyeshwar_goud
Its seems you just passing the Folder Path. Its mandatory to pass the file path in the Excel application scope
image