AsposeWorkingWithColors.java

package featurescomparison.workingwithformattingfeatures.workingwithcolors.java;

import com.aspose.cells.BackgroundType;
import com.aspose.cells.Cell;
import com.aspose.cells.Cells;
import com.aspose.cells.Color;
import com.aspose.cells.Font;
import com.aspose.cells.Style;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;

public class AsposeWorkingWithColors
{
	public static void main(String[] args) throws Exception
	{
		String dataPath = "src/featurescomparison/workingwithformattingfeatures/workingwithcolors/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();

		// === Setting Background Pattern ===
		
		//Accessing cell from the worksheet
		Cell cell = cells.get("B2");
		Style style = cell.getStyle();
		
		//Setting the foreground color to yellow
		style.setBackgroundColor(Color.getYellow());
		
		//Setting the background pattern to vertical stripe
		style.setPattern(BackgroundType.VERTICAL_STRIPE);
		
		//Saving the modified style to the "A1" cell.
		cell.setStyle(style);
		
		// === Setting Foreground ===
		
		//Adding custom color to the palette at 55th index
		Color color = Color.fromArgb(212,213,0);
		workbook.changePalette(color,55);
		
		//Accessing the "A2" cell from the worksheet
		cell = cells.get("B3");
		
		//Adding some value to the cell
		cell.setValue("Hello Aspose!");
		
		//Setting the custom color to the font
		style = cell.getStyle();
		Font font = style.getFont();
		font.setColor(color);
		
		cell.setStyle(style);
		
		//Saving the Excel file
		workbook.save(dataPath + "AsposeColors_Out.xls");
		
		System.out.println("Aspose Colors Created.");

	}
}