Set Certain Column Inside That Excel File To Become A Freeze Panel
i have got the code that read the data in the Database and display inside a Excel file, but how can i use ASP code to set certain column inside that Excel file to become a freeze panel?
View Replies
ADVERTISEMENT
we have a requirement to freeze the column and row column heading... so that when the user scrolls to the right the first two columns ( I refer them as "row headings") will stay and the remaining columns scroll left and when the user scrolls to the bottom the first row stays ("column headings")and the remaining rows will scroll up.. This can be easily accomplished in EXCEL by freezing the itersecting cell... How can the same be accomplished using HTML tables /ASP code.... Is there any Active X control available that can be used to accomplish the same?Our technical env is ASP and Oracle DB
View Replies
View Related
i am unable to figure out some way....so pls if anyone has implemented then do suggest me. i need to have a link on clickign to which i want excel workbook to open (a previously created template) below the link in the form.
how can i do it. i find lot of info on opening excel as an application freshly. i want to
open in the form itself. is it feasible or i am just wasting my time searching info for it.
View Replies
View Related
What ASP code can I use, for an ASP-generated spreadsheet, to force a cell to wrap if the content is longer than the width I have specified for that cell?
View Replies
View Related
I'm trying to run the server.execute command inside a executed file. It doesn't work. Can anybody tell me why? I've searched all around and haven't found a reason. Could it be because it's not supose to work, or is the syntax diferent then in the first file?
It's something like this:
File 1
...
<%Server.Execute("File2.asp")%>
...
File 2
...
<%Server.Execute("file3.asp")%>
...
File 3
<HTML>
<body>
Hello!
</body>
</HTML>
Is this possible?
View Replies
View Related
This is what I need to do:
A client uploads a document (a msword .doc file) to the server, I need to search a string that document and find specific words in it (this is an Application to a School, most of them look the same, so all you can do is replace the school name in the application, but sometimes people forget to do so and get rejected for sending inappropriate application).
So I need to find in each Application possible names of other schools and alert about it.
I'm writing in ASP (I can use ASP.net as well). I DON'T HAVE ACCESS TO THE SERVER (it belongs to the hosting company, and there's no way of installing anything there).
View Replies
View Related
I have a asp web page with a link point to a file which depend on the database information. Sometime is a picture file sometime a word and some time is a PDF file.
For picture file, when user click the link, it will open the picture inside the IE browser. Now here is my problem:
On some of the computers, for PDF file only, it opens outside of the IE browser. Like the Acrobat program is not in the browser. With the same code, some computer works good. But I want to force it open inside the browser. why and how to fix it?
View Replies
View Related
There is what i would like to do, I have a page that pulls all the
hours for our staff over a given period calculated them and reports
back on 15 different colums and is aproximatly 500 individual rows of
data for a table. Now as you could imagine that is a night mare to look
at for anyone, i have done a few things to make remeber which columns
are which however a simple Solution would be to the top row, or rows i
define stay constantly at the top as your scroll down.
This is classic ASP and not ASP.NET, I can find alot of resources for
ASP.NET but nothing for ASP.
I have considered Frames, but who really wants to mess around with that
ad there are alot of controls at the top of the page that manipulate
the data.
Also i have heard of using JavaScript or CSS, Has anyone achieved this
before?
View Replies
View Related
Is there a way to create tabs in the middle of a page using asp or do I have to use Java? If I have to use Java and tab content does anyone have a sample of the coding? Do I need to install the Java development kit? Can I use Jave in an asp page?
View Replies
View Related
I have put serveral panel controls within a page, each of them matching to a action defined by buttons, so I want to fix all panels in one place( they already have same size, but different left, top values), how can I do it (in code, if I do it in desgn, is there a way to put the panels in different "layers" so the contained controls will not interupt with each other)?
View Replies
View Related
anyone know where can i get good iis admin control panel for monitoring multiple sites?
View Replies
View Related
Does anyone know if there is some kind of management tool fo MS-Access databases that works online? Similar to the Microsoft SQL server console.
It would make it much easier for me if I could manage a database online instead of downloading the latest version, tweaking it (as quick as possible so new data is not overwritten) and then upload it.
View Replies
View Related
I have to come up with an admin cntrol panel so the staff can change ,update there website as needed. I would like to use asp to create the admin panelor if you guys can tell me of a better way like using php or somthing.
How would I go about letting them update/change the text. Do I have the site load it
from a database like access or sql or ? Remeber it should be user freidly no html coding just type and upload.
View Replies
View Related
I've made an access script user based for a forum, so, I'm not sure what to store in the cookie. I think to store just the user_id (the one in the users table referred to the logged user) but is this way sure ? is anyway to hack it simple ? I know that nothing is 100% secured, but not too simple to hack.
Have I to store other informations like session id or something other ?
Another question is for the login form... Somebody checks if the session.id of the user is the same between the page containing the login form and the page that checks informations... but is this really useful ? infact is an user stops on the first page (the one where is the login form too) reading something until the session goes to timeout then the check session fails...
View Replies
View Related
It works if the file in on the server side, how to use the component (DSOleFile) with the file on the client side? Also how can I calculate the width of the file. (Page set up - Landscape or porrait). Code:
View Replies
View Related
i try to freeze the head row of the html table (like in excel) scrol only the rest of the table! how to do it?
View Replies
View Related
I want to Convert Excel Files to CSV files using ASP code CanAny body help me out in this.
View Replies
View Related
The title looks a bit odd, but it is what I really need
I have different users, which I get the information from them in an ASP page, the data is stored in a SQL database, one of these users is authorized to check and close the data entry.
Once the data entry is closed, an ‘Excel’ file should be generated according the entered data and be placed in a directory for use of other users.
My problem is how I can generate the mentioned ‘Excel’ file by clicking a button in an ASP page and transfer the recorded data in it.
View Replies
View Related
I have to add a feature, on click of button file open as dialog box will open and user can attach a excel file. Then we can able to validate, actually file attached or not, it is excel file or not etc.. if everything is ok app will will do further processing on the file.. Can anybody suggest me the easy way out without licencing issues.. Since vbscript and jscript is used any fee tool available...I tried to do it through MSComDlg.CommonDialog but it is a licenced version. Also I tried to do it through <input type=file>
but here one text box and browse button gets added..
View Replies
View Related
I am trying to create an excel file consisting of data from a SQL database using asp. I dont want the file to open up in the browser. I want the file to be opened in Microsoft excel. I have seen similar questions out here but no answers.
View Replies
View Related
One of the pages of my application opens an Excel 2000 workbook in a
new window using Javascript. The workbook is read only and I use a
window.open command to open the workbook. On the workbook's
BeforeClose event I have a code to avoid the 'Save' dialog: Me.Saved =
True
If I open the page locally, change some content and close the
workbook, the 'Save' dialog does not appear, as expected. As soon as I
open the workbook on the web, the 'Save' dialog still appears when I
close the window. I need to allow my users to change the contents of
the workbook but they cannot save the workbook. Is my approach wrong?
How can I avoid the 'Save' dialog?
View Replies
View Related
Can anyone help with this? Here is the code I am using. The problem
is, where it checks if a file exists, it always goes to else. Even if
the file is there, it won't open the file, goes straight to else part
of statement.
<%
If Session("strLogID") = "" Then
Response.Redirect("http://website/pages/login.asp")
Else
strfile = Request.Form("month") & Request.Form("day") & " Misses" &
".xls"
Set fs = Server.CreateObject("Scripting.FileSystemObject")
If fs.FileExists("http://website/webreports/Misses/" & strfile) THEN
Response.Redirect("http://website/webreports/Misses/" & strfile)
Else
Response.Redirect("http://website/pages/missedreport.asp")
End If
End If
%>
View Replies
View Related
I am creating a webpage and have a form where a visitor will choose a
day, month, and year. I want to pass the data from the form into an
asp page which will process it and put it into a string and open the
excel file requested. The excel file to open will depend on the day,
month, and year chosen in the form.
View Replies
View Related
I have a asp page which will get the data from multiple tables (with
functions and procedures)and display data in HTML tables <TABLE> on ASP
page.Is there any way we can create a excel file from the output of this ASP
file.I know how to export if this information on ASP page is coming from single
query from a database table.
View Replies
View Related
Is there a way to insure the user can't save the excel file that has been opened?
I have a link that goes to XLS files for users but I don't want to users to be able to save the XLS files to there local drive.
View Replies
View Related
I need to give users the option to enter a zip-code in a html form, and then search through an excel-file for that zip-code. If any entries are found, then I have to output these as html.
How should i start? And what if several users tries to search the excel-file at once?
Basically I need to search the excel-file as I would search a db.
I've done a few searches on google, but haven't really found any relevant info.
View Replies
View Related
How to import a text file into Excel file using macro? Can this process run on the form menu button? I have attached a text file for your reference.
Please give me some ideas of doing it
View Replies
View Related
I' m trying to import an Excel file in a SQLServer db. If I specify the spreadsheet name it works correctly. Now I'd like to import the spreadsheet without specify its name. Is there a way to retrieve the spreadsheet names of my Excel file in ASP?
View Replies
View Related
After a user make the search, it returns 100 rows of record on the display page. I want to give an option for the user to save the records as Excel spreadsheet. Like a small icon on the corner, it prompts to save if click.Can anyone teach me how to do it? or have a simple tutorial or code that i can see?
View Replies
View Related
I'm trying to create a excel file from set of data. actually I'm using ASP + JScript.
I'm glad to hear your oppinion.
View Replies
View Related
With response.contenttype = "application/vnd.ms-excel", I can easily export my data to Excel which is embeded and shown within a browser. If I'm going to save the Excel file through ASP programming, which method can I use? I need to save the data to Excel file with dynamic name (the file name should contain key values and appended with system datetime).
View Replies
View Related
I have a SQL query to generate the report for me in SQL Query Analyzer. I would like to create an ASP page that has a link, and when people click on that link, it will prompt a download message (open or save) in Excel format. Is there any codes can do this?
View Replies
View Related
I need to write a program that can create an excel file and copy all the data obtains from a database to the excel file. Then save and close the excel file or do all of the above in the backgroud. if you have written similar program or know where I can find the sample code for this feature.
View Replies
View Related