Create Transparent Images of Worksheets & Search Cells Based on Style in Android

What’s new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android v4.0.0. In this release, you can find cells with particular style or formatting. Aspose.Cells supports finding all cells that have a common style or formatting. Aspose.Cells provides the FindOptions.setStyle() method which you can use to specify the style to search cells for. You can now create transparent images of Microsoft Excel worksheet. Sometimes, you need to generate an image of your worksheet as a transparent image. For example, you might want to apply transparency to all cells that have no fill color. Aspose.Cells provides the ImageOrPrintOptions.setTransparent() method which applies transparency to a worksheet image. This new release also supports reading large Excel files with the LightCells API. This is a useful feature when you need to read data from a huge Microsoft Excel workbook with millions of records and you are worried about the performance. We have also added a number of enhancements in the new release. In this version, we have refactored the PivotTables module. We’ve made great enhancements and fixed several issues. We have improved the chart to image and sheet to image modules. 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 exporting Excel workbooks to PDF format have been resolved. This release includes plenty of new & enhanced features as listed below

• Supports reading large files with LightCells
• Refactor reading and writing pivot table of xlsb
• Reading large template files with LightCells
• Reading large template files with LightCells
• ActiveX Support (Read ActiveX controls such as, buttons)
• ActiveX Support (Read ActiveX controls such as, buttons)
• Distinguish between ActiveX Picture or Normal Picture
• Setting default column width is enhanced
• Using Aspose in an OSGi Environment
• How to set quality in saved Charts
• Negative value becomes positive after calculate is now fixed
• Header content is getting distorted in the output PDF file is fixed
• XLSX to PDF: Result now have Left & Right Margins
• Issue with PivotTable is resolved (Change the Filter to other value or label)
• Cell.getDisplayStyle() now return correct color for Top 10 conditional formatting
• Alignment of text in shape gets changed from center to left is now fixed
• Bookmark was created for the blank sheet even though the sheet itself was not present in the output PDF
• Charter header missing after xlsx saved to PDF file is now fixed
• Data loss is corrected when excel file is converted to pdf
• Pivot table is now getting refreshed properly
• Value changes after calculation in xlsb file is now fixed
• Data Loss and Incorrect label alignment is fixed when excel is converted to PDF
• Image in heading rows only appearing on first page in PDF
• Incorrect formula processing is corrected
• The shape is now transparent in the output pdf

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

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.

• Homepage of Aspose.Cells for Android
• DownloadAspose.Cells for Android

Aspose Launches New Android API for MS PowerPoint Documents Processing

What's New in this Release?

Aspose team is proud to announce the release of a New Android API for Microsoft PowerPoint Documents Processing known as Aspose.Slides for Android.  This new component has been built on top of our award winning product Aspose.Slides for Java, and inherits all the features and capabilities from that product except rendering options at the moment. The component empowers Android developers to work with PowerPoint presentations in their applications without any dependence on Microsoft PowerPoint. For more information about the product capabilities, please visit product description page. Aspose.Slides for Android empowers the developers to create simple or complex presentations. It allows you to add variety of shapes and formatting them. The complete support for working with MSO charts has also been added in this release. It also provides the support for managing OLE frames, manipulating SmartArt shapes, using PowerPoint tables and ActiveX objects. The feature support for slide transition effects and incorporating the animations inside slides has also been made available in this new release. Please visit this documentation link for list of available features in this new component. At present Aspose.Slides for Android does not offer rendering support and you cannot convert PowerPoint presentations to PDF, XPS, TIFF, PDF notes, SVG and slide thumbnails in formats like BMP, PNG and JPEG. However, we are working on these features and subsequent releases of Aspose.Slides for Android shall inherit rendering support from Aspose.Slides for Java. In order to get started with the product, we have also added a complete programmer guide section that will enable you to verify and use different product features. Some important enhancement & bug fixes included in this release are given below

• Creating new PPT and PPTX presentations;
• Managing existing PPT and PPTX presentations;
• Adding, removing and updating slides, text, and shapes;
• Saving PPT in PPT and PPTX formats, saving PPTX.
• Exporting to PDF and other formats is not yet supported;
• Creating slide thumbnails is not yet supported.

Newly added documentation pages and articles

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

• Product Overview of Aspose.Slides for Android
• Opening & Editing Existing Presentation

Overview: Aspose.Slides for Android

Aspose.Slides for Android is a PowerPoint component that lets Android developers create, read, write and modify a PowerPoint document without using MS PowerPoint. It helps managing presentations, slides, shapes, tables & supports PPT, PPTX, POS, PPS, POTX, PPSX formats within Android applications. Now you can add, access, copy, clone, edit & delete slides in your presentations. It also supports audio & video frames, adding pictures, text frames and saving presentations as streams or SVG format.

