AsposeInsertCellsData.java

package featurescomparison.workingwithworkbook.adddataincells.java;

import com.aspose.cells.Cell;
import com.aspose.cells.Cells;
import com.aspose.cells.Style;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;

public class AsposeInsertCellsData
{
	public static void main(String[] args) throws Exception
	{
		String dataPath = "src/featurescomparison/workingwithworkbook/adddataincells/data/";
		
		//Instantiating a Workbook object
		Workbook workbook = new Workbook();
		
		//Accessing the added worksheet in the Excel file
		Worksheet worksheet = workbook.getWorksheets().get(0);
		Cells cells = worksheet.getCells();
		
		cells.get("A1").setValue("Hello World"); //Adding a string value to the cell
		cells.get("A2").setValue(20.5); //Adding a double value to the cell
		cells.get("A3").setValue(15); //Adding an integer  value to the cell
		cells.get("A4").setValue(true); //Adding a boolean value to the cell
		
		Cell cell = cells.get("A5"); //Adding a date/time value to the cell
		cell.setValue(java.util.Calendar.getInstance());
		
		//Setting the display format of the date
		Style style = cell.getStyle();
		style.setNumber(15);
		cell.setStyle(style);
		
		workbook.save(dataPath + "DataInCells_Aspose_Out.xls"); //Saving the Excel file

		// Print message
		System.out.println("Data Added Successfully");
	}
}