Hi Team,
I used aspose API to add watermark to an excel file. The watermark text was added without any issues but that watermark text is editable. I am able to modify and delete the watermark text i applied “cognizant” in my case. I am pasting my source code below.
import java.io.FileInputStream;
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 CreateExcelFileWithWaterMark {
public static void main(String[] args) throws Exception {
//FileInputStream fstream = new FileInputStream(“D:\demo\Input.xls”);
//Instantiate a new Workbook
Workbook workbook = new Workbook(“D:\demo\Input.xlsx”);
System.out.println(“GOT Workbook”);
int sheets = workbook.getWorksheets().getCount();
System.out.println(“Number of sheets—>”+sheets);
//Get the first default sheet
for(int count=0;count<sheets;count++){
Worksheet sheet = workbook.getWorksheets().get(count);
System.out.println(“GOT Worksheet”);
//Add Watermark
Shape wordart = sheet.getShapes().addTextEffect(MsoPresetTextEffect.TEXT_EFFECT_1,
“cognizant”, “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:\demo\Input_watermark.xlsx”);
System.out.println(“WorkBook saved”);
}
}
Please help me in this regard
sbalumsc: