How do I write data to Excel?

Hello everyone,
I have the following information.

can you help me ?


@Perawat, Hi are you able to share the excel file? you can remove sensitive data in it if needs be.

And are you working with two excel files or these are two sheets in one file?

@SenzoD, Yes, I can share.

I working two files Excel.

Test.xlsx (8.6 KB)Test2.xlsx (8.6 KB)

@Perawat, give me about 30 minutes or so. I will send you back the worflow

@SenzoD, Thank you very much.

@Perawat, I do not know how you got the negative number, and I tried to make this workflow as simple as possible but if you need it to be more robust we will have to use for loops and if activities and that will take a bit of time. hope this helps, let me know if you encounter any issues.

Main.xaml (11.0 KB)

@SenzoD, If the column B is not at line 7. Maybe on another line. Based on the information I received. Do you have a method?
Excel2Test.xlsx (8.7 KB)

@Perawat, yes, you can read the data on the sheet and get the length of the rows, store the lenth on the variable and parse that variable into the write cell activity, i am a bit busy today, but if this is not urgent later on today i can send you a sample.

1 Like

@SenzoD, I need more sample, Thank you so much for your help.

1 Like