SpireXLS

There are kinds of ways to export data from database into the spreadsheet. Database vendor provides database tools to export data. These tools can export the data to xml, sql statements or csv files which can be imported into Excel. However, it is not...

Excel spreadsheet is one part of entire Excel File, which simulates a paper, accounting worksheet. Spreadsheet is made up with lots of cells which form rows and columns. As the primary part of Excel, how do we create an Excel spreadsheet in C#? This article...

With .Net, we can deal with many problems of Excel. During the process, kinds of data, Excel objects are used to achieve acquirements, such as transfer data to Excel workbook, interaction of Excel workbooks. After an Excel workbook is finished, we need...

After learning the basic knowledge of VBA and knowing how to write and run program, do you want to know how to control Excel automatically? Excel is organized by objects so that we need to learn Excel VBA Objects firstly if automating Excel. There are...