473,378 Members | 1,622 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Export a Graphic to Excel Spreadsheets

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?

Oct 24 '07 #1
3 2509
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

"cmdolcet69" <co************@hotmail.comwrote in message
news:11**********************@i38g2000prf.googlegr oups.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?

Oct 25 '07 #2
On Oct 25, 9:33 am, "eBob.com" <faken...@totallybogus.comwrote:
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.comwrote in message

news:11**********************@i38g2000prf.googlegr oups.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!
Nov 29 '07 #3
Look for the message I posted to this newsgroup on 9/6/2007. (I had
forgotten that I had posted it.)

Good Luck, Bob

"cmdolcet69" <co************@hotmail.comwrote in message
news:e7**********************************@e1g2000h sh.googlegroups.com...
On Oct 25, 9:33 am, "eBob.com" <faken...@totallybogus.comwrote:
>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.comwrote in message

news:11**********************@i38g2000prf.googleg roups.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!

Dec 1 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Keon | last post by:
Hoi, I'm using a database with alot of records in 1 table (more than 3000). If i want to export this table to excel i only get it till record 2385. Do someone know how i can solve this...
4
by: sunilkeswani | last post by:
I need help with exporting data from 2 access tables, into 2 existing spreadsheets in a single Excel file. Currently, I am using this code: DoCmd.TransferSpreadsheet acExport, 8, "Table1",...
1
by: Steven | last post by:
Hi there, I am trying to export a chart using the Excel11 object from C#. I can properly open workbooks and read cells, but calling Export() on the Chart object throws a COMException ...
11
by: Grey | last post by:
is it possible to export excel directly from ASP.NET to Excel? My requirement is that the data on the datagrid is exported to MS Excel file after user clicks the button on the web page. Excel will be...
0
by: Rich Wallace | last post by:
Hello all, Looking for suggestions and tips if possible. I have an application running on a file server that utilizes the FileSystemWatcher to trap when any Excel files are saved by a user. I...
5
by: Chase Kang #52 | last post by:
Using VB.NET, I've created a report that takes data from a stored procedure, which goes into some aspx page controls, and inserts that data into a pre-formatted Excel spreadsheet template by using...
0
by: DrewYK | last post by:
I have the project that may never end in front of me. I am creating a routine that will take SpreadSheets from Excel and bring them into Access. I am not using any "DoCmd"s because the goal...
2
by: Marisol2 | last post by:
I have some queries in Access 2003 db that I have setup to display as pivots. I can go into design pivot table view and click on and then click on Export to Office MicroSoft Excel. The problem is I...
0
by: SlowNsteady | last post by:
Hi My name is Sri. This is my first question to this forum Forgive me if i posted this question in the wrong forum. I want to export a the picture which is in the doc file to excel sheet. i...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.