• Hello World shows how to add data to cells in a worksheet and retrieve data from the cells of a worksheet.

D e t a i l s

The demo is a perfect example of any beginner who wants to learn the APIs of Aspose.Cells and create his/her first Hello World conventional example and quickly put into action to make the start. The demo utilizes a template file and then enlightens how to insert data into different cells of a worksheet of different format and data types including String, Numeric, Boolean and DateTime etc. It actually fills the two columns of the template file. You may open your resultant excel file either into MS Excel or save directly to your disk.

• Find or Search Data shows all possible ways to find or search cells containing specified data in spreadsheets.

D e t a i l s

This demo explains how to Search data in the cells in a worksheet. Aspose.Cells provides an easy way to find individual data or a list of data. It will even allow you to look for a partial data if you are not sure about how the data is completely spelled. You may find string data, numeric data and search formulas. The example creates an excel file from the scratch and inputs some values into different cells in a worksheet, apply some formulas and find data in the cells. You are allowed to either open the resultant excel file into MS Excel or save directly to your disk.

• Importing Data to Worksheets shows how to import data to worksheets from different data sources.

D e t a i l s

This Demo exhibits how to Import Data from a variety of data sources to fill the worksheets. Aspose.Cells component is a powerful component, which can be used to create a list of data from different data sources including Array, ArrayList, DataColumn, DataGrid, DataTable, DataView, Array having Formulas, DataReader, Object Array and Two Dimensional Array etc. Aspose.Cells component is fully functional to display and specify the flow of data from the most diverse data sources with excellence. You may import data easily using the simplest APIs provided by the component. The component automatically fills the worksheet with data and minimizes your code. In the example, you are provided a drop down list and a command button to exercise the importing tasks. The drop down list includes the names of all the data sources. You may select a data source from it and click the button to generate a workbook having the related list of data based on data source. You can either open the resultant excel files into MS Excel or save directly to your disk to check the results.

• Exporting Data from Worksheets shows how to export data from worksheets.

D e t a i l s

This demo explains how to retrieve data from a worksheet and Export to fill a DataTable object. This is achieved through a single API of Aspose.Cells. All this is done with so much ease and it can minimize your coding lines which may extend when you manually perform this operation and fill a DataTable's rows and columns with data from a worksheet's cells of the excel file. The demo gets data from a worksheet of an excel file and exports it to fill a DataTable. The example also binds the data table object to a DataGrid control.

• Data Filter shows how to perform data autofilter using Aspose.Cells.

D e t a i l s

This demo exhibits how to auto-filter data into the different cells of a worksheet. Many a times, you want to work with subset data or a group of specific records. For example you might want to print all the sales records for one salesperson or you might want to track all the orders of one client. A filter is used to select records that meet a specific criterion and temporarily hides all other records. Aspose.Cells is equipped with auto-filter feature which you can use based on your requirements. The example creates an excel file, fills the cells of the worksheet (two columns) with some data and then applies auto-filter to filter data. You may either open your resultant file into MS Excel or save directly to your disk.

• Data Validation shows how to perform data validation using Aspose.Cells.

D e t a i l s

This demo explains how to implement Data Validation on different cells in a worksheet. Data Validation allows you to build business rules into each cell so that grossly incorrect entries result in error messages. Business rules are the policies and procedures that governs how business operates. Aspose.Cells supports Data Validation based on your business rules and polices. The demo creates an excel spreadsheet file and applies Data Validation on B1 cell in the first worksheet which forces only number b/w 0 and 10 can be entered into the cell. An error message is shown in case of wrong entry. An input message is always displayed on the cell too. You may either open your resultant excel file into MS Excel or save directly to your disk.

• Using Formulas/Functions to Process Data shows how to use formulae in worksheets to process data.

D e t a i l s

