samedi 16 mai 2020

ClosedXML: Detection of Formula in Excel Cell

I noticed that if an Excel cell contains a formula to generate a random uniform variate, i.e., =rand(), that ClosedXML will only read a 0 or 1 based on rounding off to the nearest integer. Question is, can the actual formula result be read in, or can the use of a formula be detected to tell the user e.g. "Use of formulas in an input Excel files is not recommended."




Aucun commentaire:

Enregistrer un commentaire