DEV Community: AsposeCells

Format Excel Cell Numbers to Currency in C#.NET

AsposeCells — Fri, 23 Nov 2018 18:21:43 +0000

Microsoft Excel supports wide range of Number Formats. One of these number formats is Currency. If the cell value contains number, then you can apply currency format by specifying currency symbol and decimal places. Similarly, you can format Excel cell numbers to currency using Aspose.Cells for .NET with ease. In order to perform its operation, Aspose.Cells does not need Microsoft Excel or on any sort of Microsoft Office Automation, VBA (Visual Basic for Applications), VSTO (Visual Studio Tools for Office) etc.

Article Description

The purpose of this article is to explain how developers can format Excel cell numbers to currency in C#.NET. Alternatively, you can use any .NET Framework supported language e.g. VB.NET etc.

Supported Platforms

Aspose.Cells API supports all .NET frameworks e.g. .NET 2.0, .NET 3.5, .NET 4.0, .NET 7.0, .NET Core, .NET Standard 2.0, Xamarin etc. It is also available in other platforms e.g. Java, C++, Android, JavaScript, PHP etc. Besides, Aspose.Cells is available in Cloud as REST or RESTful APIs.

Licensing

Aspose.Cells is paid or commercial api, so it is not free or open source. Without license, it will work in evaluation mode with some limitations. If you want to test Aspose.Cells without evaluation version limitations, you can also request a 30 Day Temporary License. For more information, please go through Licensing.

Format Excel Cell Numbers to Currency using Microsoft Excel

You can format Excel cell numbers to currency using Microsoft Excel by performing these steps.

Right Click the cell that contains some numeric value.
Click Format Cells… from the context menu as shown in snapshot below.
Select Currency from Number Category and press OK.

Currency Custom Number Format Strings of Cell

You can use various types of currency custom number format strings to display currencies e.g. Dollar, Yuan, Pound, Euro etc. and many others.

Dollar

"$"#,##0.00

Yaun

[$¥-804]#,##0.00

Pound

[$£-809]#,##0.00

Euro

#,##0.00[$€-40B]

Format Excel Cell Numbers to Currency using Aspose.Cells

In the next few sections, we will learn how to use Aspose.Cells API to format Excel cell numbers to currency.

Sample Input Microsoft Excel Document

For demonstration, we will use the following sample input Microsoft Excel document that contains some numbers in cells G3, G4, G5 and G6. We will apply currency format i.e. Dollar, Yuan, Pound, Euro on these cells respectively.

Sample Code

The following sample code formats Excel cells i.e. G3, G4, G5 and G6 with currency formats i.e. Dollar, Yuan, Pound, Euro respectively by performing these steps.

Load the input Excel file inside the Aspose.Cells.Workbook object and access the first worksheet.
Access first cell i.e. G3 and apply currency format using the Style.Custom property.
Repeat the second step for cell G4, G5 and G6 with further currency formats.
Save the Aspose.Cells.Workbook object in XLSX format. You can also save it to XLS or other Excel formats as per your needs.

Output Microsoft Excel XLSX by Aspose.Cells after applying Currency formats

The following snapshot shows the Output Microsoft Excel XLSX by Aspose.Cells after applying currency formats on the cells G3, G4, G5 and G6. Similarly, you can apply all sorts of currency formats on Excel cells using Aspose.Cells API.

Convert Microsoft Excel XLS to XLSX in Java

AsposeCells — Fri, 16 Nov 2018 13:21:44 +0000

XLS is an old but widely used Microsoft Excel format. It is a binary file format and known as Binary Interchange File Format (BIFF). Microsoft Excel still supports XLS format for backward compatibility but since it is an old format, many new features are not supported inside it. For that reason, XLS format is often converted to XLSX format which is a newer Open Office XML-based format and supports all new features of Microsoft Excel.

