Excel Js Api. Set Formula for a range of cells
I’m trying to set a formula for several columns of data using Excel js API. Below is working but performance is very poor as it updates on a onchanged event to refelect any change in the data. Is there a betterfaster way I can achieve this?
Get formatted value from worksheet cell in ExcelJS
Is there a way to get the formatted numerical value from a worksheet cell in ExcelJS? In the Excel workbook the cell formula results in value is 5.726027397260274, has a number format of “#,###.0” , and displays as “5.7”.