Using the setSkipBlanks paste option does not work with Aspose Cells 24.7. Below is sample Java code and a ZIP containing the input and output Excel files that demonstrate this issue:
public static void main(String[] ar…...get(1); Range targetRange = targetSheet.getCells()...getCells().createRange(0, 0, 2, 2); Range sourceRange = sourceSheet.getCells()...