i want to have link on clicking to which I want an excel workbook to be
displayed... basically i think i will need to embed it into the table.
I also want that when i open the predefined excel template i dont get
the main menu (file, edit, view, insert,etc). My template has just 2
columns , data from one column is retrieved from the database and in the
2nd column is the quantity which user will enter and on clicking save i
will save in database.
Ive read a few posts on this topic on the web but nothing specific. Is there a way to embed excel onto an HTML document using asp?
This is my issue:
At our company we have one user that has to access a spreadsheet, and an employee at another company has to access that same spreadsheet. They will never access it at the same time. but when one user accesses the sheet then saves it.
The easiest way I figured to do this - is store the excel document in an SQL database, and embed excel into a webpage so that both users have access to. so they can update the sheet, and save it.
I am populating a schedule using access db, then export that to an excel file using "content-disposition".... I need to add some excel formula while populating the data, how will i do that? any sample??
I'm trying to generate word documents with ASP. I have no problem generating the wrd documents, but none of the images within the document are actually appearing the word file that you download. Does anyone have any insight, tips, pointers into how to go about embedding images in dynamically created word documents? For reference - I'm using the response.contenttype ms/word to create the document on the fly.
I have an asp file that as a URL variable. The variable contains the url to another htm file. How can I embed the htm file within the body of the asp file?
i have a page that dynamically displays payment info for accounts. since each account differs in the number of rows to display, i loop through my recordset and use the following asp embedded html: Code:
I know there is AddEmbeddedImage but does this only work only for images on your hard drive - can it be used for images that are web based? If not is there a way to embed an image in an email on the fly before sending - all web based?
Any idea's on how to make a PDF secure? I don't want anybody to be able to type in the location to the pdf file in the browser and download it. Suggestions please!!!???
I have a document management application written in classic ASP (VBScript) on my company intranet which works fine by storing and displaying scanned images as .tif files.
What I wish to do now to further enhance the application is to display/ embed the DB record ID as text into the image itself. I am aware of a a way of doing this to jpeg images using ASP.NET but this does not work with tif files and classic ASP.
Does anyone know of a component which can achieve this or of a way I can achieve the results with classic ASP.
1) is it possible to convert a "cgi" code into asp page. 2) are there any tools to do this conversion, is it possible to embed the cgi code inside , for example html, or jsp or asp.
I have a code in asp which counts the number of visitors visited the site, how do I call this file to the html page? Is it by using <!include ...> or is there any other way of doing it. I tried using the include method it is not working and also I tried using <script language="JavaScript" src="hitcounter.asp"></script>, that also does'nt work. When they open the index page it should automatically display the visitor's number. Can you please help me with this?
I need to write an ActiveX control, in VB6, that will be embedded in an IE-6 browser. I'm looking for a good tutorial and links to documentation, to make this as painless as possible.
Is there a way to embed an explorer like view of files within a directory and have them be linkable like a tree function in asp. Like This. I want to use as include file too.
Usually, when I send HTML emails, I just SRC the image to my web server, but now I would like to consider embedding images for those instances when potential customers may view the email when offline.
Can this be done with CDO or is another component required?
i have a select case statement that checks for a couple of options e.g.
<%select case aParameters(0) case 0 %>
.. some code
<%case 2 %>
however i would like to test for a certain condition within the select cases statment. To see if a session variable exists before implementing some code:
i have a project i am currently working on, basically what i am doing is i have an excel spreadsheet with 2 fields a number that coordinates with another field which is a url, currently i have to copy paste the url in my browser to get what i want, which is a picture, each url is a picture and picture only, what im trying to do is create an asp web app that i can use that spreadsheet connect using asp and automatically download every url in the spreadsheet to a directory, while also renaming all the pics as the first field.jpg,so basically an asp downloader that downloads contents of url and renames it a certain number
I've an asp page which brings back a query and displays it in a table. The query takes around 30 seconds. Once the page displays they will have an option to send it to excel.
From the examples I've seen they all require the query to be re-ran again in asp (i.e. server side scripting) and as it takes 30 seconds to start with I want to try and take out the repeat of the query. Does anyone know of any way you can do this in asp by passing the already executed table to asp or via any other method?
I want to access the data contained in the MS excel by giving a field value that has to be got from one HTML file including a textbox and one button -SUBMIT to submit the required field value. Finally i want to display the details of that particular field value which is recieved from the first file in HTML. Is it possible ?
I have an ASP file which is opened in MS Excel. I have used the "formatNumber" function to set the number of decimals for variables which are displayed. however Excel cuts off any zeros at the end. e.g 4.650 displays as 4.65
the number of decimals I want to display to varies across the page, e.g. I cant say "display the whole with 3 decimal places" Is there any code I can put in my ASP page to stop Excel truncating zeros at the end?
i have a Print button to allow user to save reservation detail in ms excel. currently, when user clicks Print, a Save menu which allow user to open and save will appear. how can i skip this window? i want my system automatically open ms excel and at the same time open the Print window in ms excel and user also cannot modify any detail in ms excel. is it posible to that?
I'm working on some reports, and have added the ability to "download" the reports to excel. Not a big deal, fairly straight forward. However, PHB wants to be able to create some pivot tables from said reports (again.. no biggie) and when he goes to save the file, Excel wants to save the file as a web page instead of and Excel spreadsheet.
Now.. I know the simple thing here is to just pick Excel from the drop down box in the save as dialog.. but.. PHB would "prefer" to not have to do that.
Has anyone been able to jump this hurdle before? My good friend google hasn't turned anything up. My preference is to give PHB the middle finger.. but alas.. the paycheck is keeping me from doing that.
I have an asp, sql business application. Want to give export option of all reports to excel and pdf. Can I get that code which can embedd in the asp pages to create this function?
I need on-site manager's to be able to view a list of records on our website (which they already can do). They need to be able to select any/all fields and then export these items to an excel spreadsheet. The spreadsheet will have dynamically created columns/rows to append and life is good.
What's the best way to go about this? I've used DTS to do this before, but it's been a long time and I can't remember if there's a way to handle this kind of stuff on a dynamic basis.
I guess my real question is: Is there a way to do this via ASP or should I stick with a more SQL based approach?
Is it possible to copy all info on a page into excel so that it can be sorted?? I know how to get the page to load automatically into excel, using the -: Code:
however I lose some functionality if I do this, i know i could add a button that just re-runs the pages to load the info into excel, however some of the pages may take a while and I want to reduce time and load on the server. So I justed would like to know if it is possible using a script of somesort so that clicking a button will copy the whole page and then paste it into excel??
I need to write an ASP page that will allow users to upload an Excel file, the contents of which should then be imported into an SQL database. Problem I am facing is how to do this efficiently. So far I have a page that will accept an upload, then display the data from the Excel file, my first thought was to loop each row, then run an update/insert based on the data found...Obviously this is not going to be very efficient, I'd exepect time outs often Has anyone got any ideas to get round this?
I can connect to an Excel worksheet and get records with no problem, if I know the worksheet's name. However, when my users upload their excel files, I don't know what the active sheet they want to work from is called.
I have two options - either force them all to give the saem name to every worksheet they upload, or providing them with an input field where they can provide the name of the relevant worksheet
Rather than force my users to name all their worksheets "sheet1", is there a way I can use ASP to find out the names of the worksheets in a workbook?
You know how you can connect an ASP page to a SQL server to retrieve data from a database/table and display it. Well what I want to do is connect my ASP page to an Excel spreadsheet and retrive the data and display the info on my ASP page. How do i go about doing this?