Retrieve SQL Connection Data & Print Desired Number of Pages in Android Apps

What’s new in this release?

The long awaited version of Aspose.Cells for Java 7.7.0 has been released. In this release, we have added a feature that lets you retrieve external data source details. Sometimes, you may want to retrieve details from external data sources, for example if you want to read the SQL connection data. This may include any or all type of data that is required to establish a connection with an SQL Server, such as the server URL, user name, underlying table name, SQL query, query type, the location of the table, etc. In the new version, you can limit the number of pages generated in Excel to PDF conversion. You can print a range of pages to the output PDF file using this new feature. Aspose.Cells allows you to set a limit on how many pages are generated when converting a Microsoft Excel spreadsheet to PDF file format. We have also added a number of enhancements in the new release. We have improved the chart to image and sheet to image modules. This release is also a maintenance release that contains fixes for issues reported in earlier versions. In this release, we have fixed the issues with manipulating charts and shapes. Several other important issues have also been addressed. For example, issues to do with rendering Microsoft Excel file formats, rendering images from Excel worksheets, rendering shapes and controls and exporting Excel workbooks to PDF format have been resolved. A few improvements have also been made to Aspose.Cells for Jav’s formula calculation engine. This release includes plenty of improved features and bug fixes as listed below

• Retrieving SQL Connection Data
• Aspose.Cells saving as TIFF - missing resolution tag
• Chart Image Mapping for all Chart Types
• Conversion to TIFF: setting PhotometricInterpretation tag
• Limiting the number of pages generated when converting to PDF
• Value read after calculation is corrected
• Incorrect output of Style.getCultureCustom() is fixed
• Value read after calculation corrected
• IF Calculation Error is resolved
• Column formattings were now re-saved correctly
• Column formattings were now re-saved correctly
• Shape object in Excel form now getting word-wrapped
• AreaChart transparency is fixed and working
• Active-X objects are changed to images
• Cells.MaxDataRow gave corrected value
• While converting XLSX to PDF, one Japanese character gets missing is fixed
• Greater than calculation calcullation
• setPrintGridlines now working in Sheet-to-Image feature
• Charts by page margin now rendered when converting to image/PDF format
• DisplayRightToLeft problem for SheetRender is fixed
• Wrong calculated value of Yield function is fixed
• Cells RTL problem fixed - Sheet to Image

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

Overview: Aspose.Cells for Java

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics

Read more about Homepage of Aspose.Cells for Java

Add, Delete or Get Attachments from PDF Document in Android & Java Apps

This technical tip shows how to work with attachment in a PDF document using Aspose.Pdf. Developers can add, delete, get attachment from a PDF file. In order to add attachment in a PDF document, you need to create a FileSpecification object with the file, which needs to be added, and the file description. After that the FileSpecification object can be added to EmbeddedFiles collection of Document object using add(..) method of EmbeddedFiles collection. The EmbeddedFiles collection contains all the attachments added in the PDF file.
The following code snippet shows you how to add attachment in a PDF document.

//open document
com.aspose.pdf.Document pdfDocument = new com.aspose.pdf.Document("/mnt/sdcard/input.pdf");
//setup new file to be added as attachment
com.aspose.pdf.FileSpecification fileSpecification = new com.aspose.pdf.FileSpecification("/mnt/sdcard/sample.txt", "Sample text file");
//add attachment to document's attachment collection
pdfDocument.getEmbeddedFiles().add(fileSpecification);
// Save updated document containing table object
pdfDocument.save("/mnt/sdcard/output.pdf");

The following code snippet shows you how to delete all the attachments from the PDF document.

//open document
com.aspose.pdf.Document pdfDocument = new com.aspose.pdf.Document("/mnt/sdcard/input.pdf");
//delete all attachments
pdfDocument.getEmbeddedFiles().delete();
//save updated file
pdfDocument.save("/mnt/sdcard/output.pdf");

The following code snippet shows you how to get an individual attachment from the PDF document.

//open document
com.aspose.pdf.Document pdfDocument = new com.aspose.pdf.Document("/mnt/sdcard/input.pdf");

//get particular embedded file
com.aspose.pdf.FileSpecification fileSpecification = pdfDocument.getEmbeddedFiles().get_Item(1);
//get the file properties
System.out.printf("Name: - " + fileSpecification.getName());
System.out.printf("\nDescription: - " + fileSpecification.getDescription());
System.out.printf("\nMime Type: - " + fileSpecification.getMIMEType());
// get attachment form PDF file
try {
    InputStream input = fileSpecification.getContents();
    File file = new File(fileSpecification.getName());
    // create path for file from pdf
    file.getParentFile().mkdirs();
    // create and extract file from pdf
    java.io.FileOutputStream output = new java.io.FileOutputStream("/mnt/sdcard/"+fileSpecification.getName(), true);
    byte[] buffer = new byte[4096];
    int n = 0;
    while (-1 != (n = input.read(buffer)))
    output.write(buffer, 0, n);

    // close InputStream object
    input.close();
    output.close();
} catch (IOException e) {
e.printStackTrace();
}
// close Document object
pdfDocument.dispose();

