Adding watermark image as background to excel file

Hi Team,


I am trying to add an image (.png file or .jpg file) as background to all sheets in a excel file but not able to find method for the same. However I am able to add some text like “confidential” as background to the excel. Please find below code.

import com.aspose.cells.Color;
import com.aspose.cells.MsoFillFormat;
import com.aspose.cells.MsoLineFormat;
import com.aspose.cells.MsoPresetTextEffect;
import com.aspose.cells.Shape;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;

public class AddWaterMarkToExcelFile {

public static void main(String[] args)throws Exception {
// TODO Auto-generated method stub
//Instantiate a new Workbook
Workbook workbook = new Workbook();

//Get the first default sheet
Worksheet sheet = workbook.getWorksheets().get(0);

//Add Watermark
Shape wordart = sheet.getShapes().addTextEffect(MsoPresetTextEffect.TEXT_EFFECT_1,
“CONFIDENTIAL”, “Arial Black”, 50, false, true
, 18, 8, 1, 1, 130, 800);
//Get the fill format of the word art
MsoFillFormat wordArtFormat = wordart.getFillFormat();

//Set the color
wordArtFormat.setForeColor(Color.getRed());

//Set the transparency
wordArtFormat.setTransparency(0.9);

//Make the line invisible
MsoLineFormat lineFormat = wordart.getLineFormat();
lineFormat.setVisible(false);

//Save the file
workbook.save(“d:\images\Watermarkt_Test.xls”);
System.out.println(“done”);
}

}

Can you please help to add image as background instead of text.

Regards
Balu

Hi,


Please see the document on how to specify background image for Excel sheets via Aspose.Cells APIs for your reference:
http://www.aspose.com/docs/display/cellsjava/Set+Background+Picture+for+a+Worksheet

Hope, this helps a bit.

Thank you.