Export Data from Worksheets in xlsx4j

Aspose.Cells - Export Data from Worksheets

Aspose.Cells not only lets its users import data to worksheets from external data sources but also allows them to export worksheet data to an array.

Java

 //Creating a file stream containing the Excel file to be opened
FileInputStream fstream = new FileInputStream(dataDir + "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 an 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]));
}

Download Running Code

• GitHub

Download Sample Code

• GitHub

For more details, visit Exporting Data from Worksheets.