Author Archives: Amjad Sahi

We have created an article for the users. This article is designed to provide the developers with a detailed understanding on how to create Pivot Tables and Pivot Charts using Aspose.Cells component.

See the article here http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/create-pivot-tables-and-pivot-charts.html

 … Continue Reading

We have added some useful tips for the users to perform different tasks.

See the following documentation links:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/worksheet-to-image-remove-white-space-around-data.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/setting-shared-formula.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/hiding-the-display-of-zero-values-in-the-worksheet.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/setting-formulas-notice-for-nonenglish-users.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/implement-1904-date-system.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/setting-strong-encryption-type.html

 … Continue Reading

We have created a video tutorial for the users. The video exhibits how to convert an excel file to PDF format using Aspose.Cells APIs. In this video, we create a simple Windows application to demonstrate the task. We load / open an excel file, and then convert it to PDF format. The generated PDF file can be opened into Adobe Reader.

See the video here: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/convert-excel-file-to-pdf.html

 … Continue Reading

We have created a video tutorial for the users. You can add all three types of hyperlinks to your spreadsheets using Aspose.Cells:

1. URL (world wide web) link
2. Internal link
3. External or file link

In this video, we create a simple Windows application to exercise how the three types of hyperlinks (mentioned above) can be added.

See the video here: https://docs.aspose.com/display/totalproductfamily/Home
… Continue Reading

We have created a video tutorial for the users. The demo shows how to Merge and Unmerge cells in the worksheet using Aspose.Cells API. In this video, we create a simple Windows application to demonstrate the Merge and Unmerge operations.

See the video here: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/merge-unmerge-cells.html  … Continue Reading

We have just released Aspose.Cells for Reporting Services v1.4.1 hot fix for the users.

In this version, we have enhanced support for SSRS2008; we have also optimized rendering performance. Now, MS Excel template files with macros are supported by the component, we have added support for new rendering extension (Xlsm). There are some other enhancements and fixes too.

Download URL:

http://www.aspose.com/community/files/52/ssrs-rendering-extensions/aspose.cells-for-reporting-services/entry174679.aspx   … Continue Reading

We have just released Aspose.Cells for .NET v4.7.1 hot fix for the users.

We enhance excel to pdf conversion in this version; it is now possible to directly export excel files to pdf stream. We also add MS Excel’s Subtotals feature to subtotal ranges of data in the worksheet. Moreover, we have improved performance of encrypting / decrypting Excel 2007 files; there are some other enhancements and fixes too.

Download URL:

http://www.aspose.com/community/files/51/file-format-components/aspose.cells-for-.net-and-java/entry174461.aspx  … Continue Reading

We have just released Aspose.Grid V2.0.1 for the users.

We introduce some key features regarding Aspose.Grid.Desktop control in this version.  The control now supports MS Excel2007Xlsx file format, so, you may import/export the file format for your need. You can utilize the Auto-RowFilter and Custom RowFilter features, Customize and format comments, Read and write Custom properties for a worksheet etc. Moreover, the control supports customizing context menu, multiple selection of rows/columns in the worksheet, undo/redo operations, importing/exporting frozen panes and … Continue Reading

You can add all three types of hyperlinks to your spreadsheets using Aspose.Cells API:

1. URL (world wide web) link
2. Internal link
3. External or file link

We create a demo video for the users. In this video, we create a simple Windows application to exercise how the three types of hyperlinks (mentioned above) can be added.

See the video here: https://docs.aspose.com/display/cellsnet

 … Continue Reading