File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Blatant Advertising and the fly likes Aspose.Newsletter: Delete blank Rows and Columns in a Worksheet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Other » Blatant Advertising
Bookmark "Aspose.Newsletter: Delete blank Rows and Columns in a Worksheet" Watch "Aspose.Newsletter: Delete blank Rows and Columns in a Worksheet" New topic
Author

Aspose.Newsletter: Delete blank Rows and Columns in a Worksheet

Usman Sarfraz
Ranch Hand

Joined: Jan 02, 2008
Posts: 59
Aspose publishes January 2009 Newsletter for .NET & Java programmers by highlighting the newly supported features by Aspose.Slides for Reporting Services, Aspose.Total, Aspose.Words, Aspose.Pdf.Kit, Aspose.BarCode, Aspose.Workflow, Aspose.Cells, Aspose.Words for Reporting Services, Aspose.Form and Aspose.Network. We will also provide information about migrating your code for Microsoft Office Automation to Aspose using Aspose.Cells. You will learn about the latest news from Aspose along with the monthly Tech-Tip, which demonstrates how to delete blank Rows and Columns in a Worksheet using Aspose.Cells and an introduction to our featured technical article which shows you how to access Gmail on SSL with Aspose.Network. In addition to this, we will introduce the latest tutorial video from Aspose, which shows you how to password protect or encrypt Excel Spreadsheets using Aspose.Cells.

Product Spotlight

Aspose.Slides for Reporting Services is the only solution to generate reports in Microsoft PowerPoint PPT and PPS formats in Microsoft SQL Server 2005 Reporting Services. Almost all RDL report features, like tables, matrices, charts and images are supported and can be converted with high quality to presentations or slide show. Take the time to download the free evaluation version today to see how Aspose.Slides for Reporting Services can work for you.

Aspose announces Q4 2008 releases of Aspose.Total

Aspose is proud to announce the Q4 2008 releases of its suite products, Aspose.Total for .NET, Aspose.Total for Java and Aspose.Total for Reporting Services. The Q4 releases of Aspose.Total include several new features and updates for all product lines to help developers in building more reliable and robust solutions with less effort. For more information please consult the official press release. The latest version of Aspose.Total for .NET and Java can be downloaded from here and that of Aspose.Total for Reporting Services can be downloaded from here.

Directly convert Word documents to PDF and Images with the new Aspose.Words Rendering Engine

The latest version 6.0.0.0 of Aspose.Words for .NET features a new Rendering Engine that finally makes it possible to print, render to images and convert documents to PDF directly. The Aspose.Words Rendering Engine has been designed to format a document into pages with high fidelity to how Microsoft Word would have done it. When pagination is complete, Aspose.Words can render the output into a variety of the �fixed-page� formats. This architecture allows you to convert a document to PDF, print, image or render to a browser. Aspose.Words also supports the full set of DrawingML used by Microsoft Word 2007. It is now possible to use Aspose.Words to load and save OOXML documents with VML as well as with DrawingML. In addition to this, you can now load MHTML files with Aspose.Words and save documents in the EPUB format. This release also includes numerous other improvements and bug fixes. For more information you can view the official release page and the relevant blog post. The latest version of Aspose.Words for .NET can be downloaded from here.

Enhanced editing capabilities in Aspose.Pdf.Kit for Java

Aspose.Pdf.Kit for Java version 2.2.0.0 has been released. In this release, the capability of editing various PDF contents is enhanced. A new class named PdfBookMarkEditor is introduced to allow manipulation of PDF bookmarks. A new methods has also been added to support editing of annotations. It is also now possible to replace and delete images from PDF documents. New methods have been added to PdfFileSignature to support reading/disposing more information of digital certificate. In addition to this, the new release also includes numerous other improvements and bug fixes. For detailed information you are requested to view the official release page and accompanying blog post. The latest version of Aspose.Pdf.Kit for Java can be downloaded from here.

Aspose.BarCode for J2ME Released

Aspose.BarCode for Java version 1.7.0.0 has been released. This new release of Aspose.BarCode introduces a new library - Aspose.BarCode for J2ME (Java 2 Micro Edition). Aspose.BarCode for J2ME is able to recognize barcode images for J2ME applications. The library works fine with most of the popular J2ME SDKs like WTK, Nokia SDK for Java, BlackBerry SDK for Java etc. This release of Aspose.BarCode for J2ME supports most popular Linear(1D) barcodes and QR barcode. For more information about the 1.7.0.0 release, please consult the official release page and the relevant blog post. This released was followed by the Aspose.BarCode for Java version 1.8.0.0. In this version, we added the support for recognition of 6 new barcodes for J2ME component, which include UPCE, UPCA, Planet, Postnet, AustraliaPost 4 states barcode and USPS Intelligent Mail Barcode (OneCode). For more information about the 1.8.0.0 release, please consult the official release page and the relevant blog post. The latest version of Aspose.BarCode for Java can be downloaded from here.