Overview: Aspose.Pdf for Android
Aspose.Pdf for Android is a PDF document creation & manipulation component that enables Android applications to read, write & manipulate PDF document without using any other third party application. It allows PDF compression options, table creation & manipulation, support for graph objects, extended security controls, custom font handling, add or remove bookmarks, create table of contents, add, update, delete attachments & annotations, import or export PDF form data, print PDF docs &  much more.

Read more about Aspose.Pdf for Android

Control PDF Appearance & Enhanced DrawingML Charts Rendering in .NET, Java, Android

The long awaited version of Aspose.Words for Java &.NET 13.9.0 as well as Aspose.Words for Android 1.2. Aspose.Words for Android 1.2 marks the third release for the newest member of the Aspose.Words product family and we are pleased to announce all three product releases contain more than 100 useful improvements. This version of Aspose.Words adds a new option to the PdfSaveOptions class PageMode that controls how the PDF should appear and what internal windows in the PDF document should be initially displayed when opened in the PDF reader. When you create a new Microsoft Word document via the Explorer context menu (right click and choose New Microsoft Word Document) a blank file with no content is created as a placeholder for the document. The file that is created isn’t a valid Microsoft Word file yet as this only happens when the file is opened in Microsoft Word or a similar editor and the appropriate data is written. In previous of Aspose.Words trying to open such empty documents using the Document constructor would cause an exception as the file being opened was not valid. This caused some confusion and user experience issues for customers therefore we have remedied this and in the latest version of Aspose.Words will detect and handle these types of files so you can now open such documents directly via the constructor. The list of new and improved features in this release are listed below

• Further features and improvements in DrawingML Charts rendering
• Textboxes rendering improvements
• "Zero-weight" files are now supported
• Various improvements in handling of MS Word formats
• Unproperly resolved RTL text with incorrect properties inside SDT.
• WMF XOR (SRCINVERT) operation now properly rendered to PDF
• Wmf image is filled by black background is now fixed
• Publically set TableName in com.aspose.words.DataTable
• Distance between bullets and text is too big after importing HTML.
• HTML export: Table's lines disappeared in IE9, Chrome, Opera browsers is fixed
• CompatibilityOptions.DoNotExpandShiftReturn is now working with PDF files
• Font changing is fixed after appending one document to another
• Floater vertical position is corrected relative to a paragraph inside a floating table
• /cell border diagonal/ Diagonal borders lost in a table cell  is fixed when rendering to PDF
• Aspose.Words.Document opening empty document is fixed
• Docx to HTML conversion issue is resolved with table border
• Multiple bookmarks are generated in PDF for one bookmark in header of document
• Page Left Margin increment fixed after conversion from HTML to Pdf
• Provide method to add Built-in style in the Document.Styles collection
• Page background corruption is fixed while rendering
• 'Times New Roman' 8pt text blurring issue is resolved when exported to image on Windows 8
• Doc to Pdf conversion issue is resolvedwith Text Indents
• Aspose.Words.jdk16-13.6.0 causing apache-tomcat memory leak warning logs is now fixed.
• Lost image effects are now fixed
• Improved text inside inline OLE
• JPEGImageReader memory leak is fixed during PDF conversion on JDK1.6.0_45
• Import characters in range 0x80 - 0x9F from HTML documents encoded in 'ISO-8859-1
• CultureInfo for uk-UA under win8
• Parsing iTXt_chunk during reading Png is enhanced
• Load external CSS by URI with the 'file:' scheme with arbitrary number of slushes
• Unsupported FileFormat Exception during test save-load is resolved
• Generation of very big doc on Java 6 is slower than on Java 5 is now enhanced
• Corrupt JPEG data: premature end of data segment error occurs during saving to HTML_FIXED is fixed
• Content trimming inside the text box is resolved
• Extended Unicode (Surrogate pair) characters are now rendered correctly.
• Docx to HTML conversion issue resolved with GroupShapes
• /clipping/ Doc to PDF conversion issue resolved for Shape Cut off
• The amount of spacing after the paragraph is corrected
• During exporting RTF to HTML the output sizes becomes too big is now fixed
• Frame destroying issue is fixed after conversion to PDF
• 'margin' CSS style in Html is imported correctly for Paragraphs
• Table content is truncated from the bottom in PDF is now fixed
• TextBox Shapes with Through wrapping is fixed & now visible in PDF
• Aspose.Words now loading images from MHTML
• Images converted to “red cross” after open/save MHT document is fixed
• Some content is moved to the next line in fixed page formats is now fixed
• Empty paragraphs become highlighted after conversion to HTML is fixed
• Barcode image is getting cropped from top when rendering to PDF is fixed
• Group Shape is broken after conversion from Docx to Pdf is now fixed
• Text in TextBox shape is now properly rendering to PDF
• Incorrect position of text fields is fixed when rendering to PDF
• Text position change is fixed after conversion from Docx to Pdf
• Empty spaces are addition is fixed after conversion from Docx to Doc
• Chrome now properly display newly entered characters in Text FormField in Pdf
• A square box is inserted in between list's bullet and text in Pdf
• Doc to Pdf conversion issue is resolved with mathematical formulas rendering
• Document.Save corrupts the Microsoft Word 2013 document is fixed
• Contents position is corrected after joining documents with Document.AppendDocument
• Japanese contents lost is fixe dafter conversion from Doc to Pdf
• Shape is rendering is corrected
• Style inheritance now works when copying style to another document
• Text of second line moves to first line after conversion from Docx to Pdf  is fixed
• Docx to Html conversion issue is resolved with formula (Image) rendering
• Positions of frames are now preserved during rendering to PDF
• Page margins issue is resolved when saved as PDF
• Doc to Pdf conversion issue is resolved with PdfSaveOptions.PreserveFormFields
• Character Rendering is corrected for conversion from mhtml to fixed file format
• Doc to Pdf conversion issue is resolved while rendering line
• Date field format is now preserved during open/save an ODT
• Saving MS Word document to Pdf loses space character for font Code 128 is fixed
• Webdings symbols are rendering as square boxes in Pdf is now fixed
• Shape rendering at incorrect place in PDF is fixed
• SpaceAfter value preservation is fixed during importing <p> from HTML
• Font issue is fixed while inserting SVG into document
• A customized Combo DrawingML chart rendering to PDF/JPEG is corrected

