EasyXLS

VB6 tutorials

Tutorials for getting started with EasyXLS Excel library in VB6 that can be used from Visual Basic integrated development environment:

Tutorial 1


How to export list to Excel in VB6

Tutorial 2


How to export list to Excel in custom format in VB6

Tutorial 3


How to create Excel file in VB6

Tutorial 4


How to export data to XLSX file in VB6

Tutorial 5


How to format Excel cells in VB6

Tutorial 6


How to protect cells and sheet elements in VB6

Tutorial 7


How to add comment to cell in VB6

Tutorial 8


How to set header and footer in VB6

Tutorial 9


How to set page setup options and page breaks in VB6

Tutorial 10


How to merge cells in VB6

Tutorial 11


How to add formulas in cells in VB6

Tutorial 12


How to create named ranges in VB6

Tutorial 13


How to add cell validation in VB6

Tutorial 14


How to create conditional formatting in VB6

Tutorial 15


How to add hyperlinks in VB6

Tutorial 16


How to insert images in VB6

Tutorial 17


How to group rows or columns in VB6

Tutorial 18


How to freeze rows or columns in VB6

Tutorial 19


How to set rich text format in cells in VB6

Tutorial 20


How to apply auto-filter in VB6

Tutorial 21


How to create a chart sheet in VB6

Tutorial 22


How to display chart datatable in VB6

Tutorial 23


How to set chart type, chart area, plot area, X axis, Y axis, series and legend in VB6

Tutorial 24


How to create chart in a worksheet in VB6

Tutorial 25


How to create pivot table in VB6

Tutorial 26


How to create pivot charts in VB6

Tutorial 27


How to protect Excel file with password in VB6

Tutorial 28


How to export data to XLS file in VB6

Tutorial 29


How to export data to XLSB file in VB6

Tutorial 30


How to export data to CSV file in VB6

Tutorial 31


How to export data to HTML file in VB6

Tutorial 32


How to export data to XML Spreadsheet file in VB6

Tutorial 33


How to set file properties for Excel file in VB6

Tutorial 34


How to import data from Excel to list in VB6

Tutorial 35


How to import Excel sheet data to list in VB6

Tutorial 36


How to read XLSX file in VB6

Tutorial 37


How to read XLS file in VB6

Tutorial 38


How to read XLSB file in VB6

Tutorial 39


How to convert CSV file to Excel in VB6

Tutorial 40


How to convert HTML file to Excel in VB6

Tutorial 41


How to convert XML spreadsheet file to Excel in VB6

Auxiliary files


Go to top

EasyXLS Excel libraries:

.NET
Excel Library for VB6
full COM+ version to import, export or convert Excel files
Excel Writer for VB6
COM+ version to create and export Excel files
Excel Reader for VB6
COM+ version to read and import Excel files
Express Excel Writer for VB6
limited COM+ version to create and export Excel files in predefined formats
Download EasyXLS™ Excel Component for VB6

File formats:

Office 365
MS Excel 2021 - 2024
MS Excel 2007 - 2019
MS Excel 97 - 2003
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT