Optimize Memory for Existing Worksheets with Aspose.Cells for Java 8.0.1

aspose Cells for Java 100 Optimize Memory for Existing Worksheets with Aspose.Cells for Java 8.0.1 Aspose.Cells for Java 8.0.1 has been released, and we are pleased to announce that this month’s release has brought many useful improvements and features. You can immediately download the latest Aspose.Cells for Java release from the download section, and start exploring the features & enhancements we’ve added.

Here is a look at just a few of the biggest features in this month’s release. For a full list of bug fixes and improvements please refer to the download page in the link above.

Optimize Memory for Existing Worksheets

With release 8.0.0, Aspose.Cells for Java provided memory optimization settings for newly created worksheets by exposing the setMemorySetting method for the Workbook.Settings class. The previously provided approach was useful for minimizing the overall memory cost while working with existing large Excel spreadsheets containing huge data sets.

With this release, we have enhanced this feature for existing worksheets by exposing a similar property for the Cells class. Now you may use setMemorySetting method provided by the Cells class to cope with the memory issues for situations where large data sets have to be built in memory. The setMemorySetting method accepts a parameter of type MemorySetting with the default value NORMAL. In order to properly utilize this newly introduced feature, memory optimization settings have to be explicitly specified for existing worksheets. Please check the detailed technical article on how to optimize the memory while working with large data sets.

Enhancements for the License Class

The Aspose.Cells for Java API has enhanced the licensing mechanism with the release of 8.0.1. Now when a license file name is passed to the License.setLicense method without specifying in which directory it resides, the API will search for the license in the same folder that the Aspose.Cells Jar is in. This enhancement was made in order to meet the standards set by Aspose components.

Identify Corrupted Excel Files

We have also enhanced the CellsException class to identify potentially damaged or corrupted files when loaded with the Workbook constructor. Previously, the API could load any corrupted file but would sometimes throw an error when saving it after performing manipulation. With the new enhancements integrated, Aspose.Cells for Java API now throws an error of type CellsException whenever it encounters a damaged file.

The CellsException class can also handle irrelevant file formats (other than spreadsheets) while loading them into an instance of Workbook.

Bug Fixes

Aspose.Cells for Java 8.0.1 has provided fix for several important issues, such as a couple of problems related to the PDF rendering engine, rendering & manipulating charts, retrieving & removing OleObjects. Last but not least, we have just integrated an overhaul of our existing formula engine which improves the overall performance as well as the accuracy of results when working with Excel formulas.

As always we appreciate your feedback so if you ever have anything to tell us about this release or anything else, please head to the Aspose.Cells support forum for a chat.

Posted in Aspose.Cells Product Family, Babar Raza | Tagged , , , , , , , , , , , , , , | Leave a comment

Set Pixel Format for the Rendered Image in Worksheet to Image Conversion with Aspose.Cells for .NET 8.0.1

aspose Cells for net 100 Set Pixel Format for the Rendered Image in Worksheet to Image Conversion with Aspose.Cells for .NET 8.0.1Aspose.Cells for .NET 8.0.1 has been released. This new release supports a number of new features and enhancements.  It also includes over 30 new fixes and improvements. Moreover, we have fixed some bugs in the Grid suite provided by Aspose.Cells for .NET and improved the performance of the web based grid control to load and manipulate bigger Microsoft Excel files.

Set Pixel Format for the Rendered Image

Aspose.Cells allows you to set the pixel format for a rendered image. You may specify your desired pixel format when rendering worksheet to image format. By default, Aspose.Cells uses 32 bits per pixel, you may set your desired pixel format (bit depth) using the respective options provided by Aspose.Cells for the rendered image.

Optimize Memory for the Existing Sheets

Now you can also change the memory settings of the existing sheets in a workbook. While building a workbook with large cells data set, you may utilize the options provided by Aspose.Cells which can be adopted to cope with the memory issues. Aspose.Cells provides the MemorySetting.MemoryPreference option that you may also set for the Aspose.Cells.Cells object which will optimize memory usage for the cells data to decrease the overall memory cost to certain extent. Please see the document on Optimizing Memory Usage while Working with Big Files.

Fixes and Other Enhancements

In the new version, we have fixed a few exceptions in reading and writing Microsoft Excel file formats and converting Excel files to PDF format.

In this release, several important issues have been addressed. For example, issues around reading and writing Microsoft Excel file formats, Smart Markers, applying style and formatting, rendering and manipulating pivot tables, rendering images from Excel worksheets, reading and writing HTML files, rendering and manipulating Charts and shapes, rendering images files from charts, deleting columns and exporting Excel workbooks to PDF format have been resolved. A few enhancements have also made to Aspose.Cells for .NET’s formula calculation engine to improve its performance when calculating formulas.