You can convert XLS to XLSX manually using Microsoft Excel 2007 or later versions e.g. Microsoft Excel 2016 etc. or programmatically using Aspose.Cells for Java API with few lines of code. In order to perform its operations, Aspose.Cells does not depend on Microsoft Excel or on any sort of Microsoft Office Automation, VBA (Visual Basic for Applications), VSTO (Visual Studio Tools for Office) etc.

Article Description

The purpose of this article is to explain how developers can convert Microsoft Excel XLS to XLSX format in Java.

Supported Platforms

Aspose.Cells API supports various platforms including Java, .NET, C++, Android, JavaScript, PHP etc. Besides, Aspose.Cells is available in Cloud as REST or RESTful APIs.

Maximum Number of Columns and Rows in XLS and XLSX

XLS format supports

65,536 Rows.
256 Columns.

XLSX format supports

1,048,576 Rows.
16,384 Columns.

Sample Input Microsoft Excel XLS Document

You can convert any XLS document to XLSX using Aspose.Cells API. For illustration, we will use the following sample input Microsoft Excel XLS document that contains textual and numerical formatted data about some companies. Whenever, you will open XLS document in Microsoft Excel, it will show Compatibility Mode as indicated by Red Arrow in the following snapshot.

Sample Code

The following sample code converts XLS to XLSX by performing these steps.

Load the input Microsoft Excel XLS document in com.aspose.cells.Workbook object.
Save the com.aspose.cells.Workbook object in XLSX format.

Output Microsoft Excel XLSX by Aspose.Cells

The following snapshot shows the Converted or Output Microsoft Excel XLSX file by Aspose.Cells with the code given above. As you can see, the output XLSX file is exactly similar to XLS file. Similarly, you can convert any XLS file to XLSX with Aspose.Cells API easily.

Create Microsoft Excel Column Chart in C++

AsposeCells — Sat, 03 Nov 2018 15:44:56 +0000

Chart is a graphical representation of data that enables user to easily understand the large quantity of data and relationships between parts of data. There are many types of charts available in Microsoft Excel and almost all of them are supported by Aspose.Cells for C++. As a matter of fact, Aspose.Cells can be used to create, edit and manipulate Excel spreadsheets almost in any platform without any need to install Microsoft Excel or without using any sort of Microsoft Office automation.

Article Description

The purpose of this article is to explain how developers can create Microsoft Excel Column Chart in C++.

Supported Platforms

Aspose.Cells API supports number of platform e.g. C++, .NET, Java, Android, JavaScript, PHP etc. Besides, Aspose.Cells is available in Cloud as REST or RESTful APIs.

Types of Column Charts

There are various types of Column charts, some of them are listed below.

Column
Column Stacked
Column 100% Stacked
Column 3D
Column 3D Clustered
Column 3D Stacked
Column 3D 100% Stacked

Sample Input Microsoft Excel Document

For demonstration, we will use the following sample input Microsoft Excel document that contains the chart data. Here, column A contains the category axis data and other columns B, C and D contain chart series data.

Sample Code

The following sample code creates Microsoft Excel Column Chart by performing these steps.

Load sample input Microsoft Excel document containing the chart data.
Create Column chart with specified dimensions.
Set the chart title and format it.
Add three vertical series, set their names and fill colors.
Format various chart items e.g. plot area, value axis, category axis, major tick marks etc.
Save the workbook in XLSX format. You can also save it in other formats e.g. XLS, XLSB, XLSM etc.

Output Microsoft Excel Column Chart by Aspose.Cells

The following snapshot shows the Output Microsoft Excel Column Chart generated by Aspose.Cells with the code given above. Similarly, you can create all sorts of Column charts with Aspose.Cells API easily.

Use AutoFilter to Filter Excel Data in C#.NET

AsposeCells — Fri, 26 Oct 2018 15:51:04 +0000

Filtering data based on criteria is a very important feature. It helps the user to understand and analyze data easily. You can use the auto filter feature of Microsoft Excel to find, show or hide values in a single or multiple columns based on the choices that you select from list. When the filter is applied, then all the rows that do not meet your criteria are hidden completely.