This demo exhibits an exercise of different types of worksheet formulas / functions to process data in your spreadsheet. Aspose.Cells component supports all the commonly used functions related to different categories: Mathematical, String, Statistical, DateTime, Logical, Database and Financial etc. Mathematical functions are useful for performing algebraic operations on numeric values in your worksheet. Aspose.Cells component supports almost all the built-in Math and Trigonometry functions to perform Mathematical Calculations. You can implement variety of Mathematical functions in your worksheet, e.g., ABS, CEILING, FLOOR, POWER, ROUND, SIGN, SQRT, SUM etc. String Functions are very useful to format displayed data in a sheet. Aspose.Cells component supports some useful String Functions to manipulate textual data. For example, you can concatenate, compare, find and replace text in the sheet. You can get numeric code for a specified character in a text string. Similarly you can return character specified by the code number. Aspose.Cells component can also perform some Statistical calculations on your data. In some case, you need to use DateTime Functions while manipulating Dates in your worksheet. Aspose.Cells component supports almost all the built-in Date and Time functions to perform complex Date and Time Calculations. Aspose.Cells component can also add, subtract or compare dates just like MS Excel or any other Spreadsheet. Aspose.Cells component also supports all the Logical functions (AND, FALSE(0), IF, NOT, OR, TRUE(1)). Aspose.Cells component supports all the important Financial and Database functions too. The demo makes use of a template excel file which contains a list of all the formulas / functions string of all the categories mentioned. The file also contains some static data used in different formulas. The demo retrieves the formulas / functions string and calculates the formulas / functions to fill the column D with resultant data. You may either open your resultant excel file into MS Excel or save directly to your disk.

• Calculate Formula shows how to calculates the result of formulas.

D e t a i l s

This demo explains how to calculate the results of different types of worksheet formulas / functions in your spreadsheet. The demo compares the formula / function results of Aspose.Cells with MS Excel. Aspose.Cells component supports all the commonly used functions related to different categories: Mathematical, String, Statistical, DateTime, Logical and Lookup and Reference Functions etc. Mathematical functions are useful for performing algebraic operations on numeric values in your worksheet. Aspose.Cells component supports almost all the built-in Math and Trigonometry functions to perform Mathematical Calculations. You can implement variety of Mathematical functions in your worksheet, e.g., ABS, CEILING, FLOOR, POWER, ROUND, SIGN, SQRT, SUM etc. String Functions are very useful to format displayed data in a sheet. Aspose.Cells component supports some useful String Functions to manipulate textual data. For example, you can concatenate, compare, find and replace text in the sheet. You can get numeric code for a specified character in a text string. Similarly you can return character specified by the code number. Aspose.Cells component can also perform some Statistical calculations on your data. In some case, you need to use DateTime Functions while manipulating Dates in your worksheet. Aspose.Cells component supports almost all the built-in Date and Time functions to perform complex Date and Time Calculations. Aspose.Cells component can also add, subtract or compare dates just like MS Excel or any other Spreadsheet. Aspose.Cells component also supports all the Logical functions (AND, FALSE(0), IF, NOT, OR, TRUE(1)). The demo makes use of a template excel file which contains a list of all the formulas / functions string of all the categories mentioned. The file also contains some static data used in different formulas. The demo retrieves the formulas / functions string and calculates the formulas / functions. It also retrieves values from the formulated cells and inserts into a column. You may either open your resultant excel file into MS Excel or save directly to your disk.

• Adding Hyperlinks to Link Data shows how to add hyperlinks into worksheet cells.

D e t a i l s

This demo presents an exercise how to place hyperlinks in your worksheet. A Hyperlink, a connection between the two areas, is commonly used in the internet sites that can be viewed. When the users click a hyperlink, they navigate to different location or even an address on the World Wide Web. For example, you can insert a hyperlink in your worksheet that opens a page in a web site. Aspose.Cells component supports hyperlinks. You may add and remove hyperlinks in your worksheet based on your need using Aspose.Cells APIs. The demo creates an excel file. The file contains two hyperlinks. The first hyperlink placed on A1 cell makes you navigate to Aspose Site. The second one is an internal hyperlink placed on C1 cell, when you click on it you will navigate to A10 cell of the worksheet. You may either open your resultant excel file into MS Excel or save directly to your disk.

