RetroBBS - comp.lang.xharbour - insert .jpg in excel cell

insert .jpg in excel cell

<8bb09d48-672a-401f-9125-0afe636b838an@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=17840&group=comp.lang.xharbour#17840

copy link Newsgroups: comp.lang.xharbour

X-Received: by 2002:a05:620a:8f15:b0:775:7eb3:87bf with SMTP id rh21-20020a05620a8f1500b007757eb387bfmr865qkn.0.1695844114554;
Wed, 27 Sep 2023 12:48:34 -0700 (PDT)
X-Received: by 2002:a4a:4109:0:b0:573:540a:fe3b with SMTP id
x9-20020a4a4109000000b00573540afe3bmr966959ooa.0.1695844114274; Wed, 27 Sep
2023 12:48:34 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!border-2.nntp.ord.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Wed, 27 Sep 2023 12:48:33 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=173.70.133.203; posting-account=jZAeNwoAAABYWjMRM-FfqKkHfC3Iph0l
NNTP-Posting-Host: 173.70.133.203
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <8bb09d48-672a-401f-9125-0afe636b838an@googlegroups.com>
Subject: insert .jpg in excel cell
From: timecosting@gmail.com (timepro timesheet)
Injection-Date: Wed, 27 Sep 2023 19:48:34 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 20

by: timepro timesheet - Wed, 27 Sep 2023 19:48 UTC

-how to insert/display a .jpg file in a cell-

oexcel=createobject('excel.application')
oexcel:workbooks:add()
osheet=oexcel:activesheet
....
....
* C_imgfile=diskname()+':\'+mytaxfolder+'\tick.jpg'
how to insert/display C_imgfile in a cell:
e.g.: osheet:cells(xrow,xcol):value=C_IMGFILE && what's the exact syntax?
* ....
....
osheet=oexcel:activesheet();osheet:rows(freezerow):select();oexcel:activewindow:freezepanes=.t.
oexcel:activeworkbook:saveas(xlsname)
xcelRows1:=osheet:UsedRange:Rows:Count()
oexcel:workbooks:open(xlsname)
oexcel:visible=.t.

TIA

Re: insert .jpg in excel cell

<uf39tq$3j2bs$1@dont-email.me>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17841&group=comp.lang.xharbour#17841

copy link Newsgroups: comp.lang.xharbour

Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: e.m.giordano@emagsoftware.it (Enrico Maria Giordano)
Newsgroups: comp.lang.xharbour
Subject: Re: insert .jpg in excel cell
Date: Thu, 28 Sep 2023 09:27:55 +0200
Organization: A noiseless patient Spider
Lines: 18
Message-ID: <uf39tq$3j2bs$1@dont-email.me>
References: <8bb09d48-672a-401f-9125-0afe636b838an@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Thu, 28 Sep 2023 07:27:54 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="9c5a5ede6b9ca7218abd28ffa4f2bb3c";
logging-data="3770748"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/N79QGyFspLfvBm7T98dx9"
User-Agent: Mozilla Thunderbird
Cancel-Lock: sha1:ifl6+nw/Rc9C4jElWiSlZQaRtCQ=
Content-Language: it
In-Reply-To: <8bb09d48-672a-401f-9125-0afe636b838an@googlegroups.com>

by: Enrico Maria Giordan - Thu, 28 Sep 2023 07:27 UTC

Il 27/09/2023 21:48, timepro timesheet ha scritto:

> -how to insert/display a .jpg file in a cell-

oSheet:Shapes:AddPicture( cImg, .F., .T., 0, 0, 200, 150 )

cImg is the full path and name of the file.

--
Enrico Maria Giordano

http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

Re: insert .jpg in excel cell

<734c832b-5cf7-4863-85d6-bca3d592550dn@googlegroups.com>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17842&group=comp.lang.xharbour#17842

copy link Newsgroups: comp.lang.xharbour