You can use Aspose.Cells for .NET to apply filter on your Excel data programmatically in C# easily with few lines of code. It can also be used to perform wide range of functions on Excel documents e.g. you can create, edit and manipulate Excel spreadsheets in any platform without any need to install Microsoft Excel or without using any sort of Microsoft Office automation.

Article Description

The purpose of this article is to explain how developers can use AutoFilter to filter Excel data in C# or in any .NET Framework supported language e.g. VB.NET etc.

Supported Platforms

Aspose.Cells API supports all .NET frameworks e.g. .NET 2.0, .NET 3.5, .NET 4.0, .NET 7.0, .NET Core, .NET Standard 2.0, Xamarin etc. It is also available in other platforms e.g. Java, C++, Android, JavaScript, PHP etc. Besides, Aspose.Cells is available in Cloud as REST or RESTful APIs.

Filter Data using AutoFilter in Microsoft Excel

Please do the following steps to filter data using AutoFilter in Microsoft Excel.

Select the columns and click Data > Filter button inside the Sort & Filter section.
Click the AutoFilter dropdown, select your choices from list and press OK.
All the rows that do not match your criteria will be filtered out. Please see this snapshot for detail.

Filter Data using AutoFilter in Aspose.Cells

This section explains how to filter Excel data using AutoFilter with Aspose.Cells API.

Sample Input Microsoft Excel Document

For demonstration, we will use the following sample input Microsoft Excel document that contains some data in four columns. We will apply AutoFilter on Vehicle and Color columns. Once, rows are filtered out, some of them will become hidden and the Grand Total for Qty1 and Qty2 columns shown inside the red lines will be modified accordingly.

Sample Code

The following sample code applies AutoFilter on Microsoft Excel data by performing these steps

Load sample input Microsoft Excel document containing the sample data for auto filter.
Apply auto filter to range.
Adds two filters to first column.
Refresh the auto filter.
Adds another two filters to second column.
Refresh the auto filter.
Save the workbook in XLSX format. You can also save it in other formats e.g. XLS, XLSB, XLSM etc.

Output Microsoft Excel Document by Aspose.Cells after applying AutoFilter

The following snapshot shows the Output Microsoft Excel Document generated by Aspose.Cells after applying AutoFilter with the code given above. As you can see, it now shows the filtered rows and new values of Grand Total displayed inside the red lines.

Apply Cell Borders on Excel Worksheet Cells in Java

AsposeCells — Sat, 13 Oct 2018 07:15:54 +0000

Microsoft Excel offers various types of built-in borders that can be applied to a cell or range of cells inside the worksheet. Excel cell border consists of two components i.e. line style and color. Since, there are number of line styles available in Microsoft Excel, user can also create custom borders. Aspose.Cells for Java API can be used to create any type of border, be it built-in border or custom border with ease. Besides, it can be used to create, edit and manipulate Excel spreadsheets almost in any platform without any need to install Microsoft Excel or without using any sort of Microsoft Office automation.

Article Description

The purpose of this article is to explain how developers can apply cell borders on Excel worksheet cells in Java.

Supported Platforms

Aspose.Cells API supports various platforms including Java, .NET, C++, Android, JavaScript, PHP etc. Besides, Aspose.Cells is available in Cloud as REST or RESTful APIs.

Types of Built-in Borders

Following are the types of built-in borders in Microsoft Excel that you can apply to cell.

Top
Bottom
Left
Right
Diagonal Up
Diagonal Down

Cell Border Types To Create Custom Borders

By changing line styles, you can create custom borders. Some of these line styles are mentioned below. Please also see the snapshot given below that displays line styles in Microsoft Excel Border GUI.

None
Medium
Hair
Thick
Thin
Dashed
Dotted
Dash Dotted

Caption: Border Line Styles in Microsoft Excel represented by CellBorderType in Aspose.Cells API.

Set Border of the Cell using Aspose.Cells API

All of the border types can be accessed using the BorderType enumeration. Its values are as follows

