Hello, I got the below error message when running the type into (copying a cell content in excel), the selector works fine. can someone please help?
the selector is:
<wnd app='excel.exe' cls='XLMAIN' title='SearchResultList.xlsx - Excel' /> <uia automationid='Grid' name='Grid' role='data grid' /> <uia name='"D" 1' role='item' tableCol='4' tableRow='1' />
as it will always be cell D1.
1 Like
Anil_G
(Anil Gorthi)
March 11, 2023, 4:32am
2
@lynnsong986
First of all for excel if you want to copy or write content from one cell to another…
Then you can use read cell activity and read the cell data into a variable and then use write cell activity to write back…
UiPath.Excel.Activities.ExcelWriteCell Writes a value or formula into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified in the SheetName property. If a value exists, it is overwritten....
Similarly you have read range and write range as well…please consider using them…performing ui activities on excel is not adviced
You can do a copy paste range as well
Cheers
I’m copying a super long text to chatgpt, the only way to do it is through copy paste otherwise it takes forever
Anil_G
(Anil Gorthi)
March 11, 2023, 4:34am
4
@lynnsong986
For that long text you can use copy paste range activity as well
UiPath.Excel.Activities.ExcelCopyPasteRange Copies an entire range, including values, formulas, table format, and cell format, and pastes it to a specified sheet. Properties Common DisplayName - The display name of the activity. Destination...
Cheers
it’s not pasting to another excel sheet, it is copying thousands of words and paste in chatgpt to summarize, I need this copy to work
Anil_G
(Anil Gorthi)
March 11, 2023, 4:35am
6
@lynnsong986
You can use read cell/read range and then assign the data to clipboard using set to clipboard activity then use a paste on the target chatgpt
Cheers
Anil_G
(Anil Gorthi)
March 11, 2023, 4:38am
7
@lynnsong986
Now coming to the error you would generally see this if the studio you are using and the robot or orchestrator versions are not compatible…can you please check the same
Another possible reason might be the system packages…so try changing the version of system package
Hi ,
The UiPath studio has been updated to Studio 2022.12.0-beta.11471 - 12/20/2022 Community License as of yesterday.
When I run the bot after that, I get this exception; however, if I run the bot in debug mode, nothing happens, and this problem only affects one bot, not all of them.
System exception at initialization: JIT compilation is disabled for non-Legacy projects. ExpressionToCompile { Code = "System.Activities.InArgument1[System.String]", ImportedNamespaces = System.Collections.Gener…
Cheers
1 Like
Thank you so much for your help, the clipboard works really well.
1 Like
system
(system)
Closed
March 14, 2023, 4:49am
9
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.