How can i add several information from an application in excel
That can be done using the ‘write cell’ activity. place your excel spreadsheet scope inside a loop then you can use the write line to specify the column/row then use a incremental variable to move to the next row. similar to whats pictured
In write cell activity, in “Cell” field, only a coordinate is expected (so for instance “J2”) and that’s it. In the screenshot we see “J2”+ Compteur.tostring something, would you mind specifying the coordinates you’re writing ? Is if for instance from line 20’s ? Where is declared Compteur ?
Is a specific error thrown ?
yes but i want to write after J2 the row J3 J4…
No error but it write on cell J20 and that’s all
Hi just put j and not j2 and try again
“J” + compteuer.tostring
it writes 10000 cell but i have only 2 cell available
I put J2 to start from J2 because there is headers
could you share your xaml and sample excel file.
You need to write “J” + (compteur+1).toString and compteur should be initialized in the foreach row, so you should remove the assign (with compteur = compteur +1)
If it has 1000 values, that means that the problem is in ExcelTESTSejour datatable that contains 1000 rows. Is it normal that it has 1000 rows ? Did you want to write only specific rows among the 1000 rows ?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.