Html den içe aktarırken büyük sayıların üstel gösterimini önleme

Contents
[ ]

Aşağıdaki örnek kod, HTMLLoadOptions.keep_precision özelliğinin kullanımını açıklar. API sayıyı üstel gösterime dönüştürmeden içe aktarır.

from aspose.cells import HtmlLoadOptions, LoadFormat, SaveFormat, Workbook
from io import BytesIO
# Output directory
outputDir = "./"
# Sample Html containing large number with digits greater than 15
html = "<html><body><p>1234567890123456</p></body></html>"
# Convert Html to byte array
byteArray = html.encode("utf-8")
# Set Html load options and keep precision true
loadOptions = HtmlLoadOptions(LoadFormat.HTML)
loadOptions.keep_precision = True
# Convert byte array into stream
stream = BytesIO(byteArray)
# Create workbook from stream with Html load options
workbook = Workbook(stream, loadOptions)
# Access first worksheet
sheet = workbook.worksheets[0]
# Auto fit the sheet columns
sheet.auto_fit_columns()
# Save the workbook
workbook.save(outputDir + "outputAvoidExponentialNotationWhileImportingFromHtml.xlsx", SaveFormat.XLSX)