generate spreadsheet

[shank]

<% Response.conten ttype = "applicatio n/vnd.ms-excel" %>
<% Response.AddHea der "Content-Disposition", "filename=hardw are.xls" %>

I'm using the above lines to generate a spreadsheet from a recordset. One of
the recordset fields has HTML data. Whenever the spreadsheet is generated,
it will place some of the HTML data into new rows. Same appropriate column,
but different rows. Is there a way around this?

Is there an easy to create a DBF or CSV file that would work?
thanks

[Mike Florio]

I'm sure there are other ways to run the command shell, but this freebie has
always worked for me:

see AspExec at:
http://www.serverobjects.com/products.htm#free


"shank" <sh***@tampabay .rr.com> wrote in message
news:Og******** ******@TK2MSFTN GP12.phx.gbl...

<% Response.conten ttype = "applicatio n/vnd.ms-excel" %>
<% Response.AddHea der "Content-Disposition", "filename=hardw are.xls" %>

I'm using the above lines to generate a spreadsheet from a recordset. One of the recordset fields has HTML data. Whenever the spreadsheet is generated,
it will place some of the HTML data into new rows. Same appropriate column, but different rows. Is there a way around this?

Is there an easy to create a DBF or CSV file that would work?
thanks

[Mike Florio]

Sorry - replied to the wrong post !
"Mike Florio" <mi**@micro-point.com> wrote in message
news:10******** *****@corp.supe rnews.com...

I'm sure there are other ways to run the command shell, but this freebie has always worked for me:

see AspExec at:
http://www.serverobjects.com/products.htm#free


"shank" <sh***@tampabay .rr.com> wrote in message
news:Og******** ******@TK2MSFTN GP12.phx.gbl...

<% Response.conten ttype = "applicatio n/vnd.ms-excel" %>
<% Response.AddHea der "Content-Disposition", "filename=hardw are.xls" %>

I'm using the above lines to generate a spreadsheet from a recordset. One

of

the recordset fields has HTML data. Whenever the spreadsheet is

generated, it will place some of the HTML data into new rows. Same appropriate

column,

but different rows. Is there a way around this?

Is there an easy to create a DBF or CSV file that would work?
thanks

[UncleWobbly]

I never trusted this method and whereas CSVs don't have the "bells n
whistles" of an XLS, if all you want is data in a tabular file... CSV has to
be the format...

you can do this *really* easily just open "myfile.csv " with the FSO and
right your data seperated by commas... remember that if your data has vommas
in it, you'll have to translate them before writing out or enclose the
offending string in ""

the code I use (highly chopped and I use unixtime and session ID to make a
unique filename)

Set trs = Server.CreateOb ject("ADODB.Rec ordset")
trs.open sql, objconn ,3 ,3
alldata=trs.Get Rows

strPathInfo = "TempCSV/" & session("sessio nid") & Datediff("s",
"1/1/1970",now) & ".csv"
strPhysicalPath = Server.MapPath (strPathInfo)
set fs=Server.Creat eObject("Script ing.FileSystemO bject")
set f=fs.OpenTextFi le(strPhysicalP ath,8,true,Tris tateFalse)

for n=0 to ubound(alldata, 2)
ln=""
for m=0 to ubound(alldata, 1)
ln=ln & chr(34) & trim(alldata(m, n)) & chr(34) & ","
next
f.WriteLine(ln)
next

f.close
objconn.close
Set objconn = nothing
Set trs = nothing
set fs=nothing
set f=nothing

H

"shank" <sh***@tampabay .rr.com> wrote in message
news:Og******** ******@TK2MSFTN GP12.phx.gbl...

<% Response.conten ttype = "applicatio n/vnd.ms-excel" %>
<% Response.AddHea der "Content-Disposition", "filename=hardw are.xls" %>

I'm using the above lines to generate a spreadsheet from a recordset. One of the recordset fields has HTML data. Whenever the spreadsheet is generated,
it will place some of the HTML data into new rows. Same appropriate column, but different rows. Is there a way around this?

Is there an easy to create a DBF or CSV file that would work?
thanks

[Tom Kaminski [MVP]]

"shank" <sh***@tampabay .rr.com> wrote in message
news:Og******** ******@TK2MSFTN GP12.phx.gbl...

<% Response.conten ttype = "applicatio n/vnd.ms-excel" %>
<% Response.AddHea der "Content-Disposition", "filename=hardw are.xls" %>

I'm using the above lines to generate a spreadsheet from a recordset. One of the recordset fields has HTML data. Whenever the spreadsheet is generated,
it will place some of the HTML data into new rows. Same appropriate column, but different rows. Is there a way around this?

Write out all of your content into an HTML table.

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

[Dave Anderson]

"shank" wrote:

<% Response.conten ttype = "applicatio n/vnd.ms-excel" %> ...

...One of the recordset fields has HTML data. Whenever the
spreadsheet is generated, it will place some of the HTML
data into new rows. Same appropriate column, but different
rows. Is there a way around this?