Other most recent bug fixes are also included in this release

More about Aspose.Words for .NET

• Homepage Aspose.Words for .NET
• Homepage Java Word Library
• Homepage of Aspose.Words for Android

Set PDF Privileges, Add Extract & Replace Images to PDF inside Android

Aspose development team is excited to announce the release of Aspose.Pdf for Android 1.1.0. This new version provides great support for working with images: image extraction, adding images to existing PDFs, replacing images in PDFs, and adding an image as a stamp object. It also allows you to set PDF privileges. We are working hard to make this product as robust as its siblings on .NET and Java. This release includes plenty of new and improved features as listed below

• Exception resolved while Adding image to an existing PDF document
• Enhanced extraction of image from an existing PDF
• Improved replacing image in an existing PDF document
• Improved adding image stamp
• Facades: Extracting image throwing exception is resolved
• Facades: PdfFileSecurity missing enhanced

Read Write & Manipulate Excel XLS, XLSX, CSV & XLSM in Android Apps

Aspose is proud to expand its Android components family with the addition of a new product known as Aspose.Cells for Android.  Aspose.Cells for Android is a Microsoft Excel spreadsheet component that allows you to develop android applications for reading, writing and manipulate Microsoft Excel spreadsheets (XLS, XLSX, XLSM, SpreadsheetML, CSV, tab delimited) and HTML file formats without needing to rely on Microsoft Excel. Aspose.Cells for Android is a scalable and feature rich component that offers many functions that are way beyond the simple data exporting capabilities of other vendors. With Aspose.Cells for Android, developers can export data, format spreadsheets to the most granular level, import images, import charts, create charts, apply and calculate complex formulas, stream Excel data, save in various formats and much more – all this without the need of Microsoft Excel. Aspose.Cells for Android not only supports spreadsheet generation and other basic file formatting features, it also supports a number of advanced features. These advanced features make it much easier for developers to manipulate spreadsheet contents, cell formatting and file protection. Read more

Aspose Launches Word Processing Component for Android Apps Development

Aspose development team is proud to announce the availability of Aspose.Words for Android 1.0.0. Now developers can have all the powers of Aspose.Words when developing applications for the Android operating system. Aspose.Words for Android is a document creation, conversion and manipulation component for Android developers, which supports performing a wide range of document processing tasks with any Microsoft Word formats. Aspose.Words for Android is a new product but at its core is already backed by more than half a million lines of code from its parent component, Aspose.Words for Java, from which it is automatically ported from. Aspose.Words components are proven in their field for high fidelity conversions, rich API and ease of use when working with Word formats to perform tasks such as loading, converting and manipulating Word documents. Aspose.Words for Android and has been introduced to meet the growing need of quality document conversion and management tools for mobile development.Read complete details

Aspose Launches Email Programming Component for Android Developers

Aspose is proud to expand its components family with the addition of a new product known as Aspose.Email for Android. A powerful android API that empowers software developers to design Android applications for managing and manipulating email messages without using Microsoft Outlook. This is good news for Android developers and users who would like to include the functionality of creating, reading and manipulating Outlook messages in their mobile apps. It provides tools to create, read & convert Outlook MSG, PST, EML, EMLX, OST & MHT file formats. Aspose.Email for Android is a message creation, reading and manipulating component for Android developers and users. You can not only read message files, but also modify the contents of a message and save it back. With Aspose.Email, you can retrieve email information such as sender, receiver, subject, and body from message files.  Embedded objects, such as in-line images, can be added as well as extracted as linked resources from a message body and saved to disc. The API also lets you manipulate message attachments with just a few lines of code. You can not only extract regular attachments from a message, but also process nested messages that are part of a message. The same is true for adding any type of attachments to messages that you are creating. Using Aspose.Email, you get complete control over customizing email message headers. You can add headers to a message, read all headers, and extract headers from a message file. Similarly, for outlook MSG files, it gives you complete access to the message’s MAPI properties.Read more