Spreadsheet, Hyperlink
I am writing an ASP page that uses the Spreadsheet Office 200o Web Component. I need a cell to open up a popup window when clicked. I can only get a new page to display using hyperlink. I want this to be a popup page like the one you can create using window.open().
Can this be done? Can I do this using some window/Spreadsheet events, can a SpreadSheet cell contain a call to a javascript method? I would like one of the columns to contain not only a hyperlink but also be displayed as an image of type *.gif. Is this doable?
View Replies
ADVERTISEMENT
<% Response.contenttype = "application/vnd.ms-excel" %>
<% Response.AddHeader "Content-Disposition", "filename=hardware.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?
View Replies
View Related
i am having a problemn thinking on a solution to make a web application.
This is the scenario: I have to make an application that should catch some
user data on the screen and pass it to a database. Here is the problemn: the
data that the user will pass is huge. I am talking about some columns and 27
rows.
3 rows as caption rows and the other 24 to get the data. How can i do
that? I thought about making columns with textboxes (with ids like R1C1,
R2C2, R1C4...) in a dynamic table inside a form and submit it.
But the boss
wants an excel spreadsheet look into it. I am relutant about using OWC
because first, i don't know if the users will have the office installed and
secondly because if they do have office installed, how can i know what
version of office is everybody using? Code:
View Replies
View Related
I have created an asp page that resemebles that of a spreadsheet. It contains mostly javascript functions. The page functions ok except when there are a significant amount of row entered. Then there is a delay tabbing from cell to cell -- but only cells that have function(s) associated with it. Is there something that I can do to speed this up?
View Replies
View Related
I'm creating a spreadsheet online via ASP. I have the following at the page
top...
<% Response.contenttype = "application/vnd.ms-excel" %>
<% Response.AddHeader "Content-Disposition", "filename=FullList.xls" %>
It works fine for some 60+ manufacturer listings. However, it balks on one
single manufacturer. By chance, this manuf has 18,000+ records. The others,
less than 10,000. Is there a limit to the number of records I can convert to
XLS...?
View Replies
View Related
I have my excel spreadsheet generating just fine. What I'm trying to do is format each cell to something other than "general" I've figure out how to format to currency:
<td>$<%=variable%></td>
I really need to format to "text" though. Anyone have a good link to a chart that explains how to format to all of the different possibilites, or just how to format to text?
View Replies
View Related
I'm successfully using Response.ContentType = "application/vnd.ms-excel" to generate an Excel spreadsheet from an asp page and a SQL Server database.One of the columns contains data that is a long number (13 characters eg. 1122334444566).The spreadsheet does not display the number correctly because the column is formatted as 'General' so it displays 1.12233E+12.To correct this in Excel I simply change the column type to number. How do I get around this in asp.
I know I could use fso to create the spreadsheet on the server using a template, but I prefer to do it on the client side so that I don't accumulate a whole lot of xls files on the server.
View Replies
View Related
I didnt build the worksheet yet because I was stuck at the line Set oSS = CreateObject("OWC10.Spreadsheet")
I get this error
Error Type:
(0x8002801D)
Library not registered.
/gcrm/DailyRCReport/genExcelOWC10.asp, line 18 .
View Replies
View Related
What is the syntax to connect to an excel spreadsheet as well displaying contents of a column.
View Replies
View Related
I have created a Spreadsheet object that I need to stream directly to a file through the browser. I can not save this file, that I would then stream, to the web server, even though this would save me a lot of aggravation.
Since Microsoft seems to see no value in providing any documentation for their OWC 11 components, I am just one of many developers groping around trying to find how to use this.
View Replies
View Related
I have a report that the user can view either on a page with HTML or they can open it in Excel.
I am attempting to change the content type with this statement:
response.contentType = "application/vnd.ms-excel"
But it appears that when I do this I lose all my request variables and my recordset is null.
View Replies
View Related
I am creating a website in which users will be able to query an sql database by several different criteria (i.e.- name, department,supplier, part#, date). What will return to the user will be a webpage with the column headings that they selected in their search criteria (i.e.- name, supplier, part#) and below those column headings, a list of the results.
I want the user to be able to print this report or export it to an excel file, this is the part that is tripping me up.Any ideas about this? Am I going about it all wrong?
View Replies
View Related
How to using asp script update data in Excel Spreadsheet with style (ie, Bold, Font Size ..) ? Is it possible to do that ?
View Replies
View Related
I'm using the Excel application object to create a
spreadsheet from a recordset. Everything seems to work
fine except any date fields are not displaying properly.
For example 4/18/2004 is displaying as 38095 in the
spreadsheet.
I loop through the recordset to display each row. The
line that actually writes out the field is:
objSpreadsheet.Cells(iRow, iCol).Value = objField.Value
Any suggestions?
View Replies
View Related
I am just wondering if this is possible to do?
View Replies
View Related
I am trying to import an excel spread sheet, my first step is to be able to see the spreadsheet on the webpage, Code:
View Replies
View Related
I am semi-new to ASP. I'm in the process of making several reports and I wanted to condense one of our reports to fit nicely on a web page. This report consists of about 5 different queries.
I want to make a table like the one below in ASP. I thought I would just make a table and go from there but I quickly realized I can't.
View Replies
View Related
What would be involved with having an Excel spreadsheet displayed in an ASP page? The additional problem is that the file name changes on a monthly basis. For example, this month's file name is 'Feb 2005.xls'.
View Replies
View Related
I would like to know if and how it would be possible to create an
entry-screen that allows the user to enter data in a database, using a
spreadsheet/table-like entry screen. The screen would start of having
headers for each column/field and an empty row underneath. When each column
in the row is filled in, the user must have an option to add another row.
I'm look for the code/explanation that helps me set up the entry screen, and
the ASP code to add the entered data in the database.
I can imagine that each entered row is added to the table when a new row is
added, or a button is pressed and then the screen refreshes with the newly
entered information and a new row...
View Replies
View Related
I have asp project where large volume of data entry would be done. I am
trying to find out if there is any tool that can allow me to build asp
application where the forms would be like excel spreadsheet.
View Replies
View Related
I'm exporting tables to Excel, but they seem to format with an extra row between every record. The table is output in HTML on one line, so it doesn't seem to be a white space problem.
View Replies
View Related
How to using one excel template to insert data into another excel spreadsheet by using asp programming ?
View Replies
View Related
I've been reading through all related Excel posts now for about an hour as well as Googling for my answer and I'm getting even more cornfuzed as I go. I have an Existing Excel Spreadsheet, I need to populate certain fields of the form with values from a Database.
I have no problems connecting to my database and pulling up the data, but I have no idea where to begin with opening my existing spreadsheet, then telling it which worksheet to use and then how to populate the fields I need.
I'm not looking for an entire code handout, this is just something that I haven't attempted before in ASP. If someone could just give a quick example of first opening the existing spreadsheet, selecting the correct worksheet and populating 1 field, I think I can figure everything else out from there.
View Replies
View Related
I have a database lookup engine in asp that I would like to add the function of being able to click a link on the page and get the same results that are displayed fed up as an excell spreadsheet.
I've heard that asp can do this. Does anyone here know how?
View Replies
View Related
I want 2 create a survey Web Form that people can fill in. I then want the data entered to be saved to an Excel spreadsheet located on a server.
Can .ASP handle this kind of task? and if so does anyone know the code required to perform this function?
The data entered will be RAW and the .ASP (or whatever required programming) will need 2 process and convert the data into the spreadsheet.
Also, would it be possible to run this from a stand alone machine so that the web form, .ASP and spreadsheet are all contained on the machine and have no outside influences?
View Replies
View Related
I've inherited this asp page. It builds an Excel spreadsheet, but it's not putting the date in the spreadsheet and I don't know why. here is the code (see bold-red line): ...
View Replies
View Related
I have a 2000 server running IIS 5. I need to send approximately 10000 emails to recipients from an excel spreadsheet with a small word document. These are requested emails, no spamming. I don't have a clue as to where/how to start this.
View Replies
View Related
I've never understood how this works so hopefully someone can shed some light on this. If I wanted to create a hyperlink that would initiate a pop up "Save As" box, would I use JS? And secondly, doesnt anyone have any idea how this would be done. I didnt have any luck finding the answer to this when I googled it. I found one example of how someone was trying a similar technique but wasn't quite the same. The reason for this is Im making a simple webpage so some elderly people that arent computer savy can download some WMA and WAV files from my server. I dont want to explain they have to right click on the link.
View Replies
View Related
I have an Access 2003 database with 1 table that has 2 fields - Date and Description. Both are plain text. This is the basis for a basic calendar displayed as a table using ASP. So far as plain text it works perfectly.
Now I want to generate bolding and hyperlinks on the text in the Description field. Not all fields contain text in the same format, and not all need bold or hyperlinks.
Example: One record will be "Meeting at the Boarding Barn at 1:00" where I want "Boarding Barn" to be a hyperlink. Next record will be "Competition in Milwaukee" where "Competiton" should be bolded, and "Milwaukee" will be the hyperlink. Third record will be "Annual Picnic" and will not have any bold or hyperlink.
I put the HTML tags in the text in the database, but they are ignored. What is the right way to do this?
View Replies
View Related
Rather than doing this:
<A HREF="editpatient.asp?ID=1>View</A>
Can i do something like this instead? - and make it work
<A href="EDITPATIENT.asp?ID=" & LISTBOXPATIENT & ">View</A>
where LISTBOXPATIENT refers to a database populated listbox
The idea being that when the user is completing a form they can look up additional data on a patient by clicking the hyperlink next to the listbox.
View Replies
View Related
How do I write a hyperlink on an asp page to a word doc
not in the web root?If I have a page in my test directory of the web root and
my files are sitting on my e drive?
View Replies
View Related
I built an ASP Form and I'm using CDONTS to e-mail the results to me.
After the user clicks on the "Submit Form" I use ASP to send a ConfirmMsg
back to the user.
At the same time I would like to send back a Hyperlink .
The Hyperlink will take the user back to some other part of the site, For
Exampe I want to send a hyperlin to
http://www.mydomain.com/index.html
I want the link to appear after the Server processes the ASP Form.
Can anyone help me with the ASP code fot a hyperlink.
View Replies
View Related
I make a recordset as hyperlink with the new page, it work fine but my question is. is any way to make that hyperlink inactive when is no data or NULL in the field? Code:
View Replies
View Related
