functional overview
Write the image into an open Excel file.
Details of Functions
line numberandcolumn numberInserts the image into the cell specified in
filename patternIf a wildcard is used forimage pathThe first matching file in name order will be used among the files stored in
If no matching file is found, a file named "default.png" will be used.
- Operation Status by OS
-
OS run state (of a process) Android Not supported. iOS Not supported. Windows Works only on PCs with Excel 2008 or later installed.
- note
-
How to write images
If both the width and height of the cell are 27 pixels or more,line numberandcolumn numberThe image is centered in the center of the cell specified in
In addition, the image is scaled to fit within the cell, maintaining the proportions of the height and width of the image.
If either the width or height of the cell is 26 pixels or less, the top left vertex of the image is centered in the cell specified by the row and column numbers.
In this case, the image is not scaled.
parameter
- argument (e.g. function, program, programme)
-
line number numeric data
Specifies the line number on which the image will be written.column number numeric data
Specifies the column number into which the image will be written.image path character string data
Specify the folder where the images to be written are stored.filename pattern character string data
Specifies the file name of the image to be written.
Wildcards (* and ?) can be used.
- return value
- without