Which table formats are supported in ElectroNeek?
ElectroNeek can work with Excel tables, CSV files, and Google Sheet documents.
What approaches can be applied to interact with tables?
ElectroNeek can work work with Excel files, CSV files, and Google Sheet documents directly. It means the user just needs to drag and drop the corresponding activities, provide some parameters, and the bot will execute the operations.
Apart from that, Studio Pro has the 'Datatables' group. This group is meant to simplify interaction with tables for some popular use cases. For example, the 'For each row' activity iterates through an Excel/CSV/Google Sheets table’s rows and generates variables for each cell in the row according to the provided template file. This enables users to apply a set of repeated actions to each row. Popular use cases would be adding data from a table to a certain online system or a desktop app.
Finally, users can write macros and apply them to Excel files.
What to do if haven’t found an approach to my problem?
Although a combination of Excel/CSV/Google Sheets activities, that also enable to use of JavaScript in order to set parameters, cover the majority of real use cases, there might be situations when this approach doesn’t solve the problem. In that case, users are free to write their own code and then invoke this code through the 'Command Prompt' activity if they know how to run programs through the Windows command prompt.
Does ElectroNeek support Excel macros?
Yes, we do support macros. A macro must be written in a .vbs file with all corresponding rules of macro creation. Then the 'Execute macro' activity can be used to invoke the macro. Another approach for macros - through Excel’s native instruments - is on our roadmap and expected to appear in 2021.