ng-cells | AngularJS Table directive that draws a table of data | Grid library

HiHi, disclaimer: I have no experience with coding I have a code which takes values from cells (B2:C2) from multiple worksheets in a folder on my desktop and pasts it into the master workbook. This works great, however, I don't want the copied cells pasted consecutively down cells (F3:G3)- they need to be pasted into specific cells. This sounds complicated, and I'm sure it is. First, here's my base code which I have modified (from this code) to fit my needs:

I am developing an R Shiny application where I need to develop the following capability -

I need to copy rows of cells from Excel (one column at a time to start with) and paste them in Shiny maybe by using selectizeInput, textInput or textAreaInput.

How data looks like in Excel -

Image of data in Excel

Next I need to create a render datatable having this values in a single column spanning over as many rows as there were in the Excel sheet. So far, I have come across this question as reference but adding to this does not let me create the datatable as the output from this are all single vectors.

What I have tried so far -

I'm trying to figure out a better way to format cells using VBA. I'm trying to replace an Option button from Excel Forms Control (it works fine but is quite ugly. It looks like old W95). I'm not using activeX as I can't rely that every single user would be able to open this workbook if I use activex.
So, I was trying to use some VBA to format a cell like a pressed button. It was supposed to be easy with a SUB to format as a pressed and another to unpressed. But this code is running for not less than 13 seconds! It's not feasible.

I've made some research and found other topics, inclusing "VBA Code optimization" VBA code optimization

Other topics:
slow cell formatting using vba? But my case is just borders and cell color
Extremely slow VBA code when formatting cells From where I've got the optimatizaion code

Here is the code

I am using the splitting.js javascript library in my Rails 6 project. When I try to load the page I get "Uncaught TypeError: Splitting is not a function" in the console.

I have installed the javascript library using Yarn:

yarn add splitting

Splitting() is called with other Javascript in scripts.js which is required in my applicaiton.js file. I have configured my application.js file in a number of ways to try to fix the issue but to no avail. Here is my current iteration of this file (entire file included in case there are other interactions to consider):

I have a created a ag grid which flashes rows when they are updated, but I can see that the flash colour is blue by default. Is there a way of changing this colour? Example of the flash shown here: https://www.ag-grid.com/javascript-grid/flashing-cells/

Regarding my last query:

VBA Excel autopopulate new sheets based on the cell value for incrementing cells

I would like to have this sheet population in the correct order, as I have more than 1 sheet name to populate.

I have 2 sheets with the basic reference of the name. They are marked red in the image below:

After applying the code below:

I'm trying to achieve a similar goal to this question. The objective is to count the number of 1s with at least two direct neighbours (up, down, left, right), the only difference with my version is that there must be at least one cross or corner in the sequence.

For example,

This is my third question on this issue. So far there was no solution that didn't crash. I want to swipe-delete on a List with Toggles. My (simplified) code looks like this:

I have spent weeks trying to get this to work and have looked at many different suggestions on here, Apple developer forums, Google etc. and am still pulling my hair out. Any help would be greatly appreciated.

I have a ViewController that contains a TableView. It is not a full-screen tableView.

The tableView is built with customTableViewCells that each holds a CollectionView. The problem I have is that the self-sizing collectionView and the self-sizing tableView rows just don't seem to work. I've found a few options online but they only seem to partially work.

This is what I get when it initially runs:

I'm including a link to the project file as that's probably easier than copying code into here: https://www.dropbox.com/sh/7a2dquvxg62aylt/AACK_TjDxT9eOShZaKi7vLYga?dl=0

Some of the online 'workarounds' don't work in all cases - e.g. if you tap one of the buttons inside the CollectionView, it is removed and the collectionView (and subsequently the TableView) should resize but again I can't get this to consistently work.

Some of the solutions I've tried:

UICollectionView Self Sizing Cells with Auto Layout

UICollectionView inside a UITableViewCell -- dynamic height?

Dynamic height for a UITableView based on a dynamic collection view

Auto-sizing UITableViewCell which contains UICollectionView

Any help would be greatly appreciated.