Property Getters/Setters Summary | ||
---|---|---|
method | getCount() | |
method | get(index) | |
Gets the |
Method Summary | ||
---|---|---|
method | add(upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn, fileName) | |
Adds a picture to the collection. | ||
method | add(upperLeftRow, upperLeftColumn, fileName) | |
Adds a picture to the collection. | ||
method | add(upperLeftRow, upperLeftColumn, fileName, widthScale, heightScale) | |
Adds a picture to the collection. | ||
method | addPictureFromBytes(upperLeftRow, upperLeftColumn, byte_array) | |
Adds a picture to the collection. | ||
method | addPictureFromBytes(upperLeftRow, upperLeftColumn, byte_array, lowerRightRow, lowerRightColumn) | |
Adds a picture to the collection. | ||
method | addPictureFromBytes(upperLeftRow, upperLeftColumn, widthScale, heightScale, byte_array) | |
Adds a picture to the collection. | ||
method | clear() | |
Clear all pictures. | ||
method | contains(value) | → inherited from CollectionBase |
Reserved for internal use. | ||
method | get(index) | → inherited from CollectionBase |
Reserved for internal use. | ||
method | indexOf(value) | → inherited from CollectionBase |
Reserved for internal use. | ||
method | iterator() | → inherited from CollectionBase |
method | removeAt(index) | |
Remove shapes at the specific index |
Property Getters/Setters Detail |
---|
getCount : int | |
int getCount() |
get : Picture | |
Picture get(index) |
index
- The zero based index of the element.Method Detail |
---|
add | |
int add(upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn, fileName) |
upperLeftRow: int
- Upper left row index.upperLeftColumn: int
- Upper left column index.lowerRightRow: int
- Lower right row indexlowerRightColumn: int
- Lower right column indexfileName: String
- Image filename.add | |
int add(upperLeftRow, upperLeftColumn, fileName) |
upperLeftRow: int
- Upper left row index.upperLeftColumn: int
- Upper left column index.fileName: String
- Image filename.add | |
int add(upperLeftRow, upperLeftColumn, fileName, widthScale, heightScale) |
upperLeftRow: int
- Upper left row index.upperLeftColumn: int
- Upper left column index.fileName: String
- Image filename.widthScale: int
- Scale of image width, a percentage.heightScale: int
- Scale of image height, a percentage.clear | |
clear() |
removeAt | |
removeAt(index) |
iterator | |
Iterator iterator() |
get | |
Object get(index) |
contains | |
boolean contains(value) |
indexOf | |
int indexOf(value) |
addPictureFromBytes | |
addPictureFromBytes(upperLeftRow, upperLeftColumn, byte_array, lowerRightRow, lowerRightColumn) |
upperLeftRow: int
- Upper left row indexupperLeftColumn: int
- Upper left column indexbyte_array: bytes
- The byte arraylowerRightRow: int
- Lower right row indexlowerRightColumn: int
- Lower right column indexExample:
import jpype import asposecells jpype.startJVM() from asposecells.api import * wb = Workbook(FileFormatType.XLSX) with open('cells.png', 'rb') as pic: pic_bytes = pic.read() wb.getWorksheets().get(0).getPictures().addPictureFromBytes(2, 7, byte_array=pic_bytes, lowerRightRow=10, lowerRightColumn=10) wb.save("wb.xlsx") jpype.shutdownJVM()
addPictureFromBytes | |
addPictureFromBytes(upperLeftRow, upperLeftColumn, byte_array) |
upperLeftRow: int
- Upper left row indexupperLeftColumn: int
- Upper left column indexbyte_array: bytes
- The byte arrayExample:
import jpype import asposecells jpype.startJVM() from asposecells.api import * wb = Workbook(FileFormatType.XLSX) with open('cells.png', 'rb') as pic: pic_bytes = pic.read() wb.getWorksheets().get(0).getPictures().addPictureFromBytes(2, 2, byte_array=pic_bytes) wb.save("wb.xlsx") jpype.shutdownJVM()
addPictureFromBytes | |
addPictureFromBytes(upperLeftRow, upperLeftColumn, widthScale, heightScale, byte_array) |
upperLeftRow: int
- Upper left row indexupperLeftColumn: int
- Upper left column indexwidthScale: int
- Scale of image width, a percentageheightScale: int
- Scale of image height, a percentagebyte_array: bytes
- The byte arrayExample:
import jpype import asposecells jpype.startJVM() from asposecells.api import * wb = Workbook(FileFormatType.XLSX) with open('cells.png', 'rb') as pic: pic_bytes = pic.read() wb.getWorksheets().get(0).getPictures().addPictureFromBytes(0, 0, widthScale=200, heightScale=150, byte_array=pic_bytes) wb.save("wb.xlsx") jpype.shutdownJVM()