• Named Ranges shows how to create or access named ranges in worksheets.

D e t a i l s

This demo explains how to create and access Named Ranges of cells in your worksheet. Aspose.Cells allows you to manipulate Named Ranges. You can use the labels of columns and rows on a worksheet to refer to the cells within those columns and rows.  You can create descriptive names to represent cells, ranges of cells, formulas, or constant values. Labels can be used in formulas that refer to data on the same worksheet; if you want to represent a range on another worksheet, use a name. The demo creates a named range (B1:E5) of cells first. It then, names the range. It then, accesses it by its name and puts some value into its left and bottom most cells with some formatting. You may either open your resultant excel file into MS Excel or save directly to your disk.

• Inserting/Deleting Rows and Columns shows how to insert or delete rows/columns in a worksheet.

D e t a i l s

This Demo demonstrates the exercise to Manipulate (Insert, Remove) rows and columns in a worksheet. Aspose.Cells component allows you to manipulate rows and columns in the worksheet. You can insert blank cells, rows, and columns and fill them with data. Moreover you can remove any column or row in the worksheet. In the example you are provided two command buttons Insert and Delete for practice. When you click Insert button, It creates a spreadsheet and inputs some data into different cells (A1, A2, A3 and B1) of the first worksheet. It then inserts 10 rows at 4th row and inserts a column at the second column index (B). When you click Delete button, It creates a spreadsheet and inputs some data into different cells (A1, A2, B3, B13 and C1) of the first worksheet. It then removes 10 rows starting from 3rd row and deletes the 3rd column (C) from the worksheet. You can either open the resultant excel files into MS Excel or save directly to your disk.

• Hiding/Unhiding Rows and Columns shows how to display or hide rows and columns.

D e t a i l s

This Demo demonstrates how to Show / Hide rows and column in a worksheet. Aspose.Cells component allows you to make visible / invisible specific rows and columns in the worksheet. Sometimes you may need to hide some data into cells of rows and columns in your worksheet, you do not want to show it to the client. Aspose.Cells component is flexible enough to do the tasks for you.  In the example you are provided two command buttons Display and Hide for practice. It creates an excel file and input some data into different cells (A1, A2, A3, B1, B2, B3) of the first worksheet. When you click Hide button, It hides the 3rd row and second column of the worksheet. When you click Display button, It un-hides the 3rd row and second column with certain row height and column width and display all the data in the worksheet. You can either open the resultant excel files into MS Excel or save directly to your disk.

• Grouping/Ungrouping Rows and Columns shows how to group or ungroup rows and columns.

D e t a i l s

This Demo specifies how to Group / UnGroup rows and column in a worksheet. Aspose.Cells component allows you to group / ungroup rows and columns in the worksheet. It is important that when you group rows and columns, you should select only the detail rows or columns that make up the group in your worksheet. Do not include the related summary row or column in the selection. A show detail symbol + and a hide detail symbol - attached to the rows and columns headers specifying the groups in the worksheet. Aspose.Cells component also provides you the feasibility to specify the outline setting of the summary row / column according to your requirements. In the example you are provided two command buttons Group and UnGroup for practice. When you click Group button, It uses a template excel file and groups first 10 rows of the first worksheet. It also groups the first two columns of the worksheet. When you click UnGroup button, It uses a template excel file and un-groups the grouped rows and columns in the worksheet. You can either open the resultant excel files into MS Excel or save directly to your disk.

• Adjusting Row Height and Column Width shows how to adjust row height and column width.

D e t a i l s

