cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Formula results

Kurtis_R
New Contributor II

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.

 

Kurtis_R_0-1725568966348.png

Kurtis_R_1-1725569630650.png

 

 

2 REPLIES 2

User16756723392
New Contributor III

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

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.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group