Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export images to Excel

Status
Not open for further replies.
Sep 1, 2004
9
US
Hello,

I am new to html and asp so bare with me here. I am doing an export feature which works fine. The table is displayed on the webpage and then I export the info from the table into Excel.

One of the colums on the table has a checkmark, and when I try to export this field I do not get anything. Can jpgs be exported to excel? If not, can anyone point me in the right dirction of some reading I can do to keep the check on the table but have some other value (such as T or F) to show up in the column?

Thanks
Jennifer
 
What kind of table are we talking about here. HTML table or a table from a database. When you export boolean values to excel, the standard formatting for a Yes/No field in a table shows as True/False in Excel. Are you gathering info from the user and then going directly to Excel?
It might help to post your code so we can see that.

Paul
 
Are you exporting the values from your web page into an existing Excel file or are you building the file from scratch?

Another thing to think about is that when you submit an HTML form, the value of checkboxes is not included in the Request unless the box is actually checked. Unchecked boxes are simply not submitted. Perhaps this is the root of your problem?
 
Thank you for the comments, I have decided to go with the t/f in the excel and I am going to use id's and append the values to the id. Then I will display into excel using the vbscript part of my code.

Thanks again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top