Excel Formula results

[Kurtis_R]

Hi all,

Just wanted to raise a question regarding Databricks workbooks and viewing the results in the cells. For the example provided in the screenshot I want to view the results of an excel formula that has been applied to a cell in our workbooks. For our business case we want to retain the excel formulas on our input files so if we can apply the formulas and use the returned values would be prefered. For the example provided I would want to know if/how it's possible to get the value of 45 in cell B13 on databricks. Many thanks.

[User16756723392]

@Kurtis_R do you want to display the value of 45 or formula of how 45 is achieved.?

[Kurtis_R]

Hi, I was asking if it's possible in the case of reading in an excel file using formulas into a Datatable. So in the above case reading in the formula but then actually running that formula to get the result of 45 for =SUM(B1:B10). We can manually calculate the total in databricks, but if then go to write that dataframe to excel that formula is lost where our client wants to retain that formula. Currently we can write the formula into a cell, but then upon viewing the excel file it is protected, thus formulas do not run meaning if we then try to read that file back in we get the excel formula in that cell instead of 45.