Hi UI Path community. I am looking for a way to color excel cells without using excel application scope due to a computer not having Excel. I have already searched for possible solution and found this one presented by @etss1016 :
"You can invoke the vb.net code to set color for cell like below.
Dim xlApp As Microsoft.Office.Interop.Excel._Application = Nothing
Dim xlWorkBooks As Microsoft.Office.Interop.Excel.Workbooks = Nothing
Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook = Nothing
Dim xlWorkSheet1 As Microsoft.Office.Interop.Excel.Worksheet = Nothing
xlWorkSheet1.Range(“A1:A2”).Interior.ColorIndex = 40 "
However, I do not understand how to apply it. Where to define file name and other details. Can someone help me to explain this solution or infrom me about another one?