Server.HTMLEnco de(RS.Fields("y ourField")Value ) ?
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[shank]

Server.HTMLEnco de helped stop some of the new rows, but creates another
problem. In my database I have a text field that contains HTML formatted
data for hardware specs. It includes the whole gamut of HTML syntax:
<li><ul><p><br> , etc etc etc. What I was hoping to do is export that field
into an excel cell so that a user can cut-n-paste straight into their own
pages.

How do I do that?
thanks!

"Dave Anderson" <GT**********@s pammotel.com> wrote in message
news:Of******** ******@TK2MSFTN GP10.phx.gbl...

"shank" wrote:

<% Response.conten ttype = "applicatio n/vnd.ms-excel" %> ...

...One of the recordset fields has HTML data. Whenever the
spreadsheet is generated, it will place some of the HTML
data into new rows. Same appropriate column, but different
rows. Is there a way around this?
Server.HTMLEnco de(RS.Fields("y ourField")Value ) ?
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message.

Use of this email address implies consent to these terms. Please do not contact me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[shank]

"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:bu******** **@kcweb01.netn ews.att.com...

"shank" <sh***@tampabay .rr.com> wrote in message
news:Og******** ******@TK2MSFTN GP12.phx.gbl...

<% Response.conten ttype = "applicatio n/vnd.ms-excel" %>
<% Response.AddHea der "Content-Disposition", "filename=hardw are.xls" %>

I'm using the above lines to generate a spreadsheet from a recordset. One

of

the recordset fields has HTML data. Whenever the spreadsheet is

generated, it will place some of the HTML data into new rows. Same appropriate

column,

but different rows. Is there a way around this?

Write out all of your content into an HTML table.

--
Tom Kaminski IIS MVP

I'm not sure what you mean by writing to a table. I have a database field
with text data that includes HTML formatting. I'm trying to drop a that
field into an excel cell so another user can cut-n-paste into their own
pages without having to change anything. How an I get that done? There's
some 150+ products that will be generated into the spreadsheet. 1 product
per each row.
thanks

[Tom Kaminski [MVP]]

"shank" <sh***@tampabay .rr.com> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:bu******** **@kcweb01.netn ews.att.com...

"shank" <sh***@tampabay .rr.com> wrote in message
news:Og******** ******@TK2MSFTN GP12.phx.gbl...

<% Response.conten ttype = "applicatio n/vnd.ms-excel" %>
<% Response.AddHea der "Content-Disposition", "filename=hardw are.xls" %>
I'm using the above lines to generate a spreadsheet from a recordset. One

of

the recordset fields has HTML data. Whenever the spreadsheet is

generated, it will place some of the HTML data into new rows. Same appropriate

column,

but different rows. Is there a way around this?

Write out all of your content into an HTML table.

--
Tom Kaminski IIS MVP

I'm not sure what you mean by writing to a table. I have a database field
with text data that includes HTML formatting. I'm trying to drop a that
field into an excel cell so another user can cut-n-paste into their own
pages without having to change anything. How an I get that done? There's
some 150+ products that will be generated into the spreadsheet. 1 product
per each row.

Each table cell will equate to an Excel cell when you open the page ...

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

[shank]

"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:bu******** **@kcweb01.netn ews.att.com...

"shank" <sh***@tampabay .rr.com> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:bu******** **@kcweb01.netn ews.att.com...

"shank" <sh***@tampabay .rr.com> wrote in message
news:Og******** ******@TK2MSFTN GP12.phx.gbl...
> <% Response.conten ttype = "applicatio n/vnd.ms-excel" %>
> <% Response.AddHea der "Content-Disposition", "filename=hardw are.xls" %> >
> I'm using the above lines to generate a spreadsheet from a

recordset. One

of
> the recordset fields has HTML data. Whenever the spreadsheet is generated,

> it will place some of the HTML data into new rows. Same appropriate
column,
> but different rows. Is there a way around this?

Write out all of your content into an HTML table.

--
Tom Kaminski IIS MVP

I'm not sure what you mean by writing to a table. I have a database field with text data that includes HTML formatting. I'm trying to drop a that
field into an excel cell so another user can cut-n-paste into their own
pages without having to change anything. How an I get that done? There's
some 150+ products that will be generated into the spreadsheet. 1 product per each row.

Each table cell will equate to an Excel cell when you open the page ...

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running

IIS http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

I still lose all my HTML tags. A user cannot cut-n-paste into their pages
keeping HTML tags intact. Here's an example of exactly what I would like to
have inthe excel cell...

<ul>
<li>Height 142 - 260cm (56" - 102")
<li>Top Aluminum Tube Diameter 38mm (1.50")
<li>Weight 3.0Kg (6.60lb)
<li>Load Capacity 50Kg (110lb)</li></ul>

Presently, all my tags are gone and only the text shows in the cells. I need
the above contents intact.
thanks