Write range activity return a sheet empty

Help
, ,
1

hello,
i have a read csv activity return a database, then i used write range to whrite the database in an excel file, but the file sheet always empty after the execution i verified that the database is not empty, and i don’t have any error,
any idea to solve this problem?
image
image

2

Before excel application scope use a writeline activity and let’s check whether the datatable has records in it or not
For that in writeline activity mention the datatable obtained READ CSV file, to gets to rows count like this

datatable.Rows.Count.ToString
This will help us in validating the datatable before writing it with read range

And if that gives us some count then make sure that the datatable name mentioned in read range is same as we get from read csv

Cheers @rchabbeh

3

hello,
yes, i have check the datatable count return 1032 (rows), and it’s the same variable in read csv and write range, should i change the propreties of the execel application scope?
image
image

4

Based on image It seems like we are using IF condition
Is it so
@rchabbeh

5

YES, i have if condition for the file path exist or not if yes, i use the write range to update the file !

6

I am facing the same issue, did your problem got resolved?

7

Did anyone find a solution to this? I am having the same problem with some data read from a CSV file. The data is passed into my datatable variable “DT_OutputFile” which contains 1418 rows (verified using DT_OutputFile.rows.count). This is then output using a write range to an excel file within the excel application scope activity. Everything runs with no errors but the excel file is completely blank :confused:

8

Hey @ZoeW, are you passing the same DT to the Write Range? Can you share your workflow or a screenshot maybe?

9

Hey Rahul, Thank you for your response.
I’ve double and triple checked and can confirm I’m using the same DT in the write range activity, it’s so weird! Here is a screenshot of the workflow.

WriteRangeToExcel
WriteRangeToExcel1024×775 166 KB

10

Can you try enabling the Auto Save property once? If you’re doing multiple writes, try Save Workbook activity instead!

1 Like
11

Woohoo, that has worked! Thank you so much :smiley: After reading up on the autosave property, it makes sense now that my file was blank!

1 Like
12

Awesome! Also, please note that if you’re doing multiple writes in the same sheet, please use Save Workbook activity after Write Range or Write Cell (multiple writes) instead of enabling this property so you can save up time (in seconds).

Cheers!

1 Like
13

Great, thanks for the tip :smiley:

1 Like