How to build logics for Macros, Inconsistent formulas, Blank cell references, Identify Hidden Objects

Help Studio
, , , ,
1

Hello Forum,

Need guidance on whether and how to proceed to build logic for below use cases:

  1. Macros (Code reading)
    Requirement is to read module files in macros for a given file. Traverse through all lines of code to identify if keywords such as On Error Resume Next, Option Explicit, STOP, etc., are used any where or not. This is to be done for all code files in all macros.

  2. Hidden Objects
    Identify if there are any Hidden
    a. Columns & Rows in all sheets.
    b. Sheet in excel workbook.

  3. Blank Cell reference
    Identify cells referenced in formulas are blank if any.

  4. Inconsistent Formulas
    Identify inconsistent formulas in a given range

Objective would to identify above scenarios and record there cell addresses.

How this can be implemented with UiPath using excel activities or anything else?

Please note, VBA is not an option for now.

2

Hi @Shubham_Tiwari ,

An incredibly odd automation request - are you trying to automate code reviews?
Its better to do it manually, but if you really have to do it with UiPath, and I seriously am questioning whether its required, you can utilize ClosedXML in the Invoke Code activity.

Why?
Thats because there aren’t any inbuilt activities that can help with the sort of operations you want to perform.

Kind Regards,
Ashwin A.K

3

Yes. I have to do it.

It is not any code review process but a validation stuff you can say for a given input .xslx/.xlsb/.xlsm files. Validation for data as well code files (if any).

I know it is not possible with any inbuilt activities hence, had to reach out to experts here.

Can you emphasize more on this?

Can you emphasize more on this please?