This Demo describes how to set Standard Row Height / Standard Column Width of all the rows / columns in a worksheet and customize Row Height and Column Width of a specific row and column in a worksheet. Aspose.Cells component allows you to adjust any row height and column width according to your need using the simplest APIs of it. The example creates an excel file with a standard row height (20) and standard column width (20) of all the rows and columns in the first worksheet. It then, customizes the width of the first column to 12 and the second column to 40. Moreover it sets the second row height to 8. You can either open the resultant excel file into MS Excel or save directly to your disk to check rows height and columns width of the first worksheet.

• AutoFit Rows and Columns shows how to autofit rows and columns.

D e t a i l s

This Demo describes how to AutoFit Row / AutoFit Column in a worksheet. This feature is very powerful which can resize the row / column automatically to fit the text or contents contained in the cells. It is really an important one because sometimes while importing or manipulating dynamic data you do not know the size of your data to be embedded into different cells of the worksheet. Aspose.Cells component offers you certain APIs to do the tasks with ease. The example creates an excel file with some data into B1 cell. It sets its rotation angle to 45. It then, implements the auto-fit adjustments at B1 cell of the first worksheet. You can either open the resultant excel file into MS Excel or save directly to your disk to check auto-fit adjustments in the worksheet.

• Managing Worksheets shows how to add or remove worksheets.

D e t a i l s

This Demo describes how to Manipulate (Add, Remove) worksheets in a workbook. A workbook is a multipage excel document. Each page in it is called a worksheet. Aspose.Cells component is capable of manipulating worksheets. For example, you can insert, remove and rename a sheet in a workbook. The example offers you two command buttons Add and Remove to exercise the manipulation tasks. When you click on Add button, a workbook is created with a default worksheet. It changes the name of the worksheet to My Worksheet1. It then, adds two more worksheets to it named My Worksheet2 and My Worksheet3 respectively. When you click on Remove button, the demo makes use of an existing excel file which has three worksheets in it. It then, removes the second worksheet from the worksheets collection in the workbook. You can either open the resultant excel files into MS Excel or save directly to your disk.

• Hide or Unhide a Worksheet shows how to hide or unhide a worksheet.

D e t a i l s

This Demo describes how to Show / Hide worksheets in a workbook. Sometimes, you may require to make a few worksheets hidden and others visible in the workbook for your own interest. Aspose.Cells component allows you to control the visibility of the worksheets in the excel files. The example offers you two command buttons Hide and Display to exercise the tasks. When you click on Hide button, a workbook is created with a default worksheet. It makes the first worksheet invisible in the workbook. When you click on Display button, the demo creates an excel file makes the first worksheet visible in the workbook. You can either open the resultant excel files into MS Excel or save directly to your disk.

• Display or Hide Tabs shows how to display or hide tabs.

D e t a i l s

This Demo describes how to Show / Hide Worksheet Tabs in a workbook. Sometimes, you may require to hide worksheet tabs for your need. Aspose.Cells component allows you to control the visibility of the worksheet tabs in the excel files. The example offers you two command buttons Hide and Display to exercise the tasks. When you click on Hide button, a workbook is created.  It makes the worksheet tabs invisible in the workbook. When you click on Display button, the demo creates an excel file and makes the worksheet tabs visible in the workbook. By default the worksheet tabs are visible in the workbook. You can either open the resultant excel files into MS Excel or save directly to your disk.

• Display or Hide Scroll Bars show how to display or hide scroll bars.

D e t a i l s

This Demo describes how to Show / Hide Scroll Bars (Horizontal and Vertical) in a workbook. Sometimes, you do require to hide scroll bars and you want to restrict the user to navigate into the whole worksheet. Aspose.Cells component offers you to control the visibility of the scroll bars in the excel files. The example offers you two command buttons Hide and Display to exercise the tasks. When you click on Hide button, a workbook is created.  It makes the horizontal and vertical scroll bars invisible in the workbook. When you click on Display button, the demo creates an excel file and makes the horizontal and vertical scroll bars visible in the workbook. By default both the scroll bars are visible in the workbook. You can either open the resultant excel files into MS Excel or save directly to your disk.

