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.
View Replies
ADVERTISEMENT
i use the following code to read excel
Set ExcelConn = Server.CreateObject("ADODB.Connection")
Set ExcelRS = Server.CreateObject("ADODB.Recordset")
......
sSQL = "SELECT * FROM [Sheet1$]"
set ExcelRS = ExcelConn.Execute(sSQL)
it work fine for those cell that contained string ,but once the cell is numeric,i cant get anything in the cell.How can i solve this problem.
View Replies
View Related
I am wanting to use ASP to read the IIS log files on our web server. Can anyone help?
View Replies
View Related
I need some help because I don't know much about ASP files and I have some on my computer but am unable to read them. What program do I need to install to do that?
View Replies
View Related
I am having a few .wav files and want to read some contenet out the .wav files do i need any componenet to read this file , or it can be done via asp using file system objects or any other possibilites.
if you open any .wav files in any text editor you can see it shows some information garbled and then some text which is useful for tracking the wave files if stored in database i want to do that same.
this is what i see in the last row of my wav file from which i hv
06908 08282006 121408 23 8038 21 0314476 000000000 20 03 0
View Replies
View Related
does anyone know of a ASP script that opens .doc files , read its contents and displays them on browser. please i need this script urgently, i know its read binary and not text but i want someone to help me with the script.
View Replies
View Related
I use asp to develop a web page to read an excel file containing Chinese Character then display it in the web page. Unfortunately, I cant display it!!! it will display (?????????). Code:
View Replies
View Related
can any one help me to read the datas from the excel sheet and match it with the database.i will be thankful to you if u provide me a sample code.
View Replies
View Related
How can I use ASP to both read and write to a TXT file?
View Replies
View Related
I want to read textfiles with ASP. But I want to do this in a special way.
I want to set a variable, for each line.
So for example:
Dim line1, line2, line3, line4, line5
line1 = Line 1 of the text file
line2 = Line 2 of the text file
line3 = Line 3 of the text file
line4 = Line 4 of the text file
line5 = Line 5 of the text file
How do I have to do this? .....
View Replies
View Related
I need to do something very basic in asp. What I want to do is have one page that has a text box, and a button... the user can type whatever in the text box, and click submit, and it will create a txt file. Every time the button is pushed it overwites the file...
Then on a seperate page, whenever the page is loaded, it reads from the file and posts it on the page..I think this is very basic, but I'm very new.... I need to write it in standard ASP. One other thing that would be helpful is to have a limit on the amount that the text box will hold.
View Replies
View Related
im making a proj. that would read ini or txt files.. and would display the content of that file in a combo box..
ex.
aaa
bbb
ccc
im currently using this "<!--#include virtual="//path/filename.ini"-->" but the problem is, it would display all the text on that file..
is it possible to retrieve the content and display it in a combo box per line?
ex.
line 1 : aaa = list.index(0)
line 2 : bbb = list.index(1)
line 3 : ccc = list.index(2)
View Replies
View Related
Anyone know how to read excel file with ASP and stored it in database?
View Replies
View Related
I'm converting a VB6/SQL Server application to a web application. I need to
read data to and from Excel and Word. I'm not allowed to install Excel and
Word on the server, only on the client. Is there a way to use client side
scripts to read from and write to Excel/Word files?
View Replies
View Related
how can i read the datas in specific columns and rows from excel(.csv) file and then use that datas to calculate the min(example) and write the results into the same excel(.csv) file.
View Replies
View Related
IIS cannot read files in a directory reporting that :
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'Fso.GetFolder'
This has to do with Scripting.FileSystemObject.
I make sure the scrrun.dll is properly registered with regsvr32.
Still the problem persists.
Previously I do not know what I did right once in permission setting and
managed to display the said files but it went away after tweaking the
permission for make other functions available.
I scoured the web and this problem is a perrenial one. Many many suggestions
have been made even in expertsexchange site but no real solution. I don't
understand why it is so difficult to have this file system service up and
running.
View Replies
View Related
Can I use FileSystemObjects to Read Text Files on my server rather than just on my local drive?
View Replies
View Related
I have client who has database full of crap. One field in the "property" table is imageurl. I have been able to successfully extract only the file name from the string, such as "2030323.jpg". All images are stored in a directory called "listings". What I am trying to do is to loop through the recordset, and read each imageurl.
If there is an image file in the "listings" directory, then delete the file. It appears that some fields contain imageurls that no longer exist in the listing directory. Here is the code I have so far, I almost had it, as it told me at one point the file didn't exist. Then I screwed up the code and this is where I am at: Code:
View Replies
View Related
I've got to learn how to read/write dBase IV files fast. Please provide a good quick start / tutorial and / or some good links here.
View Replies
View Related
How can I use ASP to read data in an Excel file and than write it in the format of XML?
View Replies
View Related
How can use ASP to read in the ms-word document files the content, then copy
the content to access?
I attempt ("word.application") have opened with CreateObject to word
document only. Can I use "Find" function to search ms-word content in ASP?
View Replies
View Related
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 Related
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?
View Replies
View Related
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?
View Replies
View Related
Can .xls (excel) files be opened and manipulated using ASP?
View Replies
View Related
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 Related
I had created a macro to read data from an excel sheet and write the values to a text file. I had used "ActiveSheet.Range("GB" & k).Value" command to read the values from the excel.some cells in the excel sheet is having two lines value and four lines data, the text file is generating that value in a single line. (Ex. the cell value in address column is in four lines and should display in four lines in the text file generated from the macro)
Can i do something in the excel sheet or in vb script to read the address value line by line and write line by line in text file?
View Replies
View Related
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 Related
I'm trying to debug an application that causes ASP to stop responding
while the other IIS services continue to run and the server continues
to serve static HTML pages. I've captured a set of log files using
the IISState utility but I'm not sure what I should be looking for.
Would you be able to point me to some resources to help me to learn
how to interpret these files?
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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 Related
I,ve uploaded an MS Access DB to a web host and find that although I have set the DB permissions to Read and Write the actual tranfer changes these permissions and when I try to write to the DB there is an error to the effect that the DB is read only.
I have downloaded the DB I uploaded with full read/write permissions and find that the DB is read only.
View Replies
View Related