BorderType.TOP_BORDER
BorderType.BOTTOM_BORDER
BorderType.LEFT_BORDER
BorderType.RIGHT_BORDER
BorderType.DIAGONAL_UP
BorderType.DIAGONAL_DOWN

The following code accesses the top border and sets its line style and color. Similarly, you can work with any border using the BorderType enumeration.


// Set Top Border of Cell. Access cell object.
Cell cell = ws.Cells["B6"];

// Access cell style.
Style style = cell.GetStyle();

// Access top border.
Border topBorder = style.Borders[BorderType.TopBorder];

// Set the line style of the top border.
topBorder.LineStyle = CellBorderType.Thick;

// Set the color of the top border.
topBorder.Color = Color.Red;

// Set the cell style.
cell.SetStyle(style);

Sample Code

The following sample code applies cell borders on Excel worksheet cells by performing these steps.

Create empty workbook and set its default style.
Add values and format cells B3, B6, B9, D3, D6, D9, F6. Also set the borders on them.
Set Left border.
Set Right border.
Set Top border.
Set Bottom border.
Set Diagonal Up border.
Set Diagonal Down border.
Set All borders.
Save the workbook in XLSX format. You can also save it in other formats e.g. XLS, XLSB, XLSM etc.

Output Microsoft Excel Cell Borders By Aspose.Cells

The following snapshot shows Output Microsoft Excel Cell Borders generated by Aspose.Cells with the code given above. Similarly, you can create all sorts of built-in and custom borders easily with Aspose.Cells API.

Caption: Excel Cell Borders, Left, Right, Up, Bottom, Diagonal Up and Down created by Aspose.Cells API.

Create Microsoft Excel Line Chart in C#.NET

AsposeCells — Sat, 06 Oct 2018 14:29:59 +0000

Chart is a graphical representation of data that enables user to easily understand the large quantity of data and relationships between parts of data. There are many types of charts available in Microsoft Excel and almost all of them are supported by Aspose.Cells for .NET. Aspose.Cells can be used to create, edit and manipulate Excel spreadsheets almost in any platform without any need to install Microsoft Excel or without using any sort of Microsoft Office automation.

Article Description

The purpose of this article is to explain how developers can create Microsoft Excel Line Chart in C#.NET.

Supported Platforms

Aspose.Cells API supports all .NET frameworks e.g. .NET 2.0, .NET 3.5, .NET 4.0, .NET 7.0, .NET Core, .NET Standard 2.0, Xamarin etc. It is also available in other platforms e.g. Java, C++, Android, JavaScript, PHP etc. Besides, Aspose.Cells is available in Cloud as REST or RESTful APIs.

Types of Line Charts

There are various types of Line charts, some of them are listed below.

Line
Line Stacked
Line 100% Stacked
Line with Data Markers
Line Stacked with Data Markers
Line 100% Stacked with Data Markers

Sample Input Microsoft Excel Document

Caption: Sample Input Microsoft Excel Document containing Chart Data.

Sample Code

The following sample code creates Microsoft Excel Line Chart by performing these steps.

Load sample input Microsoft Excel document containing the chart data.
Create Line chart with specified dimensions.
Apply the two color gradient on the chart area.
Set the chart title and format it.
Add three vertical series, set their names and line weights.
Format various chart items e.g. plot area, value axis, category axis, major tick marks etc.
Save the workbook in XLSX format. You can also save it in other formats e.g. XLS, XLSB, XLSM etc.

Output Microsoft Excel Line Chart by Aspose.Cells

The following snapshot shows the Output Microsoft Excel Line Chart generated by Aspose.Cells with the code given above. Similarly, you can create all sorts of Line charts with Aspose.Cells API easily.

Caption: Microsoft Excel Line Chart created by Aspose.Cells API.

Convert TSV to PDF in C++

AsposeCells — Fri, 05 Oct 2018 10:19:37 +0000

Aspose.Cells is capable of loading TSV file and converting it to PDF with diverse options. In this article, we will explain how C++ developers can use Aspose.Cells API to convert TSV to PDF ...

Directly
With One Page Per Sheet Option

