Skip to content
Advertisement

Tag: excel-formula

How to use Array Spilling with Apache POI 5.1.0

Using Apache POI to generate excel files, is it possible to prevent Excel from adding the implicit intersection operator (@) inside formulas ? For instance, using the following code, what I want to do is copy all the values inside the columns from A to K, using Excel Array Spilling behaviour. However, when opening the file using Excel Desktop (version

Advertisement