Dealing With Xls (excel) Files
Can .xls (excel) files be opened and manipulated using ASP?
View Replies
ADVERTISEMENT
Excel Files With ASP
I have a problem when reading a excel file, the excel file has a list of users, some of the names are just numbers and others are text mixed with numbers, when i read the file it only reads the users with only the numbers or the users with text and numbers (depending on the first record if the first record is numers then it reads numbers y it was text mixed then reads text mixed)
View Replies View RelatedCVS Or Excel Files
i have been searching Microsoft to find this information and the only thing I can find is for SQL, I need to import these type of files into an Access database via ASP.
1. Can this be done
2. Where can i find information to do this
3. does someone want to make a few bucks and do it for me?
Asp To Excel Include Files
I need to convert asp to excel. I figured out how to do this but the problem is I use include files for my database connections.
If I leave the files the page will query but will not fire excel. When I declare the functions on the page it works fine. Is there a way that I can use my include files?
Read Excel Files
i was wondering if it is possible to read an excel file from the client side and for example, print the cells info in a <table> using ASP of course
I have one that makes this but, i have to indicate the fisical location of the file (C:inetpubwwwrootexcelfileexmpl.xls), wich means, my machine.
Accessing Excel XLS Files
how can i access XLS file instead of using a database? I have a single XLS file with several sheets-which in this case represent tables. How can access them, create recordset, display them etc.
View Replies View RelatedDealing With MP3's
I would like to be able to control the downloading of (my own)music files from my music site other than letting the user right click and "Save target As" on a hyperlink.
"Save Target As" must issue a command of some sort to the server. I would like to be able to issue that command myself under program control.
Dealing With Checkbox
I want to design a page which has lots of criteria on which I want to be selected by using checkbox's. I then want to pass only the criteria that have been checked and store them in an Access DB, and leave the items that have not been ticked alone.
Anybody any ideas?
Dealing With 2 Db Tables
i got 2 tables...on the table "times" i only null the records column "dtime" (if it is not null) and save this records column "username"... straight after that i need to select on the second table "useringo" the record with the same username that its time was nulled and to null its column "msginfo"
i realy need your suggestion to how to do this...i do not want to run on all this tables every time...i want it be most minimal and smart.
Dealing With Friendly Urls
My application runs on ASP and the business logic is embedded in Dlls written in VB. The application hosts a list of articles for the user to view and these are accessible through some complex urls like "http://mysite/articles/category1?articleid=34512". I would like to denote a friendly url to these articles such as "http://mysite/articles/kb_TaxPlanning.asp". I am thinking of using an ISAPI filter to do the work for me. My friend was trying on using a httphandler, but it did not work. Please share with us the resources for creating an isapi filter for the same. Also how to use the same for the expected result?
View Replies View RelatedDealing With Too Many Database Connections
I have a database class that I've been starting to use with my ASP apps and I was wondering about having too many database connections on one page. I'm beginning to write other classes that use the database class to reach into a table and pull data out.
Say for instance I have these classes:
Database
Users
News
Reviews
All of these classes have a method like getUserByID() or getNewsByID() but they are all using a private database object from the Database class.
Are they all using the same connection behind the scenes (underneath ASP) or are they all actually using separate connections? And if in fact they are using different connections then is there a common design patterns that alleviates the pressure by passing around the same DB object?
It makes me a bit uncomfortable to know that every class is creating a new Database object and a new connection on top of that; however, if you were pulling data from a MS SQL database for the users and an Access (ugh) database for the Reviews this would be necessary.
How To Open Large HTML FILES IN EXCEL In Quick Time
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 RelatedFormatting Percent And Dealing With Division By Zero Problems
I have some values that I want to display as percent, such as the
retail price/wholesale price. In some instances, the wholesale price
is zero, so I get a division by zero error.
What can I do to avoid this?
Also, how can I get this to only show two decimals, instead of it
going .##### the way it does. I want it to look like .45%
Recordset Dealing With Unlimited Text Field
I'm trying to query a set of data from MSSql which contains field type "text" for unlimited length of characters.
I make a query and store the data into a recordset. However, soon as the page try to access the unlimited field, it seems as if the recordset looses all the data it was holding.
Does anyone know how to get around this problem? or what's causing this? I dont even get an error msg. It just doesn't show anything as if there was nothing there.
Displaying Image From Database Saves Files To Temporary Internet Files
I have a website that we display images we have saved into a SQL Server 2000 database as binary BLOB. This is on a Windows 2003 Server. Just recently (a week ago) this website began to save the images it is displaying on the website as ASP pages in the Temporary Internet Files > IE.Content > Folder.
We have other websites where we use the exact same code and these do not save files on the server when they are displayed.
Here is the code to display the image:
Set rs = objConn.Execute( SQL )
Response.ContentType = "application/octet-stream"
Response.BinaryWrite rs("Product_Image")
SQL is the SQL String to get the image from database
When I add this code:
Response.ContentType = "image/jpeg"
The images still display on the website, but now are saved in the Temporary Internet Files folder as JPG's.
Can Php Files Execute Inside Asp Files?
Can a php file be executed inside an asp file? I need to execute a php file in another asp file but i'm not so sure it's possible.
My server can run both asp and php and they run without any problems... I just need to find a way to include the execution results of the php file in the asp one.
Is it possible to use SSI and include the executed php file and then the executed asp file in a main ssi file?
Convert ASP Files To Executable Files
I have installed PWS in windows 98 in each of the system at various places and put my Sales program files in the WWWROOT directory in all the branches. I'm afraid that the users may tamper my ASP files. Is there any way of converting .ASP files to .exe files so that the dont see my program.
View Replies View RelatedHow To Use ASP But Produce HTM Files, Not ASP Files?
I was wondering how some sites let you search by using a form, then present the results as static .htm files.
The reason I ask is that I tend to use ASP to process form information, then give the user a list of results presented on an .asp page. The list is simply drawn from a database in real-time and formatted into a template page.
The problem with this is that search engines can't see any of the information in the database, since they can't do the form submission. Is there a way around this?
ASP Excel
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 RelatedAsp Excel
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
View Replies View RelatedAsp & Excel
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?
How I Can Get Value From Ms Excel
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 RelatedASP IN EXCEL
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?
Ms Excel
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 RelatedASP -> Excel
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.
Excel.inc?
is there somewhere a file that holds constants for Excel Automation
ActiveX objects, such as adovbs.inc for ADO constants?
Asp To Excel And Pdf.
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?
Excel/SQL
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?
Vnd.ms-excel
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??
Excel Fi
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?
Asp Excel
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
ASP - Excel
Is it possible for me to send the output of an ASP file to an Excel Sheet
View Replies View RelatedASP And Excel
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?