We also fixed a few bugs in the web based Grid control provided by Aspose.Cells for .NET regarding TableItemStyle and rendering shapes.

To see a complete list of enhancements and fixes, and to download Aspose.Cells for .NET 8.0.1, please visit the download page.

Posted in Aspose.Cells Product Family | Leave a comment

DNN Import from Microsoft Word using Aspose.Words

aspose words for net DNN Import from Microsoft Word using Aspose.Words

Aspose DNN Microsoft Word Import Module allows developers to get/read contents of Microsoft Word (doc/docx) document without Microsoft Office. This module demonstrates the powerful i0mport feature provided by Aspose.Words. It adds a simple file browser control and Import from Word button on the page where the module is added. When clicking the button, users get the document contents displayed on screen immediately.

Aspose DNN Microsoft Word Import Module 300x101 DNN Import from Microsoft Word using Aspose.Words

Aspose DNN Microsoft Word Import Module

Aspose DNN Microsoft Word Imported Content 300x156 DNN Import from Microsoft Word using Aspose.Words

Aspose DNN Microsoft Word Imported Content

Installing the Aspose DNN Microsoft Word Import Module

Download the Aspose DNN Microsoft Word Import module from one of the following locations:

Once downloaded, please follow these steps to install the module into your DNN website:

  1. Log into your site as either Host or another Superuser level account.
  2. Navigate to the Host menu and select Extensions.
  3. Click Install Extension Wizard.
  4. As directed, browse to the location of the downloaded ZIP file, select it and click Open.
  5. Click Next, accept the license, continue through the installation.
  6. When finished click the Return button.

Please check this module installation video from DNN for more details

Using Aspose DNN Microsoft Word Import Module?

After you have installed the Aspose DNN Microsoft Word Import module it is really simple to start using it on your website. Please follow these simple steps to get started:

  1. Make sure you are logged-in to DNN as ‘Host’ or ‘Admin’ level account.
  2. Navigate to the page you want to add the Import module to.
  3. Select Modules, followed by Add New Module from the top ribbon.

    Aspose DNN Microsoft Word Import add module to page 300x125 DNN Import from Microsoft Word using Aspose.Words

    Aspose DNN Microsoft Word Import add module to page

  4. From the list select ‘Aspose DNN Microsoft Word Import’ and drag it to a place of your choice on the page.

You have successfully added Aspose DNN Microsoft Word Import to your page. A file browse and a button titled Import from Word will now appear on the page. Anyone can simply select a Microsoft Word (doc/docx) file and click on the Import from Word button to list the content of the selected document on the page.

Video

Please check the video below to see it in action.

Posted in Aspose.Words Product Family | Tagged , , , , | Leave a comment

Heartbleed bug – Aspose APIs are not affected with the vulnerability

The Heartbleed bug is a security vulnerability recently discovered in the OpenSSL library. Detailed information about Heartbleed bug can be found at Heartbleed.com and Wikipedia.com.

We’re pleased to share with our customers that Aspose’s downloadable and Cloud APIs are not affected by this security bug. In general, Microsoft Windows and IIS are not impacted with this vulnerability. As we use Windows and IIS for all the development and deployments our systems were not impacted. Aspose customers should not be concerned about this security flaw as far as Aspose APIs and Cloud services are concerned.

Aspose makes sure that all the products and services we provide to our customers are safe and secure in every way. We take appropriate measures to make sure all the data and files shared by our customers are also safe and secure. You might want to check Aspose’s EULA for more information.

In case you have any questions or concerns, please contact the sales team. If you have any technical questions about Aspose products, please contact the support team. We’ll be happy to help and guide you.

###END###

About Aspose

Aspose create file format APIs. They offer a powerful set of file management libraries with which developers create applications that can open, edit, create and save some of the most popular business file formats.

The product range includes APIs for working with Microsoft Excel spreadsheets, word processing files, Microsoft PowerPoint presentations, PDFs, email management, OCR/OMR, image manipulation and barcode generation and recognition. Supported formats include Microsoft Word documents, Excel spreadsheets, PowerPoint presentations, Project and Visio files, PDF documents, RTF, TXT, CSV, GIF, PNG, JPG, TIFF and a long list of others.

Aspose produce components for .NET, Java, Cloud, Android and SharePoint as well as rendering extensions for SQL Server Reporting Services and JasperReports exporters. Aspose.Total compiles all products for a platform into a powerful toolbox.

Aspose Pty Ltd has been operating since 2002. The headquarters are in Australia and the company has teams in America, Europe and Oceania.

