Hantera bilder
Contents
[
Hide
]
Aspose.Cells tillåter utvecklare att lägga till bilder i kalkylblad under körning. Dessutom kan placeringen av dessa bilder styras under körning, vilket diskuteras mer i detalj i de kommande avsnitten.
Aspose.Cells for Java stöder endast bildformat: BMP, JPEG, PNG, GIF.
Index som används i exempel börjar från 0.
Lägga till bilder
Det är väldigt enkelt att lägga till bilder i ett kalkylblad. Det tar bara några rader kod.
Ring helt enkeltLägg till metod förBilder samling (inkapslad iArbetsblad objekt). DeLägg till metod tar följande parametrar:
- Övre vänstra radens index, indexet för den övre vänstra raden.
- Övre vänstra kolumnindex, indexet för den övre vänstra kolumnen.
- Bildfilens namn, namnet på bildfilen, komplett med sökväg.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java | |
| // The path to the documents directory. | |
| String dataDir = Utils.getDataDir(AddingPictures.class); | |
| // Instantiating a Workbook object | |
| Workbook workbook = new Workbook(); | |
| WorksheetCollection worksheets = workbook.getWorksheets(); | |
| // Obtaining the reference of first worksheet | |
| Worksheet sheet = worksheets.get(0); | |
| // Adding a picture at the location of a cell whose row and column indices are 5 in the worksheet. It is "F6" cell | |
| int pictureIndex = sheet.getPictures().add(5, 5, dataDir + "logo.jpg"); | |
| Picture picture = sheet.getPictures().get(pictureIndex); | |
| // Saving the Excel file | |
| workbook.save(dataDir + "book1.xls"); |
Placering av bilder
Bilder kan placeras med Aspose.Cells enligt följande:
Absolut positionering
Utvecklare kan placera bilderna absolut genom att användasetUpperDeltaX ochsetUpperDeltaY metoder förBildobjekt.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java | |
| // The path to the documents directory. | |
| String dataDir = Utils.getDataDir(AbsolutePositioning.class); | |
| // Instantiating a Workbook object | |
| Workbook workbook = new Workbook(); | |
| // Obtaining the reference of the newly added worksheet. | |
| int sheetIndex = workbook.getWorksheets().add(); | |
| Worksheet worksheet = workbook.getWorksheets().get(sheetIndex); | |
| // Adding a picture at the location of a cell whose row and column indices are 5 in the worksheet. It is "F6" cell | |
| int pictureIndex = worksheet.getPictures().add(5, 5, dataDir + "logo.jpg"); | |
| Picture picture = worksheet.getPictures().get(pictureIndex); | |
| // Positioning the picture proportional to row height and colum width | |
| picture.setUpperDeltaX(200); | |
| picture.setUpperDeltaY(200); | |
| // Saving the Excel file | |
| workbook.save(dataDir + "test_pictures.xls"); |