Is there a way limit or filter the output from HTMLData

M

Marc Bumgarner

I'm using OWC10 to load data from SQLServer using the following code
snippet:
.....
datastr = rs.GetString(, , ",", cRecSep, vbNullString)
oSprd.CSVData = datastr
ostream.WriteText oSprd.HTMLData
ostream.SaveToFile App.Path & "\OWC.HTM", adSaveCreateOverWrite
WebBrowser1.navigate App.Path & "\OWC.HTM"
......
This seems to work fine but what I have found is that the output from
HTMLData is very large 2-5 MB depending on number of row,columns,formulas
etc.. Is there a way to limit the output without using addition processing
on the output.

Thanks,

Marc
 
M

Marc Bumgarner

No


Alvin Bruney said:
Did you get help on this?

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Marc Bumgarner said:
I'm using OWC10 to load data from SQLServer using the following code
snippet:
....
datastr = rs.GetString(, , ",", cRecSep, vbNullString)
oSprd.CSVData = datastr
ostream.WriteText oSprd.HTMLData
ostream.SaveToFile App.Path & "\OWC.HTM", adSaveCreateOverWrite
WebBrowser1.navigate App.Path & "\OWC.HTM"
.....
This seems to work fine but what I have found is that the output from
HTMLData is very large 2-5 MB depending on number of row,columns,formulas
etc.. Is there a way to limit the output without using addition processing
on the output.

Thanks,

Marc
Click to expand...
Click to expand...
 
A

Alvin Bruney [MVP]

perhaps the easiest fix for this is to use a different file format. HTML is
bulky in nature and so pushing even simple data incurs overhead relating to
formatting the HTML. You can use the raw CSV format which has very little
overhead. Infact it should only contain commas and line breaks. This would
substantially reduce your network load.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Marc Bumgarner said:
No


Alvin Bruney said:
Did you get help on this?

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
Marc Bumgarner said:
I'm using OWC10 to load data from SQLServer using the following code
snippet:
....
datastr = rs.GetString(, , ",", cRecSep, vbNullString)
oSprd.CSVData = datastr
ostream.WriteText oSprd.HTMLData
ostream.SaveToFile App.Path & "\OWC.HTM", adSaveCreateOverWrite
WebBrowser1.navigate App.Path & "\OWC.HTM"
.....
This seems to work fine but what I have found is that the output from
HTMLData is very large 2-5 MB depending on number of row,columns,formulas
etc.. Is there a way to limit the output without using addition processing
on the output.

Thanks,

Marc
Click to expand...
Click to expand...
Click to expand...
 
Top