Aspose.Cells - Import Data to Worksheets

Import Data from Arrays

//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 1st row and first column vertically
Cells cells = worksheet.getCells();

Import Data from ArrayList

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

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

//Importing the contents of ArrayList to 1st row and first column vertically

//Saving the Excel file"data/AsposeDataImport.xls");

Download Source Code

For More Examples, Please Visit Aspose Docs

Last edited May 9, 2014 at 6:00 AM by shoaibkhan, version 2