473,395 Members | 1,404 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,395 software developers and data experts.

How to implement freeze panes concept(which is already exists in the ms-excel) in the web pages

Hi,

I am a asp programmer.I am displaying the db records in the
html pages in a web page.I have 500 columns and 1000 rows in that html
table.Here i am planning to implement the "MS-Excel Freeze Panes"
concept.How to implement this concept in a web page.If any body have
the code or good resource please send me.

Thanks in Advance

Srinivas

Nov 23 '05 #1
7 2925
"srinivas" <ni********@gmail.com> wrote in message
news:11********************@g14g2000cwa.googlegrou ps.com...
Hi,

I am a asp programmer.I am displaying the db records in the
html pages in a web page.I have 500 columns and 1000 rows in that html
table.Here i am planning to implement the "MS-Excel Freeze Panes"
concept.How to implement this concept in a web page.If any body have
the code or good resource please send me.

Thanks in Advance

Srinivas

A Google Groups search of
"table thead tbody freeze group:microsoft.public.*"
found these:

http://groups.google.com/group/alt.h...2b18ff8fdf9ce4
6/b803b53a6cbebc3a?lnk=st&q=table+thead+tbody+freeze +group%3Amicrosoft.publi
c.*&rnum=1&hl=en#b803b53a6cbebc3a
http://groups.google.com/group/micro...ipt/browse_thr
ead/thread/315150d74f77a5e1/a603205f830c365a?lnk=st&q=table+thead+tbody+free
ze+group%3Amicrosoft.public.*&rnum=2&hl=en#a603205 f830c365a
Nov 23 '05 #2
I am unable to open above links please give me some useful resources or
code

Thanks for your help

--Srinivas

Nov 23 '05 #3
"srinivas" <ni********@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
I am unable to open above links please give me some useful resources or
code

Thanks for your help

--Srinivas


Each link is one line so you may have to cut-amnd-paste each piece
into your browser's address.

Or, as I indicated, you can just do a Google Group's search of

table thead tbody freeze group:microsoft.public.*
Nov 23 '05 #4
McKirahan wrote:
[...]
A Google Groups search of
"table thead tbody freeze group:microsoft.public.*"
found these:

http://groups.google.com/group/alt.h...2b18ff8fdf9ce4
6/b803b53a6cbebc3a?lnk=st&q=table+thead+tbody+freeze +group%3Amicrosoft.publi
c.*&rnum=1&hl=en#b803b53a6cbebc3a
http://groups.google.com/group/micro...ipt/browse_thr
ead/thread/315150d74f77a5e1/a603205f830c365a?lnk=st&q=table+thead+tbody+free
ze+group%3Amicrosoft.public.*&rnum=2&hl=en#a603205 f830c365a


When posting links, enclose them in <URL: ... > so that news readers
(and maybe some web interfaces too) will treat them as URLs. It should
make copy/paste easier too.

--
Rob
Nov 23 '05 #5
"RobG" <rg***@iinet.net.au> wrote in message
news:rh**************@news.optus.net.au...
McKirahan wrote:
[...]
A Google Groups search of
"table thead tbody freeze group:microsoft.public.*"
found these:

http://groups.google.com/group/alt.h...2b18ff8fdf9ce4 6/b803b53a6cbebc3a?lnk=st&q=table+thead+tbody+freeze +group%3Amicrosoft.publi c.*&rnum=1&hl=en#b803b53a6cbebc3a
http://groups.google.com/group/micro...ipt/browse_thr ead/thread/315150d74f77a5e1/a603205f830c365a?lnk=st&q=table+thead+tbody+free ze+group%3Amicrosoft.public.*&rnum=2&hl=en#a603205 f830c365a


When posting links, enclose them in <URL: ... > so that news readers
(and maybe some web interfaces too) will treat them as URLs. It should
make copy/paste easier too.


Thanks -- I didn't know that. So they should be the following?

<URL:http://groups.google.com/group/alt.h...ead/a2b18ff8fd
f9ce4
6/b803b53a6cbebc3a?lnk=st&q=table+thead+tbody+freeze +group%3Amicrosoft.publi
c.*&rnum=1&hl=en#b803b53a6cbebc3a</URL>
<URL:http://groups.google.com/group/micro....jscript/brows
e_thr
ead/thread/315150d74f77a5e1/a603205f830c365a?lnk=st&q=table+thead+tbody+free
ze+group%3Amicrosoft.public.*&rnum=2&hl=en#a603205 f830c365a</URL>
Nov 23 '05 #6
"McKirahan" <Ne**@McKirahan.com> wrote in message
news:2q********************@comcast.com...

[snip]
When posting links, enclose them in <URL: ... > so that news readers
(and maybe some web interfaces too) will treat them as URLs. It should
make copy/paste easier too.


[snip]

Oops. How about the following?