Press Contact

Email: press@aspose.com
Web: www.aspose.com
Telephone (America): +1 888 277 6734
Telephone (Europe): +44 141 416 1112
Telephone (Oceania): +61 2 8003 5926

Posted in Aspose.Total Product Family, News Release | Leave a comment

Compare Aspose for Java with Apache POI Features and Usage

Aspose for Java

aspose total for java21 Compare Aspose for Java with Apache POI Features and UsageAspose provides a wide range of Java APIs for developers to create and manage various types of applications that deals with files and different formats.

Aspose facilitates the Java developers with Aspose.Total which includes following easy to use, efficient and separately downloadable components:

  • Aspose.Cells to deal with Microsoft Excel® and OpenOffice spreadsheets.
  • Aspose.Words for Microsoft Word and OpenOffice documents.
  • Aspose.Slides for Microsoft PowerPoint and OpenOffice presentation files.
  • Aspose.Pdf to create and manipulate PDF documents.
  • Aspose.BarCode for generation and recognition of barcodes.
  • Aspose.Tasks to deal with Microsoft Project®.
  • Aspose.Email to read and write email messages in various formats without Microsoft Outlook.
  • Aspose.OCR for optical character and marker recognition.
  • Aspose.Imaging to create, edit, draw and convert images.

Apache POI

apache poi Compare Aspose for Java with Apache POI Features and UsageThe Apache POI Project’s mission is to create and maintain Java APIs for manipulating various file formats based upon the Office Open XML standards (OOXML) and Microsoft’s OLE 2 Compound Document format (OLE2).

You can read and write Microsoft Excel, Microsoft Word and Microsoft PowerPoint files using Java. For each Microsoft Office application there exists a component module that attempts to provide a common high level Java API to both OLE2 and OOXML document formats.

Aspose for Apache POI

Project Aspose for Apache POI shows how different functionalities can be achieved using Aspose Java APIs in comparison with Apache POI. Examples with their source codes are hosted on CodePlex, GitHub, Bitbucket and SourceForge.

These examples are also available at CodePlex, GitHub, Bitbucket and SourceForge.

Aspose has many more features  than Apache POI to fulfill developer requirements. To highlight some of these features, following are few examples of  each module.

You can review and download these examples at CodePlex, GitHub, Bitbucket and SourceForge.

These examples are helpful for developers who want to compare Apache POI with Aspose or migrate from Apache POI to Aspose.

Learn more about Aspose.

Posted in Aspose.Total Product Family | Leave a comment

Add, Update or Delete Excel Charts and Chart Legends using Aspose for Cloud 1.1.6.6

asposeCloudAPIs Add, Update or Delete Excel Charts and Chart Legends using Aspose for Cloud 1.1.6.6We are pleased to announce the release of Aspose for Cloud 1.1.6.6. With this release, the create, read, manipulate and export features are greatly improved.

You can add or delete Microsoft Excel charts and read, show, hide or update chart legends. Some bugs have also been fixed. Below are lists of enhancements by API.

Aspose.Cells for Cloud

  • Add Charts – This feature allows you to add a new chart in a worksheet. The charts resource can be used and a PUT request can be sent (specifying data for chart series and other chart options) to add a new chart.
  • Delete Charts – This feature allows you to delete all charts from a worksheet. The charts resource can be used and a DELETE request can be sent to delete all charts.
  • Show Chart Legend – This feature allows you to show a chart legend on a chart in a worksheet. The legend resource can be used and a PUT request can be sent to show chart legend.
  • Hide Chart Legend – This feature allows you to hide a chart legend in a worksheet. The legend resource can be used and a DELETE request can be sent to hide chart legend.
  • Update Chart Legend – This feature allows you to update a chart legend on a chart in a worksheet. The legend resource can be used and a POST request can be sent (specifying updated values in the request body) to update chart legend.
  • Read Chart Legend – This feature allows you to read information of a chart legend from a worksheet. The legend resource can be used and a GET request can be sent for this purpose.

Aspose.Slides for Cloud

Aspose.Slides for Cloud’s codebase has been updated to improve Microsoft PowerPoint presentation conversion to PDF and fix some rendering bugs.

Aspose for Cloud Platform

A bug related to sign up using a Facebook account has been fixed.

Posted in Aspose for Cloud APIs, Muhammad Ijaz | Leave a comment

Configure Threshold for Optical Markers with Aspose.OCR for Java 1.9.0

