Linking formulas?

[RGreensmith]

Py_XL/testingMakingConnections.py

Line 20 in 0b6e2c4

df.loc['1','A'] = sheet["B2"].value

[RGreensmith]

Need to set up such that correct cell is being referenced

[RGreensmith]

Can load xlsx as values or as formula.

Rewrite xslx for every calculation on habitat type - through loop (only 1 necessary) (extract all habitat types: col A in G-1 All habitats ~ and broad habitat type: Level 2 Label in G - 1 All Habitats) and populate with corresponding Distinctiveness etc.
1 - input new vars; 2 - calculates; 3 - extracts result and inputs into new csv (only need to extract the 1 cell, and extract as value, not formula)