Hi,
It is already supported in the latest version of Aspose.Cells for JAVA
v7.1.0, please try it. Here is the sample code for your reference.
Sample code:
//Creating a Workbook object
Workbook workbook = new Workbook();
//Creating a string variable to store the url of the logo/picture
String logo_url = "d:\\school.jpg";
//Creating the instance of the FileInputStream object to open the logo/picture in the stream
FileInputStream inFile = new FileInputStream(logo_url);
//Creating a PageSetup object to get the page settings of the first worksheet of the workbook
PageSetup pageSetup = workbook.getWorksheets().get(0).getPageSetup();
//Setting the logo/picture in the central section of the page footer
pageSetup.setFooter(1, "&G");
byte[] picData = new byte[inFile.available()];
inFile.read(picData);
pageSetup.setFooterPicture(1,picData);
Picture pic = workbook.getWorksheets().get(0).getPageSetup().getPicture(false, 1);
pic.setHeight(50);
pic.setWidth(40);
//Setting the Sheet's name in the right section of the page header with the script
pageSetup.setHeader(2, "&A");
//Saving the workbook
workbook.save("d:\\headerpic.xls");
//Closing the FileStream object
inFile.close();
Thank you.
Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us
