Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Can -putexcel- be used to export graphs in .tiff format? Appears no?

    Hi,

    I have used -putexcel- to export graphs easily if the graph is in .png format. It appears it cannot be done in a .tiff format?

    This works for .png files:
    Code:
            graph export graph.png, 
            putexcel A1 = picture (graph.png) 
            putexcel save
    This does not work for .tiff files:
    Code:
            graph export graph.tif, 
            putexcel A1 = picture (graph.tif) 
            putexcel save
    This also does not work for .tiff files:
    Code:
            graph export "graph.tif", as(tif) replace
            putexcel A1 = picture("graph.tif")
            putexcel save
    Also does not seem to make a difference if I use -putexcel save- or -putexcel close-.

    Thanks for any insights!

  • #2
    I've not tried to experiment, but I found this in the help:

    image(filename) writes a portable network graphics (.png), JPEG (.jpg), Windows metafile (.wmf), device-independent bitmap (.dib), enhanced metafile (.emf), or
    bitmap (.bmp) file to an Excel worksheet. The upper-left corner of the image is aligned with the upper-left corner of the specified ul_cell. The image is not
    resized. If filename contains spaces, it must be enclosed in double quotes.
    I can't see mention of picture() in the help.
    Last edited by Nick Cox; 15 Feb 2025, 03:13.

    Comment

    Working...
    X