TSV Info:

TSV file is an abbreviation of Tab-separated values because it uses Tab to separate fields in a row.

Aspose.Cells Info:

Aspose.Cells API supports number of platform e.g. .NET, Java, C++, Android, JavaScript, PHP etc. Besides, Aspose.Cells is available in Cloud as REST or RESTful APIs.

Sample TSV File

You can try the code given in this article with any TSV file. But for illustration purpose, we use this sample TSV file inside the code as shown in this image for your reference.

Caption: Sample TSV file to be converted to PDF formats using Aspose.Cells API

Convert TSV to PDF Directly

The following sample code loads the sample TSV file as shown earlier and converts it to PDF directly.

The following screenshot shows the output PDF file generated by the above code for your reference. As you can see inside the screenshot, output PDF has two pages. If you want to render everything on a single PDF page, you can use One Page Per Sheet option that will be explained soon.

Caption: Convert TSV to PDF Directly using Aspose.Cells API

Convert TSV to PDF with One Page Per Sheet option

The following sample code loads the sample TSV file and converts it to PDF with One Page Per Sheet option specified using the PdfSaveOptions class.

The following screenshot shows the output PDF file generated by the above code for your reference. As you can see inside the screenshot, the entire TSV contents are rendered on a single PDF page.

Caption: Convert TSV to PDF with One Page Per Sheet option using Aspose.Cells API

Convert TSV to PDF in Java

AsposeCells — Fri, 05 Oct 2018 10:18:59 +0000

Aspose.Cells is capable of loading TSV file and converting it to PDF with diverse options. In this article, we will explain how Java developers can use Aspose.Cells API to convert TSV to PDF ...

Directly
With One Page Per Sheet Option

TSV Info:

TSV file is an abbreviation of Tab-separated values because it uses Tab to separate fields in a row.

Aspose.Cells Info:

Aspose.Cells API supports number of platform e.g. .NET, Java, C++, Android, JavaScript, PHP etc. Besides, Aspose.Cells is available in Cloud as REST or RESTful APIs.

Sample TSV File

You can try the code given in this article with any TSV file. But for illustration purpose, we use this sample TSV file inside the code as shown in this image for your reference.

Caption: Sample TSV file to be converted to PDF formats using Aspose.Cells API

Convert TSV to PDF Directly

The following sample code loads the sample TSV file as shown earlier and converts it to PDF directly.

Caption: Convert TSV to PDF Directly using Aspose.Cells API

Convert TSV to PDF with One Page Per Sheet option

The following sample code loads the sample TSV file and converts it to PDF with One Page Per Sheet option specified using the PdfSaveOptions class.

The following screenshot shows the output PDF file generated by the above code for your reference. As you can see inside the screenshot, the entire TSV contents are rendered on a single PDF page.

Caption: Convert TSV to PDF with One Page Per Sheet option using Aspose.Cells API

Convert TSV to PDF in C#.NET

AsposeCells — Fri, 05 Oct 2018 10:18:20 +0000

Aspose.Cells is capable of loading TSV file and converting it to PDF with diverse options. In this article, we will explain how C# or .NET developers can use Aspose.Cells for .NET API to convert TSV to PDF ...

Directly
With One Page Per Sheet Option

TSV Info:

TSV file is an abbreviation of Tab-separated values because it uses Tab to separate fields in a row.

Aspose.Cells Info:

Aspose.Cells API supports all .NET frameworks e.g. .NET 2.0, .NET 3.5, .NET 4.0, .NET 7.0, .NET Core, .NET Standard 2.0, Xamarin and can be used to develop both ASP.NET web sites and Windows Forms application. It is also available in other platforms e.g. Java, C++, Android, JavaScript, PHP etc. Besides, Aspose.Cells is available in Cloud as REST or RESTful APIs.

Sample TSV File

You can try the code given in this article with any TSV file. But for illustration purpose, we use this sample TSV file inside the code as shown in this image for your reference.

Caption: Sample TSV file to be converted to PDF formats using Aspose.Cells API

