Write on excel cell by looping


#1

Hello Team,

How do I write on excel file . I have to update the status of each transaction.


#2

Hi

If you want update Excel file each time you can use Append Range Activity.


#3

Hi @DebottamRoy1,
Try using SQL Query Method.

  1. Connect Activity: To connect the excel file as a data source
  2. Execute Non Query: To update the field
    Note: You can write UPDATE Query (Same like SQL Queries) to update the cell using a WHERE condition
    You can keep the Execute Non Query activity inside the loop.

Thanks,
Jiban


#4

excel Cell Looping.xaml (11.3 KB)

Try This…
This is Based on Excel Cell Looping by using Write cell Activity


#5

Hi,

Do you want to write a new line/row on each transaction or just change information in a cell on every transaction?


#6

@jibanjyoti

Can you provide a simple XAML package with Worksheet as the data source to query in SQL. It will be useful for better understanding.


#7

Hi @ranjith,
Please find the sample xaml attached.
dbconnect.xaml (10.4 KB)


#8

Thanks :slight_smile:


#9

How do I check result of this and how to implement this on my project


#10

No I don’t want to update each time, My purpose is once loop enter first transaction and once transaction done it will update the next column is transaction done.


#11

Any suggestion ??


#12

Once loop enter first transaction and once transaction done
It means it is iterating inside the loop and after completing one transaction, you have to update the cell just inside the body block of your for each row activity right after your transaction…
The number of iterations= the number of updations.
You are using For Each Row- It means it will perform the specific tasks for each of the items inside that loop.
Hope you understood.


#13

Hello,

I don’t have execute non query selector

Thanks


#14

Any Idea