• Display or Hide Gridlines shows how to display or hide gridlines of a worksheet.

D e t a i l s

This Demo describes how to Show / Hide Worksheet Gridlines in the workbook. Many a times, you require to hide gridlines to furnish your worksheets.  Aspose.Cells component allows you to control the visibility of the worksheet gridlines in the excel files. The example offers you two command buttons Hide and Display to exercise the tasks. When you click on Hide button, a workbook is created.  It makes the gridlines invisible of the first worksheet in the workbook. When you click on Display button, the demo creates an excel file and makes the gridlines visible of the first worksheet in the workbook. By default worksheet gridlines are visible in the workbook. You can either open the resultant excel files into MS Excel or save directly to your disk.

• Display or Hide Row/Column Headers shows how to display or hide the row/column headers of a worksheet.

D e t a i l s

This Demo describes how to Show / Hide Worksheet Row /Column Headers in the workbook. Sometimes, you require to hide row / column headers to further improve readability in the worksheets.  Aspose.Cells component allows you to control the visibility of the worksheet row / column headings in the excel files. The example offers you two command buttons Hide and Display to exercise the tasks. When you click on Hide button, a workbook is created.  It makes the row / column headers invisible of the first worksheet in the workbook. When you click on Display button, the demo creates an excel file and makes the row / column headings visible of the first worksheet in the workbook. By default worksheet row / column headers are visible in the workbook. You can either open the resultant excel files into MS Excel or save directly to your disk.

• Page Break Preview shows how to display a worksheet in normal view or page break preview.

D e t a i l s

This Demo exhibits how to display a worksheet in Normal View or Page Break Preview. All the worksheets can be viewed in two modes: Normal View and Page Break Preview.  Aspose.Cells component allows you to implement these two modes with ease. You can set any type of view according to your need. The example offers you two command buttons Hide and Display to exercise the tasks. When you click on Hide button, a workbook is created. It sets the normal view for the first worksheet in the workbook. It actually hides the page break preview mode. When you click on Display button, the demo creates an excel file and sets the page break preview mode for the first worksheet in the workbook. By default worksheet mode is normal view. You can either open the resultant excel files into MS Excel or save directly to your disk.

• Zoom Factor shows how to set the zoom(scaling) factor of the worksheet.

D e t a i l s

This Demo exhibits how to set Zoom or Scaling Factor of the worksheets in a workbook. Aspose.Cells component provides the feature to set the zoom or scaling factor of the worksheets. The feature helps you to implement smaller or larger views to show the contents of your worksheet which may demand you at some occasions. The example provides you a drop down list and a command button to implement the scaling factor. You may select a value from the drop down list which represents a percentage zoom factor value and click the button to generate the resultant report. It is noted that the percentage value you give should be b/w 10 and 400. You can either open the resultant excel file into MS Excel or save directly to your disk.

• Freeze Panes shows how to apply freeze panes feature to the worksheets.

D e t a i l s

The Demo explains how to freeze rows and columns (Freeze Panes) in a worksheet. While manipulating larger worksheets you may require freeze panes in your worksheet. Aspose.Cells component is gifted with the capabilities like freezing rows & columns at specified row / column index in the worksheet. Freezing Panes helps you to view / work different areas of a larger worksheet at the same time. Freezing rows and columns allows you to select data that remains visible when scrolling in a worksheet. For example, keeping row and column labels visible as you scroll. The frozen rows are always the top rows while the frozen columns are always the left most columns. The example creates an excel file and freezes the panes at C4 cell in the first worksheet in a workbook. You can either open the resultant excel file into MS Excel or save directly to your disk to check the freeze panes feature.

• Adding Pictures shows how to add pictures to a spreadsheet using Aspose.Cells.

D e t a i l s

