Hi ,
Thank you for feed back .
Can you please attach the excel file that you have used it to test my side . I would be pleasur to get the xmal also.
Regards
balamurugan
Hi ,
Thank you for feed back .
Can you please attach the excel file that you have used it to test my side . I would be pleasur to get the xmal also.
Regards
balamurugan
Hi Sanga
Main thing is the excel file please.
Thank you
balamurugan
Hi, sorry. Pls find it below.
InputServer2.xlsx (10.4 KB)
ServersFromPDF.xlsx (25.9 KB)
I have attached the xaml again as I commented out the below activities.
2808 - v5.xaml (2.1 MB)
Thank you.
I will let you know. After investigate it.
Note :
It will take time . I am in outside.
Thank you
Balamurugan
Hi, roughly how long will you take?
Sorry. Really I donât know. But I am so far away from my location. As soon as possible I will try .
Regards
balamurugan.s
hi @sangasangasanga,
First of all I say sorry. Some where I have missed to add the documentation for the Add sheet. I found the problem in you xaml. You are passing the generic variable in the sheet parameter. But it has to be a string. Below I have attached the sample for the add sheet.
Note :
I really appreciate your interest. I feel so inconvenient to respond you at right.
Thank you
Balamurugan.s
Hi Friends,
Here I have added the Documentation for the activity called âAdd Sheetâ
Installation Guide
InstallationGuide.zip (121.4 KB)
Properties
Namespace
Sample : AddSheet.zip (60.9 KB)
Thank you
Hi @balupad14, thanks for response. I changed the variable into string. However, the sheet isnât adding, Is it because the excel sheet is open at the time adding sheet? Pls advise.
2808 - v5.xaml (2.1 MB)
Thank you.
Hi @sangasangasanga,
If the excel sheet opened, It will not add the sheet into the excel sheet.
I saw â1409 part2â. You are adding the excel sheet inside the for loop. But before that you have opened the Excel file by Excel Application scope. Inside that you are not doing anything. My advise is that you can remove that if it is unnecessaryâŚ
Regards
Balamurugan.S
Hi @balupad14, I cannot remove it as I am doing so that I can have an output as a workbook. Thus, i can check if the particular named sheet exists then add sheets. There is no other activity that outputs a workbook for me to check.
Hi,
when we try to launch Robot on the process from Orchestrator that uses âDelete Sheetâ, we have this error:
workflow: UiPath.Core.Activities : Cannot create unknown type â{clr- namespace:BalaReva.Excel.Sheets;assembly=BalaReva.Excel}DeleteSheetâ
when the process runs from UiPath Studio works fine
Could we miss some configuration on Orchestrator or Orchestrator machine that is different from robot machine?
Note that the robot run on the same machine where we test the process with Studio
thank you
Guido
Hi,
thank you, after post I found other answer and resolved with manual copy-and-paste on Orchestrator Activities directory
Regards
Guido
Hi @balupad14 is there a way to pass dynamic in path value in âCopy To fileâ Activity? I have an excel file that gets generated every day with date at the end of file name and need to copy the sheet in that file to a separate excel file. The Second Excel file already has the same sheet name where i need to copy the content
Hi @Mchande,
Yes. My all activities are dynamic parameters. you can use it like below that i have attached sample xmal for you a sample.
CopyFile.zip (2.0 KB)
Regards
Balamurugan.S
Thanks Bala
HI ,
It doesnât have now . But end of day I have a plan to upload the activity. Once it is uploaded,I will give a ping to you.
Thank you
Balamurugan.S