How to aggregate data by referring to multiple sheets in Google Spreadsheet using multiple functions

  Problem Statement: Suppose you are running a small business or creating a timesheet based cost calculations in any organization as a Lead, then you may need to refer data from different sheets within a single google spreadsheet to get the desired output/result. Also, there might be a case where you want to see and manage the...

by Gaurav Bagla
Tag: excel


Generate Excel Sheet with Formula embedded in it

Recently in our application, we needed to generate an excel sheet where some of the values for the column needed to be calculated on the basis of values of other columns depending upon an embedded formula in the excel sheet. To work with excel file we need the following in your BuildConfig.groovy: [java] dependencies{ compile...

by Tanu Siwag
Tag: excel