aspose OCR for Java 100 Configure Threshold for Optical Markers with Aspose.OCR for Java 1.9.0We are pleased to announce the release of Aspose.OCR for Java 1.9.0. This month’s release contains all the features, enhancements and bug fixes from Aspose.OCR for .NET 1.8.0 and 1.9.0.

This outlines the most significant changes. Check the detailed release notes for all enhancements and fixes when downloading the latest version of Aspose.OCR for Java 1.9.0.

Optical Mark Recognition Threshold

The threshold specifies the percentage of black pixels over which the option is considered to be selected. Setting a lower threshold allows the OmrEngine to consider any partially filled marker as selected; a higher threshold may require the marker to be filled completely. Usually the threshold is set to an acceptable higher average value before initializing the OMR procedure to determine the amount of pixels (as a percent) that is required before a field or a mark is considered checked or filled. Aspose.OCR for Java now supports setting the threshold for a template, template page and even for a specific template element . Please check the detailed article on Setting OMR Thresholds.

Equal Spacing Between the Markers

This enhancement has been made for the OmrEngine to accommodate markers that are equally distributed on the OMR template. Unfortunately, the Template Editor for the Java version of the product isn’t yet available for public use. We are working to provide a Java based template editor with future releases of Aspose.OCR for Java.

Please visit the documentation for details, and if you still have any questions, we always welcome inquiries on Aspose.OCR Support Forum.

Posted in Aspose.OCR Product Family, Babar Raza | Tagged , , , , , , , , , | Leave a comment

Partial Support for EUDC Fonts, Best Fit Position of Data Labels in Pie Chart & Insertion of OLE Objects in Aspose.Words 14.3.0

aspose.words logo Partial Support for EUDC Fonts, Best Fit Position of Data Labels in Pie Chart & Insertion of OLE Objects in Aspose.Words 14.3.0Aspose.Words 14.3.0 has been released with this month’s release containing over 95 useful new features, enhancements and bug fixes to the Aspose.Words products.

You can download the latest releases of Aspose.Words from the following links:

Here is a look at just a few of the biggest features in this month’s release. For a full list of bug fixes and improvements please refer to the download pages in the links above.

Insert Embedded or Linked OLE Objects

Aspose.Words now supports insertion of OLE objects such as another Microsoft Word document or an Microsoft Excel chart. A new public method, InsertOleObject, has been introduced in the DocumentBuilder class. This method can be used to insert an embedded or linked OLE object from a file into a Word document.

The following code inserts embedded Excel 97-2003 document as iconic OLE object from stream using predefined image.

Document doc = new Document();
DocumentBuilder builder = new DocumentBuilder(doc);
Stream memoryStream = File.OpenRead(MyDir + "Book1.xls");
Shape oleObject = builder.InsertOleObject(memoryStream, "Excel.Sheet.8", true, null);
doc.Save(MyDir + @"out.docx");

The following code inserts linked Word document from file as normal OLE object using custom presentation image.

Document doc = new Document();
DocumentBuilder builder = new DocumentBuilder(doc);
Image image = Image.FromFile(MyDir + "Aspose.Words.png");
Shape oleObject = builder.InsertOleObject(MyDir + "Doc1.docx", true, false, image);
doc.Save(MyDir + @"out.docx");

EUDC Fonts Partial Support Added

Aspose.Words’ rendering engine now partially supports EUDC (End-User-Defined-Characters) fonts. Please find below the description of how EUDC fonts works on Windows (Microsoft Word also seems to follow this logic in general):

End-User-Defined and Private Use Area Characters

In this first implementation, Aspose.Words uses a single EUDC font. When rendering a document to fixed-page formats, this font is searched among the specified font sources by “EUDC” family name.

Best Fit Position of Data Labels in Pie Chart Partially Supported

Starting from Aspose.Words 14.3.0, Best Fit position of data labels in pie charts is partially supported. In previous versions labels with best fit position were rendered as if they had the inside end position. Currently we use a modified Open Office algorithm to set the best fit position of data labels. Here are a few examples:

1. Best fit position of data labels of 2D Pie chart:

TestDataLabelBestFitPosition Pdf 0 Gold Partial Support for EUDC Fonts, Best Fit Position of Data Labels in Pie Chart & Insertion of OLE Objects in Aspose.Words 14.3.02. Best fit position of data labels of 3D Pie chart:

TestDataLabelBestFitPosition Pdf 1 Gold Partial Support for EUDC Fonts, Best Fit Position of Data Labels in Pie Chart & Insertion of OLE Objects in Aspose.Words 14.3.0

Posted in Aspose.Words Product Family | Leave a comment

DotNetNuke Export to Microsoft Word and PDF using Aspose.Words

