|
|
May
20,
2016
Version
3.1
Update
Excel Jetcell .NET component
|
March
24,
2016
Version
3.1
Update
Excel Jetcell .NET component
|
January
29,
2016
Version
3.1
Update
Excel Jetcell .NET component
|
October
14,
2015
Version
3.1
Update
Excel Jetcell .NET component
|
March
03,
2015
Version
3.1
Update
Excel Jetcell .NET component
|
May
15,
2013
Version
3.1
Update
Excel Jetcell .NET component
|
November
15,
2012
Version
3.1
Update
Excel Jetcell .NET component
|
|
|
|
Sample Code
|
Excel Jetcell .NET presents an easy way to set Borders of Excel Cell with help of
property Style.Borders. User can set
border style and color.
C# | VB.NET
|
There are many elements with own address in excel spreadsheet. The sample shows
how to set address or index of Excel worksheet, row, column, cell or cell range.
C# |
VB.NET
|
Cell Color and Background ( xls,
xlsx)
There are different properties of cell style that allow to set cell color, cell background, pattern or gradient (excel XLSX file format).
C# | VB.NET
|
Export Excel to DataTable
( xlsx)
Export data from Excel to DataTable in one line using function WriteToDataTable().
C# | VB.NET
|
Function ReadFromDataTable() reads data from DataTable and writes into Excel worksheet.
C# | VB.NET
|
How to read excel file, change values and save with new data. Convert excel files from xls to xlsx and vice versa.
C# | VB.NET
|
Features of Excel Jetcell .NET
( xls,
xlsx)
Excel Jetcell .NET is a mature, scalable and feature rich component that offers many functions.
C# | VB.NET
|
How to change the formatting of text in excel cell, its size, color, boldness, font etc.
C# | VB.NET
|
Excel Jetcell .NET can create, read, calculate formulas. Formula is a core of excel
automation and allows to organize a complex applications.
C# | VB.NET
|
Supported Excel formulas
( xls,
xlsx)
This sample shows the list of supported excel formulas.
C# | VB.NET
|
Each worksheet has header and footer. The text of header/footer can contain special symbols. For example, page number, count of pages, current time, alignment flag etc.
C# | VB.NET
|
First excel files. Sample writes just one string to the cell and save the file.
C# | VB.NET
|
International Languages
( xls,
xlsx)
Unicode support, international characters. The sample excel files contain text of different languages.
C# | VB.NET
|
How to create hyperlink? Set hyperlink for excel cell.
C# | VB.NET
|
How to write picture into excel worksheet?
C# | VB.NET
|
Excel Jetcell .NET presents an easy way to operate with merged cells. The sample shows how to set the text and formatting styles for merged cells in excel file.
C# | VB.NET
|
Excel cells may have number value. But numbers may have different formats: integer value, currency value, time etc.
C# | VB.NET
|
This sample shows how to read a password protected excel file.
Also the component can easily save the XLS or XLSX file with password.
C# | VB.NET
|
All hiperlinks of the excel worksheet can be read.
C# | VB.NET
|
How to save image from excel file?
C# | VB.NET
|
Excel Jetcell .NET can read/write CSV files.
C# | VB.NET
|
Excel Jetcell .NET can read/write XLS files.
C# | VB.NET
|
Excel Jetcell .NET can read/write XLS files.
C# | VB.NET
|
Template support. Create new excel file using existing excel template. The template allows to prepare the excel form with formating. Then open excel and just fill the cells.
C# | VB.NET
|
Vertical alignment, horizontal alignment, rotation, vertical direction. Different manipulation with text alignment and direction.
C# | VB.NET
|
How to add images to excel worksheet? How to set position of the image?
C# | VB.NET
|
Sample shows how to create CSV file in .NET.
C# | VB.NET
|
Sample shows how to create XLS file in .NET.
C# | VB.NET
|
Sample shows how to create XLSX file in .NET.
C# | VB.NET
|
|
|
Online Demo
|
|
|
The demo exports customer order to excel file XSL, XSLX or HTML web page.
|
|
|
Sample Code
|
|
|
Samples are the fastest way to get started with Excel Jetcell .NET
component.
|
|
|
User Experience
|
|
|
Here we public different tasks that users have resolved with help of Excel Jetcell
.NET component.
|
|
|
Docs.Excel Namespace
|
|
|
Excel Jetcell .NET provides a very simple API for developers that are very easy
to learn and use.
|
|
|
|
|
|