Convert TSV to PDF Directly

The following sample code loads the sample TSV file as shown earlier and converts it to PDF directly.

Caption: Convert TSV to PDF Directly using Aspose.Cells API

Convert TSV to PDF with One Page Per Sheet option

The following sample code loads the sample TSV file and converts it to PDF with One Page Per Sheet option specified using the PdfSaveOptions class.

The following screenshot shows the output PDF file generated by the above code for your reference. As you can see inside the screenshot, the entire TSV contents are rendered on a single PDF page.

Caption: Convert TSV to PDF with One Page Per Sheet option using Aspose.Cells API

Copy Excel Range to Worksheet in C++

AsposeCells — Tue, 25 Sep 2018 07:40:18 +0000

Microsoft Excel Range can contain a single cell or multiple cells. It has a start cell and end cell. All the cells that lie within start cell and end cell constitutes a range. Sometimes, user wants to copy a range of cells to some other location inside the same worksheet or to some other location inside the different worksheet.

The purpose of this article is to explain how the C++ developers or programmers can use Aspose.Cells in their applications to copy Excel range to same worksheet or different worksheet.

Aspose.Cells API supports number of platform e.g. .NET, Java, C++, Android, JavaScript, PHP etc. Besides, Aspose.Cells is available in Cloud as RESTful APIs.

Copy Excel Range to Same Worksheet

The following C++ sample code loads the sample Excel file inside the Aspose.Cells Workbook object. It then accesses the first worksheet which contains the source Excel range that we want to copy to same worksheet. It then uses the Range.Copy() method to copy it to new location inside the worksheet.

The following screenshot shows the sample Excel file used inside the code and the output Excel file generated by the code for your reference. As you can see inside the screenshot, the source Excel range has been copied to the destination Excel range.

Caption: Excel Range copied to different location inside the Same Worksheet using Aspose.Cells API

Copy Excel Range to Different Worksheet

The following C++ sample code loads the sample Excel file inside the Aspose.Cells Workbook object. It accesses the first worksheet which contains the source Excel range and the second worksheet where source range is to be copied. It then copies source range of first worksheet into destination range inside second worksheet using the Range.Copy() method.

The following screenshot shows the sample Excel file used inside the code and the output Excel file generated by the code for your reference. As you can see inside the screenshot, the source Excel range has been copied to the destination Excel range in different worksheet.

Caption: Excel Range copied to Different Worksheet using Aspose.Cells API

Copy Excel Range to Worksheet in Java

AsposeCells — Tue, 25 Sep 2018 07:39:28 +0000

The purpose of this article is to explain how the Java developers or programmers can use Aspose.Cells in their applications to copy Excel range to same worksheet or different worksheet.

Aspose.Cells API supports number of platform e.g. .NET, Java, C++, Android, JavaScript, PHP etc. Besides, Aspose.Cells is available in Cloud as REST or RESTful APIs.

Copy Excel Range to Same Worksheet

The following Java sample code loads the sample Excel file inside the Aspose.Cells Workbook object. It then accesses the first worksheet which contains the source Excel range that we want to copy to same worksheet. It then uses the Range.copy() method to copy it to new location inside the worksheet.

Caption: Excel Range copied to different location inside the Same Worksheet using Aspose.Cells API

Copy Excel Range to Different Worksheet

The following Java sample code loads the sample Excel file inside the Aspose.Cells Workbook object. It accesses the first worksheet which contains the source Excel range and the second worksheet where source range is to be copied. It then copies source range of first worksheet into destination range inside second worksheet using the Range.copy() method.

The following screenshot shows the sample Excel file used inside the code and the output Excel file generated by the code for your reference. As you can see inside the screenshot, the source Excel range has been copied to the destination Excel range in different worksheet.

Caption: Excel Range copied to Different Worksheet using Aspose.Cells API

Copy Excel Range to Worksheet in C#.NET

AsposeCells — Tue, 25 Sep 2018 07:35:56 +0000

