Import data from document

Data is a collection of raw facts, and we create spreadsheet documents or reports to present these raw facts in a more meaningful manner. Normally we add data to spreadsheets ourselves, but sometimes we need to reuse existing data resources, and here comes the need to import data into spreadsheets from different data sources. In this topic, we will discuss some techniques to import data into worksheets from different data sources.

Importing Data Using Aspose.Cells
When you use Aspose.Cells to open an Excel file, all data in the file is automatically imported, but Aspose.Cells also supports importing data from different data sources. A few of these data sources are listed below:

Array
ArrayList
DataTable
DataColumn
DataView
DataGrid
DataReader
GridView

Aspose.Cells provides a class, Workbook, that represents an Excel file. The Workbook class contains a Worksheets collection that allows access to each worksheet in the Excel file. A worksheet is represented by the Worksheet class. The Worksheet class provides a Cells collection.

The Cells collection provides very useful methods for importing data from different data sources.

This section has the following topics:

Export data from document