Home All Groups Group Topic Archive Search About

Export a Graphic to Excel Spreadsheets

Author
24 Oct 2007 8:19 PM
cmdolcet69
What would be the easiest way to export a graphic (I have yet to
determine what type of graphic, .jpg, bitmap....) however im open to
suggestion, also how can i export my graphic so that it appear in the
Excell spreadsheet?

Author
25 Oct 2007 2:33 PM
eBob.com
Since you are posting here I assume that you are creating this Excel
spreadsheet in a VB.Net program.  If that's the case I have done this
recently and can find the code and post it here if you'd like.  BUT ... what
I found after doing all the work (research mostly) to add my .jpg files to a
spreadsheet is that the pictures did not sort with the rest of the row.
This still astounds me, but I did some Google newsgroup searches and found
that this is a known problem/behavior.  I should add that my application is
not using the latest Excel, so maybe this problem/behavior has been
fixed/improved.  Depending on the intended use of the spreadsheet you are
producing maybe you could use a link to the jpg/graphic instead.  That's not
as nice as a click is required to see the graphic but does not have the sort
problem.  Just let me know if you'd like me to post the code I mentioned.
And if you find that the problem with sorting graphics does not exist in the
latest Excel please let me know via the newsgroup.

Bob

Show quoteHide quote
"cmdolcet69" <colin_dolce***@hotmail.com> wrote in message
news:1193257198.550810.259240@i38g2000prf.googlegroups.com...
> What would be the easiest way to export a graphic (I have yet to
> determine what type of graphic, .jpg, bitmap....) however im open to
> suggestion, also how can i export my graphic so that it appear in the
> Excell spreadsheet?
>
Author
29 Nov 2007 9:37 PM
cmdolcet69
Show quote Hide quote
On Oct 25, 9:33 am, "eBob.com" <faken***@totallybogus.com> wrote:
> Since you are posting here I assume that you are creating thisExcel
> spreadsheet in a VB.Net program.  If that's the case I have done this
> recently and can find the code and post it here if you'd like.  BUT ... what
> I found after doing all the work (research mostly) to add my .jpg files to a
> spreadsheet is that the pictures did not sort with the rest of the row.
> This still astounds me, but I did some Google newsgroup searches and found
> that this is a known problem/behavior.  I should add that my application is
> not using the latestExcel, so maybe this problem/behavior has been
> fixed/improved.  Depending on the intended use of the spreadsheet you are
> producing maybe you could use a link to the jpg/graphicinstead.  That's not
> as nice as a click is required to see thegraphicbut does not have the sort
> problem.  Just let me know if you'd like me to post the code I mentioned.
> And if you find that the problem with sorting graphics does not exist in the
> latestExcelplease let me know via the newsgroup.
>
> Bob
>
> "cmdolcet69" <colin_dolce***@hotmail.com> wrote in message
>
> news:1193257198.550810.259240@i38g2000prf.googlegroups.com...
>
>
>
> > What would be the easiest way toexportagraphic(I have yet to
> > determine what type ofgraphic, .jpg, bitmap....) however im open to
> > suggestion, also how can iexportmygraphicso that it appear in the
> > Excell spreadsheet?- Hide quoted text -
>
> - Show quoted text -

Bob, sorry for the late replay. I would really Appreciate if you could
post the code. That way i can see if this will work for me.
Thanks again!