在从HTML导入时避免大数字的指数表示
Contents
[
Hide
]
有时您的HTML中包含长达15位数的数字1234567890123456，当您将HTML导入到Excel文件时，这些数字会转换为1.23457E+15这样的指数表示。如果您希望数字被原样导入而不是转换为指数表示，则请在加载HTML时使用HTMLLoadOptions.keep_precision属性并将其设置为true。
以下示例代码说明了HTMLLoadOptions.keep_precision属性的用法。API将原样导入数字，而不将其转换为指数表示。
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from aspose.cells import HtmlLoadOptions, LoadFormat, SaveFormat, Workbook | |
| from io import BytesIO | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # 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) |