Improved ODP.NET support with Aspose.Workflow for .NET

Aspose.Workflow for .NET version 1.7.0.0 has been released. Aspose.Workflow now supports ODP.NET for .NET framework 3.5 as the data provider and provides new persistence service for better performance and extendibility. Also include with this release are numerous improvements and bug fixes. For more information, you are requested to view the official release page and the accompanying blog post. The latest version of Aspose.Workflow for .NET can be downloaded from here.

International Standard of Application Identifiers (AI) for EAN128 barcode generation supported by Aspose.BarCode for .NET

The latest version 3.0.0.0 of Aspose.BarCode for .NET offers complete support for International Standard of Application Identifiers (AI) for EAN128 barcode generation. This release also features improved compatibility and performance improvements for x64 platform, as well as improved barcode recognition accuracy for image position. There are numerous other bug fixes and improvements incorporated into this release. For more details, please consult the official release page and the relevant blog post. The latest version of Aspose.BarCode for .NET can be downloaded from here.

Enhanced PivotTable support with Aspose.Cells for .NET

Aspose.Cells for .NET version 4.6.0.0 has been released. In this release the export of PivotTable to Excel 2007 files is supported. This release also provides support for adding pivot calculated items to PivotTable in Excel 97-2003 XLS files. Page setup Header(s) and Footer(s) in Worksheet2Image and reading/writing of XLTM, XLMX files are also supported. There are numerous other bug fixes and improvements in this release. For more details please consult the official release page and the accompanying blog post. The latest version of Aspose.Cells for .NET can be downloaded from here.

Full support for Microsoft SQL Server 2008 Reporting Services with Aspose.Words for Reporting Services

The latest version 3.0.0.0 of Aspose.Words for Reporting Services has been released. This release introduces a number of great features, namely: full support for Microsoft SQL Server 2008 Reporting Services (final version), improved document layout, optimized items positioning, new export format (ODT), and more. Also included in this release are numerous bug fixes and enhancements. For more information please consult the official release page and the relevant blog post. The latest version of Aspose.Words for Reporting Services can be downloaded from here.

Downlevel Mode rendering with Aspose.Form for .NET

Aspose.Form for .NET version 1.7.0.0 has been released. This release of Aspose.Form improves User Interfaces, and includes bug fixes and other new features. In this release Downlevel Mode rendering for XmlFormView controls has been supported. Many other improvements and bug fixes have also been incorporated into this release. For more details please consult the official release page and the accompanying blog post. The latest version of Aspose.Form for .NET can be downloaded from here.

Manage Appointments with Aspose.Network for .NET

The latest version 4.4.0.0 of Aspose.Network for .NET now offers support for sending appointments in email messages. Now you can send an appointment request in email, update the appointment or cancel the appointment. Listing mail messages on Exchange Server by Message ID and DataColumnMapping for Mail Merge are also supported in this release. You will also find many other enhancements and bug fixes incorporated into this release. For more information please consult the official release page and the relevant blog post. The latest version of Aspose.Network for .NET can be downloaded from here.

Migration from Microsoft Office Automation to Aspose � Aspose.Cells

In this months newsletter we include information for migrating to Aspose.Cells your Microsoft Office Automation code to Merge / Unmerge Cells in a Worksheet. You can find the detailed article with complete code here.

Technical Article � How to access Gmail on SSL

In this article, we will show you how to access Gmail via SSL using Aspose.Network. We can access Gmail using SMTP, IMAP and POP3 protocols.

Tutorial Video � How to password protect or encrypt Excel Spreadsheets

This video tutorial demonstrates how to create a password protected / encrypted Excel file using Aspose.Cells. In this video, we create a simple WinForm application to demonstrate the feature. When you try to open the Excel file generated by this application, you will be asked to provide the valid password otherwise the file would not open.

Technical Tip � Delete blank Rows and Columns in a Worksheet

Sometimes, you may need to delete all of the blank Rows and Columns from your Worksheet. For example, you would need to do this when you are converting your Excel file to PDF and you only need the Rows and Columns which contain data only to be converted to PDF format. This technical tip explains how to do just that using Aspose.Cells.

Collect original copy of Aspose Newsletter, January - 2009.

- Aspose Newsletter, January - 2009.

Contact Information
Suite 119, 272 Victoria Avenue
Chatswood, NSW, 2067
Australia
Aspose - The .NET and Java component publisher
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465l
 
Don't get me started about those stupid light bulbs.
 
subject: Aspose.Newsletter: Delete blank Rows and Columns in a Worksheet