Import Data to Worksheets using Aspose.Cells

Aspose.Cells - Import Data to Worksheets

Import Data from Arrays

Java

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

 // Obtaining the reference of the newly added worksheet by passing its sheet index
 int sheetIndex = workbook.getWorksheets().add();
 Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);

 // ==================================================

 // Creating an array containing names as string values
 String[] names = new String[]{"laurence chen", "roman korchagin", "kyle huang"};

 // Importing the array of names to the 1st row and first column vertically
 Cells cells = worksheet.getCells();
 cells.importArray(names, 0, 0, false);

Import Data from ArrayList

Java

 ArrayList<String> list = new ArrayList<String>();

 // Add a few names to the list as string values
 list.add("laurence chen");
 list.add("roman korchagin");
 list.add("kyle huang");

 // Importing the contents of the ArrayList to the 1st row and first column vertically
 cells.importArrayList(list, 2, 0, true);

 // ==================================================

 // Saving the Excel file
 workbook.save(dataDir + "AsposeDataImport.xls");

Download Running Code

• GitHub

Download Sample Code

• GitHub