<URL:http://groups.google.com/group/alt.h...ead/a2b18ff8fd
f9ce46/b803b53a6cbebc3a?lnk=st&q=table+thead+tbody+freeze +group%3Amicrosoft.
public.*&rnum=1&hl=en#b803b53a6cbebc3a>
<URL:http://groups.google.com/group/micro....jscript/brows
e_thread/thread/315150d74f77a5e1/a603205f830c365a?lnk=st&q=table+thead+tbody
+freeze+group%3Amicrosoft.public.*&rnum=2&hl=en#a6 03205f830c365a>
Nov 23 '05 #7
McKirahan wrote:
"McKirahan" <Ne**@McKirahan.com> wrote in message
news:2q********************@comcast.com...

[snip]
When posting links, enclose them in <URL: ... > so that news readers
(and maybe some web interfaces too) will treat them as URLs. It should
make copy/paste easier too.
[snip]

Oops. How about the following?

<URL:http://groups.google.com/group/alt.h...ead/a2b18ff8fd f9ce46/b803b53a6cbebc3a?lnk=st&q=table+thead+tbody+freeze +group%3Amicrosoft. public.*&rnum=1&hl=en#b803b53a6cbebc3a>


We are definitely off-topic, but now that it has started ...

First of all, thanks to Rob for the notification. The support matrix on
<URL:http://schneegans.de/usenet/mid-schreibweisen/> indicates that he is
right. It will take some time, but I think I will get used to including
the `URL:' prefix eventually.

As for your URL format, McKirahan, it is better now, but still broken.
The problem is (as you can see when pressing Ctrl+F3) the automagic
line-break done by your user agent, Outlook Express 5.50.4922.1500 (which
needs [security] patching urgently, BTW[0]) before submit. According to
RFC3986[1], URLs MUST NOT contain newline (any combination of CR and LF),
hence they should not be wrapped at all. I know these ways to work around
that:

a) Get a better user agent. Always recommended to OE users.
Out of personal experience, I can recommend Mozilla Thunderbird[2]
for Windows and KNode[3] for GNU/Linux (where the latter perhaps
can also run on Cygwin/X).

b) Disable automatic line-break. You will have to do all your
line-breaks manually but at least URLs and source code are
not line-broken.

c) Use tools like OE-Tools[4] (no longer maintained) or OE Quotefix[5]
(I have never used the latter so I don't know if it is capable
of the task discussed).

d) Post via a local news server like Morver[6] or Hamster[7] which, with
the support from addition programs like KorrNews[8], can error-correct
your postings before they are submitted to the remote news server.

.... let us end it here and please address further questions or comments
regarding this topic only to the appropriate newsgroup[9] or to me via
private e-mail.
HTH

Followup-To (F'up2) PointedEars
___________
[0] <URL:http://insideoe.com/>),
[1] <URL:http://www.rfc-editor.org/rfc/rfc3986.txt>
[2] <URL:http://www.mozilla.org/products/thunderbird/>
[3] <URL:http://knode.sourceforge.net/>
[4] <URL:http://www.uni-bonn.de/~hoelken/default.html>

<URL:http://translate.google.com/translat...ml&langpair=de
en>
[5] <URL:http://home.in.tum.de/~jain/software/oe-quotefix/>
[6] <URL:http://www.morver.de/english.htm>
[7] <URL:http://www.tglsoft.de/>
[8] <URL:http://www.tglsoft.de/misc/hamtools_en.htm>
[9] <URL:news:microsoft.public.windows.inetexplorer.ie 55.outlookexpress>
Nov 23 '05 #8

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

Similar topics

11
by: Matt Kruse | last post by:
This is a common requirement - "freeze panes" in a table, so that some header rows and some columns on the left are frozen while the body content scrolls. This makes large tables more usable on...
1
by: Dan | last post by:
I have created an Excel worksheet using automation from a VB.NET application. The worksheet is never made visible by the VB program. It is created and filled with data from a database and then...
1
by: Tom | last post by:
Does anyone know of a way to "freeze panes" in a contnuous form? Thanks! Tom
6
by: Chad Crowder | last post by:
Getting the following error on my production server whether the file exists or not: "System.IO.IOException: Cannot create a file when that file already exists." Here's the code generating the...
0
by: Nora | last post by:
Can you do a 'freeze panes' function in the data grid in VB.Net similar to what you can do in Excel? If so, how?
4
by: Roger Withnell | last post by:
I would like to freeze column and row headings on a webpage, simulating freeze panes as in an Excel spreadsheet. Don't seem to be able to do it with Frames. Is there a way with Javascript...
5
by: jasperz01 | last post by:
Hi, Is it possible using Office Automation to freeze panes in Excel from Access VBA code? I've been trying some things but can't get it right... Jasper
1
by: dwasler | last post by:
Try every thing I know to remove this alias I know there been other posting I read each one none seem to work. Thank You DLWasler dwasler@yahoo.com OS Window db2 V 8.2.X
0
by: Luqman | last post by:
How to freeze panes in crystal reports .net with ASP.Net, using Visual Studio 2005 ? Best Regards, Luqman
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: 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
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.