automations | Automations for Budibase applications | Automation library

I'm currently trying to implement some automations for an Excel Workbook. Part of it is to set a common header for all sheets in that workbook.

The header should look like this: Screenshot of the aimed header style and content

I found here question (52295459) how to access the headers, but i did not manage to format them. The code snippet is attached below. I read the documentation for the footerHeader class and for the references format codes. But I'm stuck.

So, these are my questions:

1. Is it possible to set a header for all sheets in a workbook in a more general way, than accessing each by getItem and their name?
2. How can I change the font color to #5E5E5E? I tried with &5E5E5E,&c5E5E5E, &color5E5E5E, E5E5E,&K5E5E5E, &K"5E5E5E" - but nothing worked. Edit: I want to change the colour of the header section.
3. I only need to adjust the center section of the header and may keep the content of left and right sections. However, if the left and right sections are not empty, whatever I specify in the center section will be attached to the end of the right section (attached string "center" wrongfully to right section). Is there a way to keep the left and right section and only change the center section?
4. If not: How can I insert the logo as an image and maybe format the height/width of it?

The working part of the code so far:

I am currently working on C# selenium automation tests. My setup is simple: running tests on a test server (accessible via remote desktop), I've setup task scheduler trigger to run them every day via this command: dotnet test --logger:"html;LogFileName=C:\inetpub\wwwroot\mywebsite\TestResults\TestResults.html" C:\AutomationSuite\Testsuite.dll

The test results output file is stored in a wwwroot foolder and is uploaded to a website that is accessible via vpn. Visible output:

Now, my question is: are there any extensions or convertors for my test results to be more appealing to the eye? Like in a pie chart or something like that (running on azure devops the output of test run is more appealing).

Is it possible or am I digging too deep? Much appreciated

I am using a voice recognition add-on to Dragon NaturallySpeaking to create keystroke automations using my voice. The add-on exposes the VB function SendKeys. I am aware that the shift key modifier (+) can be combined with almost any other character(s), but I am not trying to combine the shift key with anything; I simply want to send a single shift keypress without anything else. Is this possible?

Some things I've tried:

I'm trying to make an application automating the Messages app on Mac. One of the automations requires interactions with the conversation info button. I have tried to write a script to start playing around with it:

I'm not sure if it's okay to post a follow-up question like this, but I'll do it anyway.

So a few days ago I posted this question: How can I remove all occurrences of a sub-multiset in Isabelle?

I thought the answer was great, but when trying to prove the lemma

I am new to power-shell and cmldt.

I registered a power-shell script(.ps1) name like "Invoke-xxDevopDt" as azure RunBooks that associated with an azure Automation Account.This RunBooks scheduled to run at another data for do some work. Below is my power-shell script(.ps1) which i used to register "Invoke-xxDevopDt" (RunBook) by using 'Register-AzAutomationScheduledRunbook' as below

The code below is a template used for a bunch of automations. all works fine until the line where i'm trying to select a certain cell. I'm doing that so that if somewhere in the code I add some code that manipulates a cell somewhere far in the document, I want it to select the first cell with data (in my case it's a variable ExcelPasteTo), so that when the user open the file,it doesn't shift to cell AZX298, for example.

So far, i'm getting stuck at this line .Range(ExcelPasteTo).Select what's weird is, in the case, this code creates 2 files, first file has 1 sheet, second has 8 sheets. it works fine for the first file, selects the correct cell, saves, closes, opens the second one, pastes the data and then gets stuck at this line the error is Error 1004 Select method of Range class failed

So whenever I try to delete an existing item from the recycleview, I have to close the application and open it again to see the deletion. I want to make it so it will automatically refresh the recycleview and show the deletion.

To navigate the application, start by going to Record new Automation, then type a name at the top and press Save in the bottom right hand corner. Then you must close the application and reopen it before pressing Open old Automation. Then click on the item you made and press Delete at the bottom. As you can see, the data is deleted, but the visual has no updated.

kek.py

I had an existing pipeline which would build, test then deploy my application and clean my infrastructure, but then recently I've decided to add Doxygen to my project to generate the documentation for me. I added a step to the existing pipeline to generate the HTML, then publish the output to my gitlab pages. But after a few pipelines launched, I've waited after gitlab pages, and my output never got published. So my question is Why is my public directory never published to gitlab pages?

I currently have the following setup for gitlab CI configuration

My configuration for doxygen looks like this