This Demo describes how to add Pictures into the worksheet in a workbook. Sometimes, you may need to insert some pictures of your products or your company logo in the worksheet for more readability. Aspose.Cells component gives you the ability to insert pictures of various formats and enhance your worksheet. You can change the height and width of a picture while inserting into the worksheet. You can also put in a picture from stream. You may remove the pictures of the cells in your worksheet too. The example creates an excel file. It inserts two pictures into the first worksheet of the spreadsheet. You can either open the resultant excel file into MS Excel or save directly to your disk.

• Adding Comments shows how to add comments to cells using Aspose.Cells.

D e t a i l s

This Demo exhibits how to add Comments to the cells in a worksheet. When you are creating or editing a worksheet especially with others, It's often valuable to be able to make comments that are not printed sheet but can be viewed on the screen. Aspose.Cells 's Comments feature fits the bill. You can insert comments, view comments and even edit the existing comments in the worksheet. You may also remove comments of the cells. The example creates an excel file. It adds a comment to B1 cell of the first worksheet, accesses the comment and gives it a string note. It also sets its font, height and width of the comment. You can either open the resultant excel file into MS Excel or save directly to your disk to check the comments.

• Other Drawing Objects shows how to use other drawing objects in spreadsheets using Aspose.Cells.

D e t a i l s

This Demo describes how to add Drawing Objects to the worksheet. Aspose.Cells component provides the way to add controls (TextBox, CheckBox etc.) to a worksheet. The component allows you to customize the controls. The component also allows you insert embedded OLE objects. You may add and remove the drawing objects in the worksheet according to your needs. The example creates an excel file. It adds a text box control to B2 cell of the first worksheet, It then, adds an image and an excel file data to stream and embeds it to become an embedded OLE object in the worksheet. It also sets the border around the object. You can either open the resultant excel file into MS Excel or save directly to your disk.

• Protecting a Worksheet shows how to protect a worksheet in a workbook.

D e t a i l s

This Demo explains how to Protect the worksheet in a workbook. To prevent anyone from accidentally or deliberately changing, moving, or deleting important data, you can protect certain worksheet , workbook elements, with or without a password. Aspose.Cells component provides the way to protect your worksheet. You may protect Contents, Objects and Scenarios etc. The example makes use of an existing excel file, opens it and protect the first worksheet of the workbook without setting a password. The sheet is protected in such a way that you cannot change, move and delete anything in the first worksheet. You can either open the resultant excel file into MS Excel or save directly to your disk to check the protection.

• Advanced Protection Settings Since Excel XP shows how to use advanced protection setting of Excel XP.

D e t a i l s

The Demo customizes the Advanced Protection Settings in the worksheet in a workbook. These settings can only be implemented in MS ExcelXP or greater versions. Aspose.Cells component provides some useful APIs to protect the worksheet even at the root level. There are a number of protection options available which you may set according to your need. For example, you may implement: whether the user is allowed to filter data, whether the user is allowed to do formatting of cells, rows / columns, whether the user can add hyperlinks to the cells, whether the user can do sorting of data in the worksheet, whether the user is authorized to insert new rows / columns or select the locked cells etc. The example makes use of an existing excel file, opens it and implements some advanced protection settings in the first worksheet of the file. You can either open the resultant excel file into MS Excel or save directly to your disk to check the results.

• Unprotect a Worksheet shows how to unprotect a worksheet.

D e t a i l s

This Demo explains how to Unprotect the worksheet in a workbook. To allow anyone for changing, moving, or deleting data, you can unprotect certain worksheet and workbook elements. Aspose.Cells component provides the way to unprotect the protected worksheets. The example makes use of an existing excel file, opens it and unprotect the first worksheet of the workbook if the worksheet is protected. The sheet is unprotected in such a way that you can change, move and delete anything in the first worksheet. You can either open the resultant excel file into MS Excel or save directly to your disk to check the results

• Setting Page Options shows how to set page options in page setup settings.

D e t a i l s

This Demo describes how to implement Page Setup Settings. Many a times, you would like to configure page setup settings for your worksheets to control the printing process. For example, you may need to set