How Can i Store the Seperate Sheet Data in seperate DataTable?

hello< I want to Store the CY Sheet Data in DT1 DataTable.

Same as Above, I want to store PY Sheet Data in DT2 DataTable.

And I also want to Fetch this Respective Sheet Name.

Here’s One Excel Contains the CY, PY Sheet.

@kishan.savaliya

Check the below workflow for ref

Example.zip (10.1 KB)

1 Like

Dear Ushu,
are you free atm can i request if you can help on zoom
regarding my sap condition to paste data in sap textbox from a particular point

Thank You @ushu for Reply…

my Exact point is different i will try to Explain you in detail

1 Like

Hey!

Use Excel application scope and pass the PATH

Now use get workbook sheets activity in output-> Create a variable the type of this variable is List(String)

Use for each and inside the for each use Read range->Output->Dt pass the item in sheet

You will get the one by one sheet and the data will be stored in the Dt variable

Now use the if Condition

Item.Equals("CY")

Then Block: Perform the Actions
Else block: Perform the PY Actions

Regards,
NaNi

1 Like

@kishan.savaliya Sure. Please create a different post for that

@Rahul_Singh_Kamboj. I have few back to back meetings. Please post your question in a different thread. Will try to resolve your issue

1 Like

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