The purpose of this article is to explain how the C# developers or programmers can use Aspose.Cells for .NET in their applications to copy Excel range to same worksheet or different worksheet.

Aspose.Cells API supports all .NET frameworks e.g. .NET 2.0, .NET 3.5, .NET 4.0, .NET 7.0, .NET Core, .NET Standard 2.0, Xamarin and can be used to develop both ASP.NET web sites and Windows Forms application. It is also available in other platforms e.g. Java, C++, Android, JavaScript, PHP etc. Besides, Aspose.Cells is available in Cloud as REST or RESTful APIs.

Copy Excel Range to Same Worksheet

The following C# sample code loads the sample Excel file inside the Aspose.Cells Workbook object. It then accesses the first worksheet which contains the source Excel range that we want to copy to same worksheet. It then uses the Range.Copy() method to copy it to new location inside the worksheet.

Caption: Excel Range copied to different location inside the Same Worksheet using Aspose.Cells API

Copy Excel Range to Different Worksheet

The following C# sample code loads the sample Excel file inside the Aspose.Cells Workbook object. It accesses the first worksheet which contains the source Excel range and the second worksheet where source range is to be copied. It then copies source range of first worksheet into destination range inside second worksheet using the Range.Copy() method.

The following screenshot shows the sample Excel file used inside the code and the output Excel file generated by the code for your reference. As you can see inside the screenshot, the source Excel range has been copied to the destination Excel range in different worksheet.

Caption: Excel Range copied to Different Worksheet using Aspose.Cells API

DEV Community: AsposeCells

Format Excel Cell Numbers to Currency in C#.NET

Format Excel Cell Numbers to Currency using Microsoft Excel

Currency Custom Number Format Strings of Cell

Dollar

Yaun

Pound

Euro

Format Excel Cell Numbers to Currency using Aspose.Cells

Sample Input Microsoft Excel Document

Sample Code

Output Microsoft Excel XLSX by Aspose.Cells after applying Currency formats

Convert Microsoft Excel XLS to XLSX in Java

Maximum Number of Columns and Rows in XLS and XLSX

Sample Input Microsoft Excel XLS Document

Sample Code

Output Microsoft Excel XLSX by Aspose.Cells

Create Microsoft Excel Column Chart in C++

Types of Column Charts

Sample Input Microsoft Excel Document

Sample Code

Output Microsoft Excel Column Chart by Aspose.Cells

Use AutoFilter to Filter Excel Data in C#.NET

Filter Data using AutoFilter in Microsoft Excel

Filter Data using AutoFilter in Aspose.Cells

Sample Input Microsoft Excel Document

Sample Code

Output Microsoft Excel Document by Aspose.Cells after applying AutoFilter

Apply Cell Borders on Excel Worksheet Cells in Java

Types of Built-in Borders

Cell Border Types To Create Custom Borders

Set Border of the Cell using Aspose.Cells API

Sample Code

Output Microsoft Excel Cell Borders By Aspose.Cells

Create Microsoft Excel Line Chart in C#.NET

Types of Line Charts

Sample Input Microsoft Excel Document

Sample Code

Output Microsoft Excel Line Chart by Aspose.Cells

Convert TSV to PDF in C++

Sample TSV File

Convert TSV to PDF Directly

Convert TSV to PDF with One Page Per Sheet option

See also

Convert TSV to PDF in Java

Sample TSV File

Convert TSV to PDF Directly

Convert TSV to PDF with One Page Per Sheet option

See also

Convert TSV to PDF in C#.NET

Sample TSV File

Convert TSV to PDF Directly

Convert TSV to PDF with One Page Per Sheet option

See also

Copy Excel Range to Worksheet in C++

Copy Excel Range to Same Worksheet

Copy Excel Range to Different Worksheet

See also

Copy Excel Range to Worksheet in Java

Copy Excel Range to Same Worksheet

Copy Excel Range to Different Worksheet

See also

Copy Excel Range to Worksheet in C#.NET

Copy Excel Range to Same Worksheet

Copy Excel Range to Different Worksheet

See also