Aspose.Cells - Export Data from Worksheets

//Creating a file stream containing the Excel file to be opened
FileInputStream fstream = new FileInputStream("data/workbook.xls");

//Instantiating a Workbook object
Workbook workbook = new Workbook(fstream);

//Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);

//Exporting the contents of 7 rows and 2 columns starting from 1st cell to Array.
Object dataTable [][] = worksheet.getCells().exportArray(4,0,7,8);

for (int i = 0 ; i < dataTable.length ; i++)
{
	System.out.println("["+ i +"]: "+ Arrays.toString(dataTable[i]));
}
//Closing the file stream to free all resources
fstream.close();

Download Source Code

For More Examples, Please Visit Aspose Docs

Last edited May 9, 2014 at 4:59 AM by shoaibkhan, version 2