X-Received: by 2002:a05:6214:1867:b0:656:3452:c9a9 with SMTP id eh7-20020a056214186700b006563452c9a9mr26099qvb.10.1695929023286;
Thu, 28 Sep 2023 12:23:43 -0700 (PDT)
X-Received: by 2002:a05:6870:769b:b0:1cc:a8f0:2ee8 with SMTP id
dx27-20020a056870769b00b001cca8f02ee8mr812872oab.2.1695929023022; Thu, 28 Sep
2023 12:23:43 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!border-2.nntp.ord.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Thu, 28 Sep 2023 12:23:42 -0700 (PDT)
In-Reply-To: <uf39tq$3j2bs$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=173.70.133.203; posting-account=jZAeNwoAAABYWjMRM-FfqKkHfC3Iph0l
NNTP-Posting-Host: 173.70.133.203
References: <8bb09d48-672a-401f-9125-0afe636b838an@googlegroups.com> <uf39tq$3j2bs$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <734c832b-5cf7-4863-85d6-bca3d592550dn@googlegroups.com>
Subject: Re: insert .jpg in excel cell
From: timecosting@gmail.com (timepro timesheet)
Injection-Date: Thu, 28 Sep 2023 19:23:43 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 22

by: timepro timesheet - Thu, 28 Sep 2023 19:23 UTC

On Thursday, September 28, 2023 at 12:57:58 PM UTC+5:30, Enrico Maria Giordano wrote:
> Il 27/09/2023 21:48, timepro timesheet ha scritto:
>
> > -how to insert/display a .jpg file in a cell-
> oSheet:Shapes:AddPicture( cImg, .F., .T., 0, 0, 200, 150 )
>
> cImg is the full path and name of the file.
>
> --
> Enrico Maria Giordano
>
> http://www.emagsoftware.it
> http://www.emagsoftware.it/emgmusic
> http://www.emagsoftware.it/spectrum
> http://www.emagsoftware.it/tbosg

thanks
but, the .jpg is inserted at what cell co-ords?
e.g. if the .jpg is to be displayed/saved in cell(10,29), what would be the syntax.

TIA.

Re: insert .jpg in excel cell

<uf4k95$3qvdj$1@dont-email.me>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17843&group=comp.lang.xharbour#17843

copy link Newsgroups: comp.lang.xharbour

Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: e.m.giordano@emagsoftware.it (Enrico Maria Giordano)
Newsgroups: comp.lang.xharbour
Subject: Re: insert .jpg in excel cell
Date: Thu, 28 Sep 2023 21:30:45 +0200
Organization: A noiseless patient Spider
Lines: 17
Message-ID: <uf4k95$3qvdj$1@dont-email.me>
References: <8bb09d48-672a-401f-9125-0afe636b838an@googlegroups.com>
<uf39tq$3j2bs$1@dont-email.me>
<734c832b-5cf7-4863-85d6-bca3d592550dn@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Thu, 28 Sep 2023 19:30:45 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="9c5a5ede6b9ca7218abd28ffa4f2bb3c";
logging-data="4029875"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/UuTIq3850vPzFLn5O0tsE"
User-Agent: Mozilla Thunderbird
Cancel-Lock: sha1:Zuf9XBYEYt/LsMqvvtsxfJHcZ2U=
Content-Language: it
In-Reply-To: <734c832b-5cf7-4863-85d6-bca3d592550dn@googlegroups.com>

by: Enrico Maria Giordan - Thu, 28 Sep 2023 19:30 UTC

Il 28/09/2023 21:23, timepro timesheet ha scritto:

> but, the .jpg is inserted at what cell co-ords?
> e.g. if the .jpg is to be displayed/saved in cell(10,29), what would be the syntax.

https://learn.microsoft.com/en-us/office/vba/api/excel.shapes.addpicture

--
Enrico Maria Giordano

http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

Polymer physicists are into chains.

devel / comp.lang.xharbour / insert .jpg in excel cell

Subject	Author
insert .jpg in excel cell	timepro timesheet
Re: insert .jpg in excel cell	Enrico Maria Giordano
Re: insert .jpg in excel cell	timepro timesheet
Re: insert .jpg in excel cell	Enrico Maria Giordano