Updating An Excel Sheet
Is it possible for a client to update an excel worksheet sheet online ?
View RepliesIs it possible for a client to update an excel worksheet sheet online ?
View RepliesI am new to asp.net and would like to know the easiest way to view an Excel
file in my asp app.
may i know how to get got how many EXCEL sheet?i insert sheet1's data to MSSQL SERVER, but i wan to check whether sheet2 have any data onot. If have,then insert to db,else check next sheet.
step 1.
check how many SHEET in excel
step 2.
check each sheet whether have data onot.
I'm using this code in ASP that reads an excel sheet going across. But at time I want to read the excel sheet by going up or down. Is there a way to do this using this code or another? Code:
View Replies View Relatedanybody can help me simulate excel sheet interface in asp and when i make changes to the excel sheet can i save it back to the database using the excel asp changes.
View Replies View RelatedI tried to create an Excel sheet under the ASP and got the following error. I have all the permissions for the folder.
Error Type:
Microsoft JScript runtime (0x800A0046)
Permission denied
/createExcel.asp, line 313
var myApp = new ActiveXObject("Excel.Application"); (This is line 313)
i just need to read data from excel sheet through asp page .
View Replies View Relatedgot stalled at at point that i can no longer get my thoughts together.the point, is in classic asp, stream an excel file from a firebird database.temporarly save it if necessary,stream it to the browser,delete the temp file
on googling, i found some examples but all assuming that the file is locally present.
on the other hand, i beleive that is possible to stream the binary file and the save it locally to then present it to the browser, but i can't figure out how.
I am wanting to display a sheet from an excel file. I dont need to change/update it, just a simple display. Somthing like the 'Print Preview' you get in excel (that would be perfect).
i cant display the top row of the excel file. also if i try and access a cell that is empty i get an error. I need to display all cells from A1 - G60 if they have data in them or not.
I've got an application which manipulates data in a spreadsheet using ADODB.RecordSets. This works great and I am able to update the spreadsheet with no problems. However, it doesn't "recalc" the sheet even though the sheet is set for automatic calculation. Is there a way to get the sheet to "recalc"?
I've seen statement like obj.Caculate, but I get an error if I try to use statements like Server.CreateObject("Excel.Application"), so "calculate" doesn't work. Can I send it some keystrokes or get another procedure to kick off calculation?
I've read all about file uploads but i can skip that part. I'll be physically placing the excel sheet on the server for now. Each spread sheet will have the same number of columns and will match up. I need to transfer that to a matching table in my database.
i want to take the spread sheet and make it a comma separated list in notepad. i wanna take that and loop through it inserting each record as I go or something to that affect that won't take as long.
I have a master table employee , which contains the details of employees .
i have to upload the the data to this table from thye excel sheet by using asp.
that is -- what i have to do is , I have to provide a interface to browse the the excel sheet by user , afetr browsing the sheet user will submit the page and i have to read all the rows of excel sheet and update the table . if id exists in the table , then update the data otherwise append the data . Code:
I using ASPupload to upload the file to the sever but what asp code do i then use to import the data in to my table?
View Replies View RelatedI am trying to create an asp that will display part of an excel sheet. I have many hundered excel files and i want a page to view them.
the excel files do NOT have any header rows, i can't change the worksheets, is there any way i can display the contents of a work sheet? I have tried many ways but i seem to always have a problem displaying the top row.
all the excel files have been created using excel 97 if it makes any difference
is there any way of doing this?
how to upload data from excel sheet in particular row & column?
View Replies View Relatedi'm tryin to develop a webpage using classic ASP wherein the user can upload an excel sheet into an Oracle db table with the excel columns correspondin wit the oracle table columns.
i hv come across many ready made libraries/solutions that almost serve the purpose but they didnt work for me since most solutions wud populate the entire excel data into one column of the table. I wud like to know if anyone has a solution tht im lookin for specifically.
Does anyone know where I can find an easy example of how to read an Excel or XML file and automatically populate a table on a ASP page?
I want to create an asp page that has a table on it that reads from a XML or Excel file so I can update the file and the table information changes accordingly. I know this has to be somewhat simple but I cant seem to find any exmaples. I probably am not searching the right keywords or something.
Any suggestions on where to find an example script to do this?
I am using ASP to open a excel file.
I've noticed that Internet Explorer adds a number in square brackets to files downloaded from the internet and opened directly (i.e. by clicking 'Open' and not 'Save'). This creates a big problem with downloading Excel spreadsheets as square brackets are not a valid filename character inside Excel worksheet name.
When I click open, it opens the excel sheet with the sheet name
as .xls[Sheet and the excel filename as Sheet[1].xls.
Then we get the following error....
While renaming a sheet or chart, you entered an invalid name. Try one of
the following:
- Make sure the name you entered does not exceed 31 characters.
- Make sure the name does not contain any of the following characters:
: / ? * [ or ]
- Make sure you did not leave the name blank.
We have an issue where we need to allow the user to download Japanese data into an excel sheet in CSV(Comma separated value) format.
But the Japanese data comes as junk in the excel sheet,the Unicode format is not being set.
The code in the asp page is as follows,you can put this code in a .asp file and call this from the URL.
It asks for the file download,and when you download, the japanese characters comes as junk in the excel sheet. Code:
Here is a code for ASP inputs being updated in Excel. However, when I
click to submit the user, the excel does not get updated! Code:
im doin some code on asp where ive got an excel file and run it against a database file. i am trying to code it so that it runs asp code that checks the data in the database and if the data isnt present in the database- the code insert it , but if its already in the database- it should be updated.
Ive used sql commands, connection and a few loops-to run to this- it adds new data to the database but it overrides and re- inserts the data when run a second time.
I am trying to update an excel sheet with asp over a webpage. Now i am able to view the contents of the xls file so my connenction is ok. However if i try to update a cell in the xls the browser just stops responding. I already tried switching of script blocking from norton and also switched of my firewall for a sec. Code:
View Replies View RelatedI want to update Excel file when i update database.
View Replies View RelatedI would like to using style sheet in ASP generated Excel, but it sees cannot using it. Here's my code:
<style>
<!--
..report {
font-family: Arial;
font-size: 11pt;
}
//-->
</style>
<%
response.contentType = "application/vnd.ms-excel"
%>
<font class="report">testing</font>
I need to figure out how to make ASP add in the appropriate style sheet. Basically I want it to look, see what page it is on and say, 'Ok ... if this is the home page, use this style sheet ... if it is not, use this other style sheet.'
View Replies View RelatedI am having trouble with css style sheet with asp code, everything was working till I put extra of css code in there, and I got error message state expected end statement,
Response.Write "<a class="three" href=""job.asp?ID=" & rs("ID") & """
style="text-decoration: none">"
Using regular VB ASP (not .net) and calling an Access database using ODBC, I've generated a recordset based a query... (no big whoop, obviously)
Now I want to be able to open a new XL spreadsheet (client side - we're assuming user has XL) and export that table to it. I've seen some posts about DoCmd.TransferSpreadsheet, and CreateObject("excel.application")... I've never actually used them before, so I don't know where to start.
I'd like to have a link on the page with the table to "export to XL"... and then have it open XL (client side) with that table in a spreadsheet.
when user click a button data will be fetched from database based upon condition and it will be exported to multiple sheets of a single excel work book. what I am doing, onclick of button in main page, I am invoking a new asp page through document.location.href=test.asp.
In test.asp page created a instance of excel.applicaion and then fetching data from backend and putting data to different workbook cells of the the excel and at the end making excel.visible=true but the problem is excel file not getting visible on client machine.
But when I remove some server side code and put the rest of code inside vbscripting tag in the main asp page then the excel file becomes visible on client machine. I am not getting the where the problem lies in the first part .
Well, my script consists in check if the typed code doesn't exist in the DATABASE, but thats not the problem... the problem is that the PAGE1.ASP (that check the code) redirects to the ADD.ASP that will add those codes to the database!
Response.Redirect("add.asp?cod_1=" + cod_1 + "&cod_2=" + cod_2 + "&cod_3=" + cod_3 + "&cod_4=" + cod_4 + "&cod_5=" + cod_5 + "&sexo1=" + sexo1 + "&sexo2=" + sexo2 + "&sexo3=" + sexo3 + "&sexo4=" + sexo4 + "&sexo5=" + sexo5)
That's the line in page1.asp that redirects to the add.asp. So, when the database is completed empty and, the page1.asp checks that there ins't any problem with it and redirect to the add.asp that doesn't update my database!! So, it continues without any record. But, if the database has, at least, one record, the script works normally without any problem!
Another thing that I noticed is that when I, manually, type the adress Http://127.0.0.1/add.asp?cod_1=176096, for example, and the the database is empty, the script does the UPDATE and adds the code to the table!
I have no idea that the problem is. Does any one have a clue?
The goes the add.asp script: ....
I'm not sure if this is an ASP thing, a IIS thing, or a GoDaddy (where my domain is registerd and forwarded from) thing...
First I'll start by saying I run my own Windows XP web server and do all the coding myself..
I've noticed in the past (and never really gave it much thought, because the site works fine), that when I switch pages within my site, that the URL line is not always updated.
For example, I go into the pictures section, view a few pictures, then select the "Home" tab... The URL will stay with the variables that were passed when I was viewing the pictures. Therefore, if I do a "refresh", the page goes back to the pictures I was previously looking at, not the home page.
I've tried this on multiple computers at multiple sites, and with multiple browsers... And seems to happen rather consistantly...
Anyone have any thoughts?
I am looking at updating a notes part of my data base. I am calling two fields (first name and last) from the data base and putting them into read only text box (as i dont want the details changing). All of this is contained within a form. I am also calling a feild from the database called notes which originally has been inserted using a <textarea> tag. The problem i face is that you cant put values into a <textarea> (ie. i can put data from the database into the value tag of a textbox but <textarea> doesn't have a value tag). Due to this i am putting existing notes onto the page as text. Under this i have do have a <textarea> to put the new notes in.
The problem i have is that i some how need to store the existing data in the notes field and then add it to the new notes that i will be adding. I just don't know how to put the data i am getting from the notes field in the database into a variable.
Having problems writing an update script because in one of my fields I'm adding a chunk of HTML that contains ' characters. Obviously this throws up an error. How do I get around this?
View Replies View RelatedI'm trying to create and assign variables with the values from my db but can't work out the code getting my " & ' mixed up.
i = 1
do until i = 6 or rsSet.EOF
rBlock(i) = rsSet("rBlock'" & (i) & "'")
i= i + 1
rsSet.MoveNext
loop