I have a problem is that the excel file open every time it write a new line on the file, how can i do to write all the result on one time, how can i do
e it write a new line on the file, how can i do to write all the result on one time
Hi @Soudios
You can directly use Write Range Workbook and write the excel at a single instance and excel wonât be opening at run time too. Make sure to enable the Add Headers option to that the data table will be written with the headers into the excel.
Check below image for understanding:
=> Specify the Workbook path where you want to write the data table.
=> Specify the sheet name.
=> give the data table that you are going to write it to excel.
Hop it helps!!
@Soudios
If you donât want the excel to be open then use Write Cell Workbook activity. Itâs also same as Write Cell in classic version.
Hope it helps!!
the bot write so fast so it said its already using, how can i do to put all the information in a data and write all the information in one shot on the excel file ?
If you are using Write Cell Workbook you need to close the excel before running the process.
Hope you understand!!
the excel doesnt exist before i run the process, the bot created it, i think it write too fast on the excel file
Hello @Soudios ,
Instead of writing the Data Each time to the Excel file , You can add the Data To the DataTable, Once all the Data is entered, You can write the Data to the Excel file usind Write Range WorkBook Activity.
1 Like
how can i do that ? enter all the cell i want in a data
Hello @Soudios ,
If you are writing the Data to the Same excel sheet, then you can add the Data to the Single Data table using Data data Row activity:
and then use the Write Range Workbook activity to write the DataTable values to the Excel FIle:
If you are writing the Data to the mutiple Sheets, then you can use multiple DataTables and at the End write each of these datatables to the Excel FIle Sheets, using the Write Range WorkBook Acitivity and specifying the Sheet Name.
Regards;)
i have only one sheet where i want to write, but i have many column to write in the same time, so how can i put all these information in âadd data rowâ
i have column A, B, C, DâŚ
in add Data Row Column, Pass all the values as the Object:
Here you can use ânew Object() {values you want to pass seperated by commas(if a particular column doesnt need a value, Pass Nothing to it)}â.
Regards;)
donât really understand my friend
In the loop you can use the add data row activity
and pass the values in array row like this ={âcolumnname1â,âcoulmnname2â} and data table = your datable
you can see the screen shot, but the write range should use out of loop
