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?
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
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
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?
Based on image It seems like we are using IF condition
Is it so
YES, i have if condition for the file path exist or not if yes, i use the write range to update the file !
I am facing the same issue, did your problem got resolved?
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
Hey @ZoeW, are you passing the same DT to the Write Range? Can you share your workflow or a screenshot maybe?
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.
Can you try enabling the Auto Save property once? If you’re doing multiple writes, try Save Workbook activity instead!
Woohoo, that has worked! Thank you so much After reading up on the autosave property, it makes sense now that my file was blank!
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).
Great, thanks for the tip