openPR Logo
Press release

Load any HTML with Self-Closing Tags & Convert It to Excel File inside Android Apps

01-28-2019 04:32 PM CET | IT, New Media & Software

Press release from: Aspose

What’s new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android via Java 18.12. Depiction of data through HTML page is very common, however this page can be opened in variety of devices including mobiles, tabs and other hand held devices which contain small screens. The size of the columns is defined in “pt” which works in many cases. However there can be case where this fixed size may not be required. For example if container panel width is 600px where this HTML page is being displayed. In this case users may get horizontal scrollbar if the generated table width is bigger. This requirement is addressed by providing scalable units like em or percent for a better presentation. Empty tags are very common while working with HTML like we can face or simply . Earlier self-closing tags were not supported however now this support is provided. Now users can load any HTML with self-closing tags and convert it to Excel file. 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

• Change returned value for getting Connection points
• Provide ability to export range as HTML
• Data bars are missing when XLSX is converted to HTML
• Value still exists when XLSX is converted to HTML
• Convert left right ribbon shape to image
• Aspose.Cells for Java JavaDocs - missing package-list file
• Font is not a valid HTML5 and self-closing tag and web browsers misrepresent its contents
• Wrong count of validation values is read from XLSX
• Issue while treating consecutive delimiters as distinct
• Date format is incorrect for Japanese locale
• LightCells API fails to load huge file
• An exception(StackOverFlow) raises when saving to PDF output
• Wrong value calculated by ROUNDUP()
• Copy a range with PasteType.ALL (Paste options) not copying row heights properly
• Hyperlink text formatting lost when new text is set
• Invalid Russian date format output
• Issue with SheetRender fonts
• Exception "java.lang.OutOfMemoryError: Java heap space" when rendering MS Excel file to PDF
• Quotes appear in formula when retrieving the cell formula via Aspose.Cells
• Performance degradation when using conditional formatting
• Chart line is missing in XLSX->PNG conversion
• Problem with getActualChartSize method
• SmartArt doesn't copy when workbook is copied
• Text formatting is missing in HTML output of excel range
• Icon Sets become misaligned when XLSX is converted to HTML
• Exporting named range data is not correctly rendered to HTML (Java)
• Named Range Issue
• Validation always returns true for 'getInCellDropDown()' method
• Wrong culture custom format gets returned for different locales (Germany, French, Italy and Spain)
• Excel To PDF conversion - Gauge chart rendering issue
• PDF rendition throws OutOfMemoryError exception

Other most recent bug fixes are also included in this release.

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for Android documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Recognize self-closing tags: https://docs.aspose.com/display/cellsjava/Recognise+self+closing+tags

- Get Connection points from shape: https://docs.aspose.com/display/cellsjava/Get+Connection+points+from+shape

Overview: Aspose.Cells for Android

Aspose.Cells 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.

More about Aspose.Cells for Android

- Homepage of Aspose.Cells for Android: https://products.aspose.com/cells/android-java

- Download Aspose.Cells for Android: http://downloads.aspose.com/cells/android

- Online documentation of Aspose.Cells for Android: www.aspose.com/docs/display/cellsandroid/Home

Aspose Pty Ltd was founded in March 2002 in Sydney, Australia. The corporate portal was firstly launched in October 2002. Aspose strives to provide the richest component choices for global .NET programmers. Thousands of organizations from tens of countries have acquired Aspose products, including Microsoft, IBM, PricewaterhouseCoopers, Ernst & Young, DuPont, Hilton Hotels, Reader's Digest, Bank of America, Boeing, Siemens, etc.

Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Phone: 888.277.6734
Fax: 866.810.9465

This release was published on openPR.

Permanent link to this press release:

Copy
Please set a link in the press area of your homepage to this press release on openPR. openPR disclaims liability for any content contained in this release.

You can edit or delete your press release Load any HTML with Self-Closing Tags & Convert It to Excel File inside Android Apps here

News-ID: 1537893 • Views: 282

More Releases from Aspose

