Category Archive: Aspose.Cells Product Family

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

Aspose.Cells provides the feature to add different type of controls to a worksheet. Please see the following online demos regarding adding different type of controls to a worksheet.

1: Textbox

2: Combobox

3: Checkbox

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

Following Technical Article is designed to provide the developers with a detailed understanding on how to extract the Ole Objects from workbook. 

Please see the article at the following link:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/extract-ole-objects-from-workbook.html… Continue Reading

Following Technical Article is designed to provide the developers with a detailed understanding on how to add the conditional formatting to a range of cells in a worksheet. 

Please see the article at the following link:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/apply-conditional-formatting-in-worksheets.html

 … Continue Reading

Aspose.Cells provides the feature to create named ranges using simple Aspose.Cells APIs.

We created a demo video for the users to show the implementation of this feature. In this video, we will create a simple WinForm application to demonstrate the task. We will add two named ranges i.e. one workbook scoped named range and second worksheet scoped named range using Aspose.Cells APIs. 

See the video here:

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/named-ranges-1.html

… Continue Reading

Aspose.Cells provides the feature to create a chart using simple Aspose.Cells APIs.

We created a demo video for the users to show the implementation of this feature. In this video, we will create a simple WinForm application to demonstrate the task. We will create a pyramid chart using Aspose.Cells APIs. 

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