I am trying to use Get Text activity and write to an excel

I am new to UI Studio and trying to use UI activities, Get Text and Type into activities and write cell workbook activity to write data into excel. My sequence is running without any errors but it is not Typing anything into the application and writing it back to excel. How to fix this issue?

Welcome To the UiPath Community, @tejasvipedduda

If the workflow completes without errors but no text is typed or written, the UI activities are likely not interacting with the target application.

Check the below:

Verify the app is open and in focus then re-indicate and validate the selector

Disable simulate type/SendWindowMessages And dont forget to add a short Delay before Type Into

Make sure that Excel file is correct and not open for write cell

Hi Manish,

Thank you for the steps. I tried but no luck

Thanks for checking that, try this

Run the workflow in debug mode and use highlight / Indicate on screnn to conform the selector is actually found at a runtime.

Turn SimulateType=False,SendWindowMessages=False and enable ClickBeforeTyping in Type Into

If possible, sharing a screenshot of the activity properties or selectors would help narrow it down.

Hey @tejasvipedduda welcome!

Your issue is almost always bad selectors or timing.

Fix Selectors in Get Text/Type Into β†’ click UiExplorer (top right of Indicate)

Re-select your element β†’ must show 100% green

If red/orange β†’ add Anchor (parent/stable element nearby)

Test Get Text works

Get Text β†’ output = "myText"
Write Line: myText  ← MUST see text here

Complete working flow

Delay 2s (app loads)
Click target field
Get Text β†’ myText
Type Into β†’ Text: myText (check "ClickBeforeTyping")
Write Cell β†’ Text: myText, Cell: "A1"

Quick Debug

Run in Debug mode β†’ pause after Get Text β†’ check Locals panel if myText has value.

Still empty? Share selector XML + app screenshot.

1 Like

Hi Manish

here you go

@tejasvipedduda

Enable Strict Selector
Disable Fuzzy Selector
Keep iamge/CV off for now
Set Visiblity check =Visible
Enable ClickBeforeTyping=True

image

@tejasvipedduda

Your selector is only the inner ctrl node. Open UiExplorer and also include the top window / app nodes (usually wnd or app parents). Make sure the whole selector is validated (all green). Then test with a simple Type Into on that field. If it works with the full selector, reuse that selector for both Get Text and Type Into.

If the app has multiple controls with automationid=β€˜cashintb’, also add a stable parent (anchor) around it so only one element matches.

Strict selector fails fast if the element isnt found and Fuzzy Selectors may pass silently but never interact

If the app is dynamic:

Use Anchor+Strct
Or raise fuzzylevel(.7 if needed)

Strict selector ON+Fuzzy OFF + Re-Indicates once

Hi @tejasvipedduda,

Why don’t you try this solution

Use Use Application/Browser to keep the app in the foreground, re-indicate the selectors, disable Simulate Type and SendWindowMessages, and make sure the field is clicked before typing. Also log the Get Text output to confirm data is actually being captured before writing to Excel.

Let me know if it works or still facing any issue

@manish.pal @arjun.shiroya

I have re tried the workflow by removing the Read Rage to Workbook activity and Write Cell to Workbook activity. After removing those two the application is writing the value to Type into activity and Get Text activity fine. I feel the issue is with the Excel activities. Any suggestions ?

Try this

Re-indicate the element and turn off Fuzzy Selector for that activity, or manually remove the fuzzy attributes from the selector.

Yes, the issue is with Excel activities. Workbook activities work in background and fail silently if the file is open, path is wrong, or the value is empty at runtime. Make sure the Excel file is closed, validate the value before writing, and check sheet and cell names. If Excel needs to be open, use Excel Application Scope instead of Workbook.

@Maheep_Tiwari @manish.pal

Thank you guys!! I figured out the issue. The Read Range Workbook is corrupted so it was not reading the data from sheet. As soon as I created a new excel file and ran my workflow it was successful :slight_smile:

2 Likes

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