aspose words for net DotNetNuke Export to Microsoft Word and PDF using Aspose.WordsAspose DotNetNuke Content Export Module allow users to export online content into Microsoft Word or Adobe Acrobat PDF documents using Aspose.Words. This module makes it very easy to have an offline copy of your favorite online content for editing, sharing and printing in the popular DOC or PDF formats. It adds Export to Word and Export to Pdf buttons at any desired location on the page. Clicking a button dynamically exports the content of the page to a Word or PDF document and then automatically downloads the file to the disk location selected by the user in just couple of seconds.

Aspose DotNetNuke Content Export to word and pdf 300x116 DotNetNuke Export to Microsoft Word and PDF using Aspose.Words

Aspose DotNetNuke Content Export to Word and Pdf

Aspose DotNetNuke Content Export doc file save 300x227 DotNetNuke Export to Microsoft Word and PDF using Aspose.Words

Aspose DotNetNuke Content Export doc file save

Installing the Aspose DotNetNuke Content Export Module

You can download the Aspose DotNetNuke Content Export module from one of the following locations:

Once downloaded, please follow these steps to install the module into your DotNetNuke website:

  1. Log into your site as either Host or another super-user level account.
  2. Navigate to the Host menu and select Extensions.
  3. Click Install Extension Wizard.
  4. As directed browse to the location of the downloaded zip file, select it then click Open.
  5. Click Next, accept the license, continue through the install. When finished click the Return button.

Please check this module installation video from DotNetNuke for more details

Using the Aspose DotNetNuke Content Export Module

After you have installed the Aspose DotNetNuke Content Export module it is really simple to start using it on your website. Please follow these simple steps to get started:

  1. Make sure you are logged-in to DotNetNuke with a Host or Admin level account.
  2. Navigate to the page where you want to add the Export module.
  3. Select Modules followed by Add New Module from the top ribbon.

    Aspose DotNetNuke Content Export add module to page 300x125 DotNetNuke Export to Microsoft Word and PDF using Aspose.Words

  4. From the list, select ‘Aspose DotNetNuke Content Export’ and drag it into position.

You have successfully added Aspose DotNetNuke Content Export to your page. Two buttons, Export to Word and Export to Pdf, now appear on the page. Anyone can simply click on either of these buttons and export the content of the page into a Word or PDF document.

Video

Please check the video below to see the plugin in action.

Posted in Aspose.Words Product Family | Tagged , , , , , | Leave a comment

Aspose.Pdf for Java 9.0.0 Introduces Changing the Color Space of PDF Document

aspose Pdf for Java 100 Aspose.Pdf for Java 9.0.0 Introduces Changing the Color Space of PDF DocumentWe are pleased to announce the release of Aspose.Pdf for Java 9.0.0. It includes some new exciting features, enhancements and fixes to issues reported in earlier versions of Aspose.Pdf for Java, along with a change of release numbering. As the Java version is ported from Aspose.Pdf for .NET, its version number has been changed to reflect the .NET version it comes from. You can download the latest release of Aspose.Pdf for Java from the download section.

Changing color space of PDF document is one of the exiting features introduced in this version. The maximum number of columns limit in a table has been increased to 512 and we have made further progress on porting new classes and methods from Aspose.Pdf for .NET to the Aspose.Pdf for Java architecture. The complete details of these changes can be found in Public API Changes in Aspose.Pdf for Java 9.0.0.

Following are the some of the new features/enhancements this month’s release. For a full list of bug fixes and improvements please refer to the download pages in the link above.

Export/Import Bookmarks

The methods exportBookmarksToXML(...) and importBookmarksWithXML(...) with Stream arguments are implemented in the PdfBookmarkEditor class. So now extracted bookmarks can be saved into stream object can be import into stream from XML file.

Export  Bookmarks

//Create PdfBookmarkEditor object
PdfBookmarkEditor bookmarkeditor = new PdfBookmarkEditor();
//Open PDF file
bookmarkeditor.bindPdf("Input.pdf");
OutputStream os = new FileOutputStream("bookmark.xml");
bookmarkeditor.exportBookmarksToXML(os);
bookmarkeditor.dispose();

Import Bookmarks

//Create PdfBookmarkEditor object
PdfBookmarkEditor bookmarkeditor = new PdfBookmarkEditor();
//Open PDF file
bookmarkeditor.bindPdf("Input.pdf");
InputStream is = new FileInputStream("bookmark.xml");
bookmarkeditor.importBookmarksWithXML(is);
bookmarkeditor.save("output.pdf");

For more information, please take a look at Working with Bookmarks.

Posted in Aspose.Pdf Product Family, Aspose.Total Product Family | 1 Comment