加載任何HTML與自閉標簽&把它轉換成Excel文件在Android應用程序

新的在這個版本是什麼?

Aspose開發團隊很高興宣布Aspose的新版本。細胞通過Java 18.12為Android。通過HTML頁麵描述的數據是非常常見的,然而這個頁麵可以打開在各種設備,包括手機、標簽和其他手持設備含有小屏幕。列的大小定義在“pt”,在許多情況下工作。但是可能有情況這固定大小可能不是必需的。例如,如果容器板寬度是600 px,這個HTML頁麵被顯示出來。在這種情況下,用戶可能會水平滾動條如果生成表的寬度更大。這個需求是解決通過提供可伸縮的單位更喜歡他們或百分比表示。空標簽是非常普遍的在處理HTML像我們可能麵臨或簡單。早些時候不支持自動關閉標簽但是現在提供這種支持。現在用戶可以加載任何HTML自動關閉的標簽並將它轉換成Excel文件。 Named regions can have English formulae and this file can be used in environments where systems are configured to German Locale. There is need to translate these English formulae completely to German language for correct usage in Excel configured for German language. This feature is fully functional and can be used without any extra coding. Excel provides custom filters like filter rows which begins with and ends with some specific string. Aspose.Cells provides rich features to manage shapes in the spreadsheet. Sometimes there is needed to get the connection points of a shape for aligning or placing the shapes at appropriate place. For this purpose all the connection points are required. Pivot tables are very common reports which are present in the workbooks. These reports are updated time by time and it is important to know the last time when report was updated for better decision making. Aspose.Cells has provided this feature by introducing property RefreshDate. Similarly name of the person who updated the pivot table is also provided as property RefreshedByWho. Smart art is used for better representation of information however earlier the text in the smart art shapes was fixed. This limitation is gone now as now smart art text can be updated. For this purpose shape.setText() function is introduced which sets new text in the smart art shape. Data validation is done in variety of ways to control the input in the Excel file. Like limit can be defined for a cell within which some number can be entered, otherwise error message is raised. Issues were faced for validation of large numbers like 12345678901 etc. in the past but now this much large numbers are supported by Aspose.Cells. Aspose.Cells has introduced rendering active worksheet in a workbook to SVG. For this purpose load an Excel file into workbook object and set the active sheet index like for Sheet2, set index to 1. Then save the Workbook as SVG which will render active worksheet to SVG. Workbook can have multiple sheets which are rendered as multiple tab pages when converted to HTML using Excel. Similarly if a workbook contains single sheet, it shows one tab page when converted to HTML using Excel. This conversion was working fine for multiple sheets while using Aspose.Cells. However for single sheet workbook, there was no tab page and only HTML file was created without creating the separate folder containing CSS. Now Aspose.Cells has enhanced its library to create similar output for single sheet workbooks as compared to output created by Excel. In complex Excel files (XLSM/XSLB) there can be large amount of macros which can be very very long. Many times there is a need to load the workbooks without loading these VBA projects like just extracting the sheet names from loaded workbook. In this case we need a filter which can load VBA projects in when they are actually required. This time Aspose.Cells has introduced a filter option LoadDataFilterOptions.VBA which can be used for this purpose. Textbox is very common control which can be used in a worksheet. This is not necessary that text in the textbox is fixed. It may have tags which can be replaced with some text at runtime. It helps users to configure the controls as per the data on the sheet or from some other source. Worksheet.replace can be used for this purpose and textbox can be set with the desired text. It can convert worksheet to HTML but rendering entire sheet at once may not be required always. Users may require just a selected area of the sheet to be rendered to HTML. Worksheets contain page setup where print area can be set. A worksheet can have different types of validations including dropdown. There can be a need where user may want to detect the type of validation and take some decision based on this information. This release includes plenty of improved features and bug fixes as listed below

•改變返回值獲取連接的點
•提供能力範圍導出為HTML
•數據酒吧XLSX被轉換為HTML時失蹤
•價值仍然存在當XLSX轉換為HTML
•左右絲帶形狀轉換為圖像
•Aspose。細胞for Java JavaDocs - missing package-list file
•字體不是一個有效的HTML5和自閉標簽和web瀏覽器歪曲其內容
•從XLSX讀取錯誤計數驗證值
•連續問題而把分隔符是不同的
•對日本地區日期格式是不正確的
•LightCells API未能加載大文件
•一個例外(StackOverFlow)提出了在保存為PDF輸出
•錯計算摘要值()
•與PasteType複製一個範圍。(粘貼選項)不能正常複製行高度
•超鏈接文本格式設置新的文本時丟失
俄羅斯•無效日期格式輸出
•問題SheetRender字體
•例外" . lang。OutOfMemoryError: Java堆空間”當呈現MS Excel文件為PDF
•引用出現在公式當檢索細胞通過Aspose.Cells公式
•使用條件格式時性能下降
•圖線是失蹤XLSX - > PNG轉換
•問題getActualChartSize方法
•插圖不複製工作簿時複製
•文本格式丟失excel的HTML輸出範圍
•圖標集成為偏差XLSX時轉換為HTML
•出口命名範圍數據不正確呈現HTML (Java)
•命名範圍問題
“getInCellDropDown•驗證總是返回true()的方法
•錯文化自定義格式返回不同地區(德國、法國、意大利和西班牙)
•e xcel PDF轉換測量圖表呈現的問題
•PDF引渡拋出OutOfMemoryError異常

其他最近的bug修複也包含在這個版本。

新添加的文檔頁麵和文章

一些新的技巧和文章已經被添加到Aspose。細胞為Androiddocumentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

——識別自閉標簽:https://docs.aspose.com/display/cellsjava/Recognise +自我+關閉+標簽

——獲得形狀的連接點:https://docs.aspose.com/display/cellsjava/Get +連接+點+ +形狀

概述:Aspose。細胞為Android

Aspose。細胞for Android is a MS Excel spreadsheet component that allows programmer to develop android applications for reading, writing & manipulate Excel spreadsheets (XLS, XLSX, XLSM, SpreadsheetML, CSV, tab delimited) and HTML file formats without needing to rely on Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, custom charts, spreadsheet formatting, drawing objects like images, OLE objects & importing or creating charts.

更多關於Aspose。細胞為Android

——Aspose主頁。細胞為Android:https://products.aspose.com/cells/android-java

——下載Aspose。細胞為Android:http://downloads.aspose.com/cells/android

——Aspose的在線文檔。細胞為Android:www.aspose.com/docs/display/cellsandroid/Home

Aspose企業有限公司成立於2002年3月在悉尼,澳大利亞。首先是企業門戶網站在2002年10月推出。Aspose致力於為全球提供最富有的組件選擇。net程序員。成千上萬的組織的國家獲得Aspose產品,包括微軟、IBM、普華永道、安永(Ernst & Young),杜邦,希爾頓酒店,《讀者文摘》,美國銀行(Bank of America),波音公司,西門子等。

Aspose企業有限公司
163套房,Longueville路79號
道灣,新南威爾士州,2066年
澳大利亞
電話:888.277.6734
傳真:866.810.9465

這個版本openPR發表。