January 2nd, 2009, 10:53 AM
Aspose.Newsletter: Delete blank Rows and Columns in a Worksheet
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.
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 188.8.131.52 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 184.108.40.206 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 220.127.116.11 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 18.104.22.168 release, please consult the official release page and the relevant blog post. This released was followed by the Aspose.BarCode for Java version 22.214.171.124. 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 126.96.36.199 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 188.8.131.52 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 184.108.40.206 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 220.127.116.11 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 18.104.22.168 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 22.214.171.124 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 126.96.36.199 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.
Suite 119, 272 Victoria Avenue
Chatswood, NSW, 2067
Aspose - The .NET and Java component publisher
Tags for this Thread
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.