when I try to use the insert new sheet I don’t find the “Text” option when I click on the + next to the sheet name. If I try to enter a name I get error BC30451. What could cause the lack of the various options?
You can directly enter the text within double quotes or enter text in open in advanced editor option also.
Hi @supriya117 ,
thanks for your answer. Do you think the lack is due to something technical?
The first problem has been solved but now the problem concerns the “reference new sheet as” field. I tried putting it between “” but it still gives me the error
Try by updating the excel packages by making runtime rule as lowest applicable in manage packages.
Hope it helps!!
You need to pass a ISheetRef variable instead of string in that field. Create variable in that field by clicking ctrl+k
Hi @supriya117
I was trying to enter the values in the “what to write” field like the tutorial I’m following but I always have the problem that I’m missing the Text Option.
how to reproduce this task since I am missing the text option?
I tried inserting them one at a time but when I select a column the other disappears.
Thanks in advance
Click on Open Advanced Editor and type CurrentRow("First Name").ToString+CurrentRow("Last Name").ToString. This should help you solve the error.
Regards
hi @supriya117
it worked!!! thank you so much
hi @supriya117
I got this error. I think it’s due to the number 2 in the “column index” section. Should I write it another way?
If you are looking for a double value, make sure that the lookup range contains double values as well.
What’s the type of value CurrentRow.ByField("Employee") returns??
Hi @supriya117,
I’m attaching the two files I’m using that I found on a UiPath training tutorial. I can’t understand where the error could be because I followed the steps in the UiPath video
Annual_Report.xlsx (26,4 KB)
April_Expenses.xlsx (18,4 KB)
hi @supriya117
could you help me?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.