I am experimenting with Aspose.Cells for Java before making a purchase. I have about 400 values of random data types that I need to push into a single column. Actually they are pulled from JSON as strings and some of them are blank/empty. What is the best way to load them into a column?
When using the ImportArray method (of stings) I am not getting what I expect. The values do not go in with the formatting that the underlying cell has specified. If I open the Excel file after saving it, select some of the problem cells, press “F2”, and then “Enter”, then Excel applies the correct formatting and the underlying calculations are performed. Also, the handling of empty strings is not as expected; the underlying calculations are not performed.
Also, for the empty strings, is there a method to delete a cell’s value?