Step 1 & 2 a.b.c are done, However when i try to write formulas with the “write cel” activity it doesnt give me text.
also with deleting a image im having difficulty. I can delete rows but it doenst delete the image.
this is how the excel workbook looks
as I understand your requirement, you need to make dynamic directory and place excels after executing operations
if yes then, please follow these steps:
1> create variables like current Month, current Date, Department, Standard Reporting, support etc
2> Get the values for above variables
3> do activities( you can do it by Execute macro activity)
3>use create Directory with assigning full path of directory
4> place the file in the directory
hope this will help,
Hi,
For image deletion from excel I use the following VB code invoke.
It however deletes ALL images.
The in_argument is the value returned by activity “Excel Application Scope”
You need to add Microsoft.Office.Interop.Excel into Imports.
in_argument objXLS as UiPath.Excel.WorkbookApplication
Dim objWorkbook As microsoft.Office.Interop.Excel.Workbook
objWorkbook = objXLS.CurrentWorkbook
For Each ws As Worksheet In objWorkbook.Sheets
For Each sh As microsoft.Office.Interop.Excel.Shape In ws.Shapes
sh.Delete
Next sh
Next ws
I get a error when i try this “no Compiled code to run error BC30456: 'CurrentWorkbook is not a member of ‘Uipath.Excel.WorkbookApplication’. At line 3” do you know the solution to this