Read/Write Projects Created using MS Office 365 Project Online Service using .NE …
What's New in this Release? Aspose team is pleased to announce the new release of Aspose.Tasks for .NET 19.2. This release includes support for Microsoft Project Online, MPP files saved with Microsoft Office 365 cloud are supported now. Also fixes few issues reported with the API that further enhance the stability of the API. Aspose.Tasks for .NET API now supports Microsoft Office 365 Project Online Services. Now the users shall
aspose.cloud Newsletter February 2019: Work with Cloud File Format REST APIs & S …
Aspose.Cloud Newsletter for February 2019 has now been published that highlights all the newly supported features offered in the recent releases. It also includes information about Cloud REST API and SDKs for working with Microsoft Visio Diagrams, Reordering multiple PowerPoint slides in one Cloud REST API call, Convert HTML to Markdown and MHTML formats in cloud applications and much more. Cloud REST API and SDKs for working with Microsoft Visio Diagrams Manipulate
Aspose.Newsletter February 2019: Enhance Productivity using JDK 11 Compatible PD …
Aspose Newsletter for February 2019 has now been published that highlights all the newly supported features offered in the recent releases. It includes information about Enhancing productivity & performance using JDK 11 compatible PDF API, Loading Excel workbook efficiently without loading VBA project, Use latest version of Aspose.PDF for C++ with new codebase changes, Create PST folder hierarchy with string notation, Detect archive-based file format and work with AMF files
Create a Folder Hierarchy in PST Files using String Notation inside .NET Apps
What's New in this Release? Aspose team is pleased to announce the release of Aspose.Email for .NET 18.12. This release adds an overload to AddSubFolder(string name, bool createHierarchy) and CreatePredefinedFolder(string name, StandardIpmFolder defaultFolder, bool createHierarchy) functions that enable users to create folder hierarchy using string notation as shown in the code example on blog announcement page. By setting the second parameter of AddSubFolder() to true, users can create folder hierarchy using

All 5 Releases


More Releases for Cells

Competent Cells Market Report 2018: Segmentation by Type (Cloned Competent Cells …
Global Competent Cells market research report provides company profile for Thermo Fisher Scientific, Inc., Agilent Technologies, Inc., Bio-Rad Laboratories, Inc., Merck & Company, Inc., Illumina, Inc., Promega Corporation, New England Biolabs, OriGene Technologies, Inc., Zymo Research Corporation, Scarab Genomics, LLC, Meridian Bioscience, Inc. and Others. This market study includes data about consumer perspective, comprehensive analysis, statistics, market share, company performances (Stocks), historical analysis 2012 to 2017, market forecast 2018 to
Precious metal destroys cancer cells
University of Warwick researchers developed an organo-metal compound coded as FY26 to infiltrate cancer cells and activate cellular mitochondria to destroy cancer cells. To date, FY26 has been tested in ovarian cancer cells and has been deemed 50 times more effective and cheaper than other chemotherapy drugs. Can a newly discovered metallic compound vastly improve the treatment of ovarian cancer? For more information, please visit our newsroom section here: https://goo.gl/RyttKs Spire Research and Consulting
Stem Cells Industry Forecast Report 2017-2022
ReportsWeb.com has announced the addition of the “United States Stem Cells Market Report 2017” The report focuses on United States major leading players with information such as company profiles, product picture and specification. Geographically, this report splits the United States market into seven regions: The West, Southwest, The Middle Atlantic, New England, The South and The Midwest. with sales (volume) , revenue (value) , market share and growth rate of Stem
Natural Killer Cells Market
Natural killer cells are a form of granular lymphocytes of varying sizes that play an important role in innate immunity in the human body. They typically constitute of around 10% of total blood lymphocytes as compared to around 70% and 20% of T cells and B cells, respectively. Natural killer cells are cytotoxic in nature and are able to kill their targets cells by two different mechanisms: as antibody dependent
Natural Killer Cells Market
Natural killer cells are a form of granular lymphocytes of varying sizes that play an important role in innate immunity in the human body. They typically constitute of around 10% of total blood lymphocytes as compared to around 70% and 20% of T cells and B cells, respectively. Natural killer cells are cytotoxic in nature and are able to kill their targets cells by two different mechanisms: as antibody dependent
PharmaPoint : Global Stem Cells Sales Market 2017
ALBANY, NY, May 29, 2017 : Recent research and the current scenario as well as future market potential of "Global Stem Cells Sales Market Report 2017" globally. In this report, the global Stem Cells market is valued at USD XX million in 2016 and is expected to reach USD XX million by the end of 2022, growing at a CAGR of XX% between 2016 and 2022. Geographically, this report split global into