How to update status columns

Help Studio
, ,
1

Hi Everyone,

I have an excel file there is multiple sheets and one Main sheet. In child sheets there is data which i have to proceed and there is status column l.

For in sheet 'sebi csv ’
1
1
1
2
3

These are my transactions then i have to process which are same (1) then each transaction i have to update as done,failed,done

If all three done then marke as a success in MASTER sheet
If one of them is failed then mark as a partially done

Thanks

Thanks

2

Hi @suraj_gaikwad

Read data from the 'sebi csv sheet, loop through the Status column (L) for each transaction, and process the transactions marked as 1. Update the status as Done or Failed for each transaction. If all are marked as Done, update the MASTER sheet as Success; if any is Failed, mark it as Partially Done in the MASTER sheet. Finally, save the Excel file.

3

@suraj_gaikwad

Can you give more details about your process,
what data is in main sheet what actually you will do with that same like other sheets.

4

Hi,

Main sheet is MASTER

IMG20250308153427
IMG202503081534271920×1440 173 KB

IMG20250308153437
IMG202503081534371920×1440 175 KB

@prashant1603765
@yedukondaluaregala
Thanks

5

@suraj_gaikwad

correct me if my understanding is wrong,

you are doing your some process with SEBI sheet data and updating the status in Status column with in the same sheet!!.
Now you need to update Status in Main sheet based on SEBI sheet Status column Right…?

If that’s right…

  1. After completing the all your process related SEBI sheet.
    2.Read your SEBI sheet data
    3.Read you Main Sheet data
    4.Use loop for Main sheet data
    5.Get the Client code from Main sheet
    6.filter Sebi sheet data with Client code
  2. Now make one condition all of the values are DONE or not
    8.If Yes use write cell and give value and range of the Column.
    (Note: while giving the Index make sure you are passing correct index)
1 Like
6

Hi @suraj_gaikwad , Can you please explain your issue more in detail?

1 Like
7

@suraj_gaikwad

If you got solution, please mark my post as solution.

Thanks,
Happy Automation!!

8

Hello,

I have excel file, as shown in image the ‘MASTER’ Is maine and others chil sheets.

In master sheets there are multiple headers as show and the same name of child sheets also as per headers its start form sebi csv.

Now first I’ll check first header of sevi csv of the status is pending then I’ll go at that headers sheet (child sheet) and there I’ll check client code from master sheet if it’s match then check status of theat specific current row. After once the specific client code row done tye of success or falled as pe this basis update on master sheet of status column.

@Karthik23
@prashant1603765
@yedukondaluaregala

Thanks

9

As per my understanding MASTER sheet is being considered as parent sheet and rest of the sheets are being considered as child sheets. Additionally all the sheets names are in MASTER sheet as headers. Furthermore, You are validating the ClientCode from parent and child sheets and updating the value of Status Column in Parent sheet with value of Status column with Child Sheet.

You can make use of the code attached if my understanding is right. Else please share more details.

SebiReport.zip (11.0 KB)

10

Hello @Karthik23

It’s not working, in different way i did

First i get each sheet of column index
StatusColumn=DtSheet.columns.indexOf(“status”)
Columnletter=Convert.Tochar(65+StatusColumn).tostring

Then using write cell for every sheet

Columnletter+(DtSheet.ros.indexOf(currentrow)+2). tostring

Thanks

11

Please mark the solution if your issue is solved.

12

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