Aug
17
Posted on 17-08-2015
Filed Under (Uncategorized) by Daniela

Create pivot chart in Excel EasyXLS is an Excel library that lets you create pivot charts inside Excel files programmatically.

The library can be integrated in various programming languages like .NET based (C#, VB.NET, C++.NET and J#), languages that support COM technology (PHP, ASP classic, VBS, VB6, C++), Java or languages where Java can be incorporated (ColdFusion).

EasyXLS provides code samples and tutorials for each of the mentioned programming languages. You may check the following link for directions on how to create a pivot chart in Excel in C#, VB.NET, Java, C++, PHP and other languages.

The pivot chart is in a closed relation with a pivot table. For code samples and tutorials about pivot tables visit how to create a pivot table in Excel in C#, VB.NET, Java, C++, PHP and other languages.

The library supports a wide variety of chart types that can be set for the pivot chart like column chart, bar chart, line chart, pie chart, scatter chart, area chart, doughnut chart, radar chart, surface chart, bubble chart, stock chart, cylinder chart, cone chart and pyramid chart.

All the chart elements can be formatted including chart area, plot area, X and Y axis, legend, gridlines, data table, chart title and axis titles, 3D rotation, elevation and perspective.

If not familiar with pivot charts in MS Excel or for technical related details, learn about Excel pivot tables and pivot charts.

(0) Comments    Read More   
Aug
10
Posted on 10-08-2015
Filed Under (Uncategorized) by Oana

password protected excel file‪Create or read password protected Excel files in C#, VB.NET, Java, C++, PHP and other!

EasyXLS™ library enables you to protect your Excel file from unauthorized access by setting passwords for opening or / and modifying the document. If you set the password for opening the file, the Excel file will be encrypted.
http://www.easyxls.com/manual/basics/password-protected-excel-file.html

(0) Comments    Read More   
Aug
03

Create Excel filter or autofilter‪Create Excel pivot tables in C#.NET, VB.NET, Java, C++, PHP and other, using EasyXLS Excel library! The pivot tables are reports in Excel that summarize worksheet data for a customized and clearer view over it. EasyXLS library allows you to create a pivot table in Excel, to set the data source and to arrange its data and fields into desired areas.
http://www.easyxls.com/manual/basics/excel-pivot-table.html

If not familiar with pivot tables in MS Excel or for technical related details, learn about Excel pivot tables.

(0) Comments    Read More   

Create Excel filter or autofilter‪Create Excel filter or autofilter in C#.NET, VB.NET, Java, C++, PHP and other, using EasyXLS Excel library! It permits to filter a range of data from an Excel sheet and hide records that don’t meet your criteria, displaying just a subset of data in a range of cells.
http://www.easyxls.com/manual/basics/excel-filter-and-autofilter.html

(0) Comments    Read More   
Apr
25
Posted on 25-04-2015
Filed Under (Uncategorized) by Oana

Create Excel chart types in C#, VB.NET, Java, PHP, C++ and other programming languages‪How many chart types can you create in Excel, using EasyXLS Excel library, in C#, VB.NET, Java, PHP, C++ and other programming languages?

http://www.easyxls.com/manual/basics/excel-chart-types.html

(0) Comments    Read More   
Apr
20
Posted on 20-04-2015
Filed Under (Uncategorized) by Oana

Create Excel chart sheet in C#, VB.NET, Java, PHP, C++ and other programming languages‪Create Excel charts that can be placed in a separate sheet. A chart can have two positions, as a distinct sheet or as an object in a worksheet. EasyXLS also allows you to read Excel files that contain charts and extract chart information.

http://www.easyxls.com/manual/basics/excel-chart-sheet.html

(0) Comments    Read More   
Apr
14
Posted on 14-04-2015
Filed Under (Uncategorized) by Oana

Create Excel charts inside a worksheet in C#, VB.NET, Java, PHP, C++ and other programming languages


Create Excel charts that can be positioned inside a worksheet in C#, VB.NET, Java, PHP, C++ and other programming languages! A chart can have two positions, as a distinct sheet or as an object in a worksheet.

http://www.easyxls.com/manual/basics/excel-chart-inside-sheet.html

(0) Comments    Read More   
Apr
06
Posted on 06-04-2015
Filed Under (Uncategorized) by Oana

Import Excel data to MySQL, SQL Server in PHP or ASP classic


Import Excel data to MySQL, SQL Server in PHP or ASP classic! The data can be imported from an Excel sheet or from the active Excel sheet. The entire sheet data or only data from a range of cells can be imported.

http://www.easyxls.com/manual/FAQ/import-excel-to-mysql.html

(0) Comments    Read More   
Mar
30
Posted on 30-03-2015
Filed Under (Uncategorized) by Oana

Import data from Excel file in PHP or ASP classic

‪Import data from Excel file in PHP or ASP classic. The Excel file can have one or multiple sheets. You may also import from other sheet elements like cell formatting, charts, pivot tables, comments, images and others.

http://www.easyxls.com/manual/FAQ/import-excel-in-php-asp.html

(0) Comments    Read More   
Mar
23
Posted on 23-03-2015
Filed Under (Uncategorized) by Oana

Export data to an Excel file in PHP or ASP classic

‪Export data to an Excel file having one or multiple sheets in PHP or ASP classic! The data in cells can be formatted using predefined formats or user-defined formats.

http://www.easyxls.com/manual/FAQ/export-to-excel-in-php-asp.html

(0) Comments    Read More