Hi support Team, I’m currently trying to use Aspose.cells to read a HTML spreadsheet however during the reading of this file the leading zeros of the numbers in the data is removed.
I believe this is due to Aspose trying to read the data as a number type. At the moment I’ve been forced to use a workaround in which I appending an apostrophe to the front of the numbers seems to force Aspose to read the values a string however this is not ideal.
When using the in browser Aspose Convert function to convert the html file to an xls it also removes the leading zeros.
Since I’m unable to upload the HTML format to this ticket I’ve included an image what the HTML spreadsheet looks like below:
image.png (2.4 KB)
Do you have any suggestions on how to fix this issue?