Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Literally displaying imported cells with and tags
Hi,
I'm exporting contents to excel from a web application. Each row looks like this: "3101" "American Express" "Fort Lauderdale" "FL" "Deployed" "Windows 2001R1" "<![CDATA[<HTML <BODY <P <BIMPORTANT:</B We have updated server. You must click the button again to receive your account information. <P More text goes here </P </BODY </HTML]]" However, when the file is opened in Excel only the text in the last column is displayed (the tags and all the other cells are missing). How do I get excel to just print all columns and the literal contents without trying to do anything smart? I know if I get rid of the <HTML and <BODY tags it works, but unfortunately I need to leave them in - and they need to show up as <HTML and <BODY. Any ideas? thanks, Orlando |
#3
|
|||
|
|||
Hi Jon,
Thanks for replying. I'll go figure this out, but if you have a second can you explain where the Application and ActiveCell objects come from? I was just writing directly to Response.Write, setting the content type to excel, and letting Windows just open the file naturally from the association. It looks like you're directly manipulating excel, which is an avenue I haven't investigated before. Thanks again, Orlando |
#4
|
|||
|
|||
Jon's code is a macro that's run from inside excel.
Application is Excel (itself) and Activecell is a range object within excel. Activecell represents the cell that's selected (or if the selection is multi-cells, it represents the "white" one in that selected area). You may want to read David McRitchie's intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm wrote: Hi Jon, Thanks for replying. I'll go figure this out, but if you have a second can you explain where the Application and ActiveCell objects come from? I was just writing directly to Response.Write, setting the content type to excel, and letting Windows just open the file naturally from the association. It looks like you're directly manipulating excel, which is an avenue I haven't investigated before. Thanks again, Orlando -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|