Jun
25
Posted on 25-06-2019
Filed Under (Uncategorized) by Oana

easyXLS export excel chart datatable vbnetDisplay and format Excel chart data table using EasyXLS library! XLS, XLSX, XLSM, XLSB file in .NET.

https://www.easyxls.com/manual/tutorials/vb-net/show-excel-chart-datatable.html

(0) Comments    Read More   
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   
Jan
12
Posted on 12-01-2015
Filed Under (Uncategorized) by Daniela

Import data from Excel in C# or VB.NET

EasyXLS in an Excel library for C# and VB.NET that can be used to import Excel files in C# or VB.NET applications, like ASP.NET web application (including MVC), WinForms applications or console applications.

The Excel library works without Excel installed and without OLEDB. It is not dependent on other additional software.

Great tips about importing Excel files using EasyXLS can be found on the following links:

EasyXLS allows the import of Excel data or any other information contained inside the Excel file.

This Excel library allows the importing of XLSX, XLS, XLSM or XLSB file formats for Microsoft Excel 97, 2003, 2007, 2010 and 2013.

The imported Excel files can have one sheet or multiple sheets. It also permits the import of ranges of Excel data.

EasyXLS can be used from ASP.NET applications and this code sample about how to import Excel to GridView in ASP.NET is handy.

EasyXLS can be also used from WinForms and this code sample about how to import Excel to DataGridView in C# or VB.NET is practical.

For importing Excel data to a more general data structure this code sample about how to import Excel to DataTable in C# and VB.NET is more useful.

Another common situation is related to Excel files and databases. This code sample shows how to import Excel data to SQL database in C# and VB.NET.

(0) Comments    Read More   
Dec
09
Posted on 09-12-2014
Filed Under (Uncategorized) by Daniela

import Excel to SQL databaseEasyXLS Excel library makes possible the import of Excel file into SQL tables without OLEDB engine.

The Excel library can be used from WinForms or ASP.NET web applications that uses MS SQL Server, MySQL, MS Access, Oracle or any other database.

The data that can be imported from Excel file might be from XLSX, XLS, XLSM or XLSB files.

EasyXLS permits the import of data from entire Excel sheet or only from a range of cells.

See source code samples and more details about how to import Excel to SQL table in C# or VB.NET.

(0) Comments    Read More   
Oct
27
Posted on 27-10-2014
Filed Under (Uncategorized) by Oana

Export data to Excel in C# or VB.NETEasyXLS Excel library lets you to export data to Excel in .NET from WinForms or ASP.NET applications.

The library works without Excel installed and without Interop. It is not dependent on other additional software.

Great tricks about exporting to Excel using EasyXLS can be found on the following links:

EasyXLS supports the export of data in XLSX, XLSM, XLS and XLSB file formats for Microsoft Excel 97, 2003, 2007, 2010 and 2013. It is constantly updated to be in line with Microsoft Excel changes.

The Excel library allows you to export data from windows applications. Read more details about how to export to Excel from winform.

It also allows you to export data from ASP.NET web applications. Read more details about how to export to Excel in ASP.NET.

EasyXLS permits you to export data fast and it handles very well large Excel files.

Using this Excel library, string values, numeric values, dates or booleans can be successfully exported to Excel. It also supports formulas and even more, it includes a calculation engine for formulas. The data can be exported to Excel files having multiple sheets.

EasyXLS is a C# Excel library and VB.NET Excel library that can be integrated in any .NET application.

(0) Comments    Read More   
Oct
20
Posted on 20-10-2014
Filed Under (Uncategorized) by Oana

export DataGridView to Excel in .NETHave you ever had a WinForm that shows a nice report inside a DataGridView? It looks great! Now, you want to export this report to Excel and you’re asking yourself, “How can I do this?”. You have the button that it says “Export to Excel”, but now “What should I do?”. If this is your case, you are now on the right page. If you have never confronted with this situation, who knows, maybe tomorrow will surprise you and you can be ready from now on. See..you’re still on the right page.

EasyXLS Excel library makes such tasks so much easier to achieve. When it comes to export data to Excel, EasyXLS is the best choice. It offers all kind of methods and solutions that make complicated things uncomplicated when Excel files are involved.

Now, let’s get back to our DataGridView and “Export to Excel” button. Using EasyXLS, you can export DataGridView to XLSX, XLS, XLSM or XLSB file formats. The Excel file can also have multiple sheets and you can choose the right sheet where the DataGridView can fit. Do you have a huge DataGridView? EasyXLS handles very well exporting large data to Excel. If I have captured your attention, see here how to export DataGridView to Excel in C# and VB.NET.

In most of the cases the data source of the DataGridView is a DataTable. If so, have you ever thought that the export to Excel can be done with one line of code? Check this sample on exporting DataTable to Excel file in C# and VB.NET.

Now get your keyboard back to work. Happy coding!

(0) Comments    Read More