Read more about of Aspose.Slides for Android

PDF to Image Conversion, Set Table Border Style & Margins in Android Apps

What's New in this Release?

Aspose development team is excited to announce the release of Aspose.Pdf for Android 1.2.0. This new release provides some great features including PDF to image conversion with the help of the com.aspose.pdf.facades.PdfConverter class. Previously, this feature was only supported in Aspose.Pdf for .NET and Aspose.Pdf for Java. Aspose.Pdf for Android is built on top of Aspose.Pdf for Java and we have worked hard to support this feature in Aspose.Pdf for Android so that our Android customers can also use this handy feature for PDF manipulation. In this new release, we have introduced some great classes including:

• BaseParagraph
• BorderCornerStyle
• BorderCornerType
• BorderInfo
• BorderSide
• FloatingBox
• HeaderFooter
• Heading
• Hyperlink
• Image
• LevelFormat
• MarginInfo
• NewParargraphPlacementInfo
• PageGenerator
• PageInfo
• Paragraphs
• TableImporter
• TOCInfo
• WebHyperlink

Based on newly added classes, you can set a table’s border style, margins and padding, convert PDF documents to images, work with FloatingBox objects, convert image files to PDF format and much more. This release includes plenty of new and improved features as listed below

• Add PdfConverter facade (beta)
• Add Generator functionality
• TEXT to PDF conversion issue is resolved - using textbuilder 
• Exception resolved while Adding image to an existing PDF document

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

Convert Large & Small Text Files to PDF inside Android Applications

This technical tip shows how developers can convert text files to a PDF file inside their Android application. We often get queries from customers who would like to convert their text files to PDF. We are often asked if we can quickly provide some code which can accomplish this task and save them the effort of going through the documentation. So for the benefit of everyone, we present here a simple example which can be used as it is to easily and efficiently convert a text file to PDF using Aspose.Pdf. Sometimes you may need to convert large text files into PDF format. Using the above specified techniques are not appropriate to fulfill the requirement as it can generate OutOfMemoryException or can make the system slow down, because in that technique we are reading the complete file using ReadTOEnd method. Instead of ReadToEnd method we should be using ReadLine method. As its name suggests, reads text one line at a time. In order to do this, though, you need to use a loop. You can then loop round each line and create a text object for each text line and add it to paragraphs collection of section.
The following code snippet shows you how convert text files to PDF.

try{

   StringBuffer sb = new StringBuffer(1024);
   BufferedReader reader = new BufferedReader(new FileReader("/mnt/sdcard/test.txt"));
                                   
   int ch = -1;

   while( (ch = reader.read()) > -1){
      sb.append((char)ch);     
   }

   reader.close();

        //Instantiate Pdf pbject by calling its empty constructor
        Pdf pdf1 = new Pdf();

        //Create a new section in the Pdf object
        Section sec1 = pdf1.getSections().add();

        //Create a new text paragraph and pass the text to its constructor as argument
        Text text1 = new Text(sec1,sb.toString());

        sec1.getParagraphs().add(text1);
                                   
        pdf1.save("/mnt/sdcard/Text_File_to_PDF.pdf");       

}catch(java.io.IOException ioe){
   System.out.println(ioe.getMessage());

The following code snippet shows you how convert large text files into PDF format.

  try{
//Instantiate Pdf pbject by calling its empty constructor
Pdf pdf1 = new Pdf();       
//Create a new section in the Pdf object
Section sec1 = pdf1.getSections().add();

// Open the file that is the first
// command line parameter
FileInputStream fstream = new FileInputStream("/mnt/sdcard/LargeText.txt");
        // Get the object of DataInputStream
        DataInputStream in = new DataInputStream(fstream);
        BufferedReader br = new BufferedReader(new InputStreamReader(in));
        String strLine;
        //Read File Line By Line
while ((strLine = br.readLine()) != null)  
{
        //Create a new text paragraph and pass the text to its constructor as argument
        Text text1 = new Text(sec1,strLine);
        sec1.getParagraphs().add(text1);
}

        //Close the input stream
        in.close();

        // Save the PDF file
        pdf1.save("/mnt/sdcard/LargeText.pdf");

    }catch(java.io.IOException ioe){
       System.out.println(ioe.getMessage());
      }catch(Exception e){
       System.out.println(e.getMessage());
      }

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.
More about Aspose.Pdf for Android

• Homepage of Aspose.Pdf for Android
• Download Aspose.Pdf for Android