Create data array automatically from MS Excel file

Tags: #<Tag:0x00007efc609e89b0>
#1

Hi there,

I have a very large MS Excel spreadsheet with over 5000 formulas. They are mainly repetitive calculations covering a period of 50 years and based on the previous year’s result.

I would like to convert this Excel spreadsheet into a handsontable spreadsheet and use it on my Bubble.io website.

I don’t want to have to manually enter the formulas for all 5000 cells in order to use it in Handsontable.

As shown here for example:
https://handsontable.com/docs/formula-calculation/#data-grid-example

Does anyone know if this can be automated in MS Excel via macro?

Ideally in the way that the macro automatically creates the data array shown in the example?

#2

Hi @tomnovo

I just replied to your question. I think that after we sort that subject out we can move further to formulas.

#3