This is a simple report that is supposed to render as an Excel document, for some reason it's not anymore, not sure why, I think it's related to permissions, we recently added a domain user as the anonymous user for the site, everyone has permissions to the virtual directory where the asp page is executed... Code:
View Repliesi have a field which contains html code, which is then rendered as a layout for several templates.the user can change the template if they so wish. the layout html is currently stored as a varchar 8000 - but 8000 characters is not enough for detailed layouts.
i dont know where to begin on this problem, does anybody have any useful links. i would search in more detail but i dont know the procedure is called for what i am doing
what i need to do, is have the asp refer to a html/text file and render the html directly from that file? Is this possible? or is there any other such ways to do the same thing.
I have a database-driven site which I'd like to render down to HTML. Can anyone recommend a good (preferably free) tool to do this?
View Replies View RelatedI want to include files, a header and a footer to my asp page. The files i want to include its on another server, i can reach it with a www-url. Can i use the www-url to include the file to asp page?
View Replies View Relatedhow to output a pdf file using asp. I know it can be done.
View Replies View RelatedI have a report created in ASP (not ASP.NET) that uses Response.ContentType="application/vnd.ms-excel" to display the results of a query from SQL Server 2003 formatted as an html table using Excel in Internet Explorer (version 6.0.2800).
The report displayed fine when my PC had Excel 97 installed. My PC was recently upgraded to Office 2003 and now the report only displays the report header. Does anyone know of a change I can make to the ASP code to display the rest of the report in Excel 2003?
I developed some code to export DataGrid to excel base on the html stream technology.
But that one works only with worksheet cell. Is there any way to output Excel Chart based on the html stream?
how do i link an asp page to a pdf document and render it (the pdf document)in a web browser without it downloading to the client computer viewing it?
i have tried the response.contenttype="application/pdf"
now the main problem is how to embed the pdf doc in that asp page!
Is this possible? I am planning to export data from SQL that generates HTML
table. Instead of selecting the table and then copy then paste to excel, is
ther a script(JS or VB) that will automatically export or open the Query to
it.
We have a excel document, which is been updated regularly. After everyday
updating, we export as HTML file and upload it.
As a ASP programmer, I want to write a script, which can parse this excel
file and make it as a web ready file.
Is there any simple way to do this?
Our data entry operator, is very new to computers and all he know is a
little in Excel.
I am displaying the data into HTML table into a EXcel file using the REsponse.header and content type, The data retrieved from the database is sucessfully displayed and I am able to open Excel application and save it. But in One of my TD tag I have a image <IMG> tag which should disply the image, but in the excel application the image is not loaded, If I open the table in web browser the image is visible.
Also if I select the save open form the file download box, there is a blank browser window still open, I open this file with window.open functionality. Can somebody suggest how to close the blank window when the excel file is saved on the client PC instead of opening.
I an using ASP to read a database table and generate an HTML table
which is save via FSO with a file extension of .xls which opens up
in MS-Excel. I am inserting several lines of text into a cell and would
like to force a line break between them.
I recorded an MS-Excel macro so see how Alt-Enter was captured
which turned out to be Chr(10) which is the same as vbLf (right?)
I tried inserting that in character in the text but it didn't show up as
a line break in MS-Excel.
i am using the following code to generate a xls file using the content type now when the user opnes the file at his pc it takes long time to open..if the no of records in file is large does the use of html tags has slow down the process of opening in excel. Code:
View Replies View RelatedWe face problems uploading excel (with macros) documents using HTML
File Upload.
The file contents are corrupted while viewing the same. However, we
are able to upload excel (w/o. macros) documents successfully. Is
there anything we have to take care of, while handling uploads of
excel documents with macros?
I have a table having 3 columns. There is a checkbox for each line. I
need to get those lines whose checkboxes are checked, and show those
lines to another webpage. Is there any way to do that? My concern is
that all information in the table are in <tb></tb> pairs without any
name tag. Any idea?
I'm doing a content management system, whereby the user can enter the HTML code for a currency symbol, eg £ for £.y . when I bring this data backup, say they want to edit the settings, then my ASP/HTML page is rendering the HTML code, eg £, rather than showing the original value, eg £.
If for example I put a space between the '&' and the 'pound;', eg & pound; then this will cause me problems because the user will think that they have to a put a space in or they file it with the space, which means the HTML code won't work any more. Is there a way round this?
i need to include the html inside another html, though it might appear simple, the catch is this, my one html is in one server and my another html is in another server.I cannot read the html and stream it as it has images and their path gets changed when i do that.
More over i donot have any control over the html which i am going to include all i have is a url http:abcxx.htm whose content i want to show in another asp page. The technology is ASP (vbscript and javascript).
I want to give Excel facility into the the Browser for the user and after that I need to insert all the Excel data into the SQL Database table.
View Replies View Relatedi 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
View Replies View RelatedI'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 ?
View Replies View RelatedI 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?
View Replies View RelatedI'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.
is there somewhere a file that holds constants for Excel Automation
ActiveX objects, such as adovbs.inc for ADO constants?
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:
<%
response.contentType = "application/vnd.ms-excel"
%>
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 try to use asp to extract excel data. if the item field in excel is empty,
can I use "" to represent empty ?
will this (" ") work ?
rs("Item") = ""
rs.open "SELECT * FROM [Sheet1$]", oConn
do until rs.EOF
if rs("Item") = "" then
emptyfield = true
else
emptyfield = FALSE
end if
rs.movenext
Loop
Is it possible for me to send the output of an ASP file to an Excel Sheet
View Replies View RelatedI 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?
View Replies View Related