Updating cells in excel base on database

Hello,

I want to create few excel files base on provided Plant number.
I’ve downloaded data as datatable next I assigned separate variable (CurrentRow.item(“Grip Plant”).ToString) and base on those I want to first specific cell and the save file.
Then again and again.
I’ve done workflow as below, but it doesn’t work.
Any hints what I do wrong?

Hi @jakub.jablonski

Can you try the below

Input:

image

Output:

Regards,

I’ve created as suggested and it does nothing.

For “Write Cell Workbook” first position “Workbook Path” I assume is for naming new excel files?
Sheet name and cell are for updating one cell base on input?

@jakub.jablonski

I have tried the same it is working for me

Yes, it creates new excel files with the name of excel rows

Sheet name is you have given “Cover” and Cell is updating the excel current row input in C10 cell

Is it creating excel files or not? If yes is it writing the data into particular cell?

Topic solved.
I shouldn’t use CurrentRow.Item(“Grip”) but CurrentRow.(“Grip”) - thanks to this I’ve managed to create data.

Many thanks for support!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.