473,696 Members | 2,045 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2945
"srinivas" <ni********@gma il.com> wrote in message
news:11******** ************@g1 4g2000cwa.googl egroups.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/b803b53a6cbebc3 a?lnk=st&q=tabl e+thead+tbody+f reeze+group%3Am icrosoft.publi
c.*&rnum=1&hl=e n#b803b53a6cbeb c3a
http://groups.google.com/group/micro...ipt/browse_thr
ead/thread/315150d74f77a5e 1/a603205f830c365 a?lnk=st&q=tabl e+thead+tbody+f ree
ze+group%3Amicr osoft.public.*& rnum=2&hl=en#a6 03205f830c365a
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********@gma il.com> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.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/b803b53a6cbebc3 a?lnk=st&q=tabl e+thead+tbody+f reeze+group%3Am icrosoft.publi
c.*&rnum=1&hl=e n#b803b53a6cbeb c3a
http://groups.google.com/group/micro...ipt/browse_thr
ead/thread/315150d74f77a5e 1/a603205f830c365 a?lnk=st&q=tabl e+thead+tbody+f ree
ze+group%3Amicr osoft.public.*& rnum=2&hl=en#a6 03205f830c365a


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.ne t.au> wrote in message
news:rh******** ******@news.opt us.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/b803b53a6cbebc3 a?lnk=st&q=tabl e+thead+tbody+f reeze+group%3Am icrosoft.publi c.*&rnum=1&hl=e n#b803b53a6cbeb c3a
http://groups.google.com/group/micro...ipt/browse_thr ead/thread/315150d74f77a5e 1/a603205f830c365 a?lnk=st&q=tabl e+thead+tbody+f ree ze+group%3Amicr osoft.public.*& rnum=2&hl=en#a6 03205f830c365a


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/b803b53a6cbebc3 a?lnk=st&q=tabl e+thead+tbody+f reeze+group%3Am icrosoft.publi
c.*&rnum=1&hl=e n#b803b53a6cbeb c3a</URL>
<URL:http://groups.google.com/group/micro....jscript/brows
e_thr
ead/thread/315150d74f77a5e 1/a603205f830c365 a?lnk=st&q=tabl e+thead+tbody+f ree
ze+group%3Amicr osoft.public.*& rnum=2&hl=en#a6 03205f830c365a</URL>
Nov 23 '05 #6
"McKirahan" <Ne**@McKirahan .com> wrote in message
news:2q******** ************@co mcast.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/b803b53a6cbebc3 a?lnk=st&q=tabl e+thead+tbody+f reeze+group%3Am icrosoft.
public.*&rnum=1 &hl=en#b803b53a 6cbebc3a>
<URL:http://groups.google.com/group/micro....jscript/brows
e_thread/thread/315150d74f77a5e 1/a603205f830c365 a?lnk=st&q=tabl e+thead+tbody
+freeze+group%3 Amicrosoft.publ ic.*&rnum=2&hl= en#a603205f830c 365a>
Nov 23 '05 #7
McKirahan wrote:
"McKirahan" <Ne**@McKirahan .com> wrote in message
news:2q******** ************@co mcast.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/b803b53a6cbebc3 a?lnk=st&q=tabl e+thead+tbody+f reeze+group%3Am icrosoft. public.*&rnum=1 &hl=en#b803b53a 6cbebc3a>


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.sourcefor ge.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:micro soft.public.win dows.inetexplor er.ie55.outlook express>
Nov 23 '05 #8

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

Similar topics

11
24074
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 screen. There are a number of solutions available. For example, http://www.litotes.demon.co.uk/example_scripts/tableScroll.html I'm just wondering if anyone knows of a "latest and greatest" script to solve this problem. My requirement at the...
1
9582
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 some formatting is applied and the worksheet is saved. I need to know how to freeze panes in my VB program before the worksheet is saved so when the saved worksheet is opened, the column headings in the third row are not scrolled out of view when...
1
3819
by: Tom | last post by:
Does anyone know of a way to "freeze panes" in a contnuous form? Thanks! Tom
6
13721
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 error (seems to be happening when I try creating a directory) If dirmgr.Exists("s:\blah\" & txt_name.Text) Then lblerror.Text = lblerror.Text & "Unable to build physical path. " &
0
1135
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
13847
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 and/or CSS and or Frames? Thanks in anticipation.
5
15454
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
9957
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
1344
by: Luqman | last post by:
How to freeze panes in crystal reports .net with ASP.Net, using Visual Studio 2005 ? Best Regards, Luqman
0
8661
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9142
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9008
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8875
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8849
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7699
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5855
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4608
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3030
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.