Creating An Excel Spreadsheet From Web Form Data
I want 2 create a survey Web Form that people can fill in. I then want the data entered to be saved to an Excel spreadsheet located on a server.
Can .ASP handle this kind of task? and if so does anyone know the code required to perform this function?
The data entered will be RAW and the .ASP (or whatever required programming) will need 2 process and convert the data into the spreadsheet.
Also, would it be possible to run this from a stand alone machine so that the web form, .ASP and spreadsheet are all contained on the machine and have no outside influences?
View Replies
ADVERTISEMENT
I am creating a website in which users will be able to query an sql database by several different criteria (i.e.- name, department,supplier, part#, date). What will return to the user will be a webpage with the column headings that they selected in their search criteria (i.e.- name, supplier, part#) and below those column headings, a list of the results.
I want the user to be able to print this report or export it to an excel file, this is the part that is tripping me up.Any ideas about this? Am I going about it all wrong?
View Replies
View Related
I have asp project where large volume of data entry would be done. I am
trying to find out if there is any tool that can allow me to build asp
application where the forms would be like excel spreadsheet.
View Replies
View Related
How to using one excel template to insert data into another excel spreadsheet by using asp programming ?
View Replies
View Related
I'm creating a spreadsheet online via ASP. I have the following at the page
top...
<% Response.contenttype = "application/vnd.ms-excel" %>
<% Response.AddHeader "Content-Disposition", "filename=FullList.xls" %>
It works fine for some 60+ manufacturer listings. However, it balks on one
single manufacturer. By chance, this manuf has 18,000+ records. The others,
less than 10,000. Is there a limit to the number of records I can convert to
XLS...?
View Replies
View Related
I have my excel spreadsheet generating just fine. What I'm trying to do is format each cell to something other than "general" I've figure out how to format to currency:
<td>$<%=variable%></td>
I really need to format to "text" though. Anyone have a good link to a chart that explains how to format to all of the different possibilites, or just how to format to text?
View Replies
View Related
I'm successfully using Response.ContentType = "application/vnd.ms-excel" to generate an Excel spreadsheet from an asp page and a SQL Server database.One of the columns contains data that is a long number (13 characters eg. 1122334444566).The spreadsheet does not display the number correctly because the column is formatted as 'General' so it displays 1.12233E+12.To correct this in Excel I simply change the column type to number. How do I get around this in asp.
I know I could use fso to create the spreadsheet on the server using a template, but I prefer to do it on the client side so that I don't accumulate a whole lot of xls files on the server.
View Replies
View Related
What is the syntax to connect to an excel spreadsheet as well displaying contents of a column.
View Replies
View Related
I have a report that the user can view either on a page with HTML or they can open it in Excel.
I am attempting to change the content type with this statement:
response.contentType = "application/vnd.ms-excel"
But it appears that when I do this I lose all my request variables and my recordset is null.
View Replies
View Related
How to using asp script update data in Excel Spreadsheet with style (ie, Bold, Font Size ..) ? Is it possible to do that ?
View Replies
View Related
I'm using the Excel application object to create a
spreadsheet from a recordset. Everything seems to work
fine except any date fields are not displaying properly.
For example 4/18/2004 is displaying as 38095 in the
spreadsheet.
I loop through the recordset to display each row. The
line that actually writes out the field is:
objSpreadsheet.Cells(iRow, iCol).Value = objField.Value
Any suggestions?
View Replies
View Related
I am trying to import an excel spread sheet, my first step is to be able to see the spreadsheet on the webpage, Code:
View Replies
View Related
What would be involved with having an Excel spreadsheet displayed in an ASP page? The additional problem is that the file name changes on a monthly basis. For example, this month's file name is 'Feb 2005.xls'.
View Replies
View Related
I'm exporting tables to Excel, but they seem to format with an extra row between every record. The table is output in HTML on one line, so it doesn't seem to be a white space problem.
View Replies
View Related
I've been reading through all related Excel posts now for about an hour as well as Googling for my answer and I'm getting even more cornfuzed as I go. I have an Existing Excel Spreadsheet, I need to populate certain fields of the form with values from a Database.
I have no problems connecting to my database and pulling up the data, but I have no idea where to begin with opening my existing spreadsheet, then telling it which worksheet to use and then how to populate the fields I need.
I'm not looking for an entire code handout, this is just something that I haven't attempted before in ASP. If someone could just give a quick example of first opening the existing spreadsheet, selecting the correct worksheet and populating 1 field, I think I can figure everything else out from there.
View Replies
View Related
I've inherited this asp page. It builds an Excel spreadsheet, but it's not putting the date in the spreadsheet and I don't know why. here is the code (see bold-red line): ...
View Replies
View Related
I have a 2000 server running IIS 5. I need to send approximately 10000 emails to recipients from an excel spreadsheet with a small word document. These are requested emails, no spamming. I don't have a clue as to where/how to start this.
View Replies
View Related
I am just wondering if this is possible to do?
View Replies
View Related
I would like to know if and how it would be possible to create an
entry-screen that allows the user to enter data in a database, using a
spreadsheet/table-like entry screen. The screen would start of having
headers for each column/field and an empty row underneath. When each column
in the row is filled in, the user must have an option to add another row.
I'm look for the code/explanation that helps me set up the entry screen, and
the ASP code to add the entered data in the database.
I can imagine that each entered row is added to the table when a new row is
added, or a button is pressed and then the screen refreshes with the newly
entered information and a new row...
View Replies
View Related
i want to generate excel spreadsheet from asp by fetching record from access database. i want to save the excel file on the server and make the excel file read-only too. can i do this in anyway ? if yes, then plz help me by providing with samples or tutorials.
View Replies
View Related
I got the following error even the document itself and its parent/children folders are writeable. The IURS_machinename has all the Administrator permissions (NOT Guest group). The "test1.xls" document is editable through Excel.
Error Type:
Microsoft Excel (0x800A03EC)
Cannot access read-only document 'test1.xls'.
/CreateExcel.asp, line 222
The following is the code .......
var ExApp = new ActiveXObject("Excel.Application"); // This is line 222
if (ExApp != null) {
ExApp.Visible = false;
ExApp.Application.Workbooks.Open("c: est est1.xls");
View Replies
View Related
i'm trying to display a page in an excel format.
I'm using:
Response.ContentType = "application/vnd.ms-excel"
at the beginning
it opens an excel web sheet, but all i get is:
Code:
View Replies
View Related
I have an ASP page that create an Excel object.
xlsApp = new ActiveXObject("Excel.Application");
It works fine when using under Administrator logon name but not under other users. Proper permissions have been given to IUSR_servername for all folders.what I am missing.
View Replies
View Related
I do not get an error, but I also do not get any data in the excel file. I
know it is connecting to the db Code:
View Replies
View Related
From ASP I create response, which is to be shown as an Excel worksheet in the user's browser (by setting the ContentType and creating a table). This works fine.
Does anybody know what to do, if one of the cells should contain a multiline text? I already tried by inserting a <br> inside the <td>. But this won't work.
View Replies
View Related
I am tryign to create an excel spreadsheet/chart using office web components in asp. However I seem to have a registeration problem. I'm running office2003 and IIs is also running on my pc. When the following line exceutes an error "invalid string class is thrown" :
set objChartSpace = Server.CreateObject("OWC.Chart")
I have intalled owc again but still no luck. IS it a registeration problem ?
View Replies
View Related
We have an application where the user fills out many screens and when
they are done, we are supposed to display the text they entered in a
word or excel format. That is fairly easily accomplished by changing
the content type in the response object.
On one of the screens where they enter data, they also have the
ability to upload a word document containing additional information.
This is also not a problem, and is working fine.
Now they have decided that when we create the document with all of the
text fields in it, they want to embed the word document that they
uploaded. Is this possible? I have been trying to find a way to do
this and so far haven't come up with anything.
View Replies
View Related
I want to update Excel file when i update database.
View Replies
View Related
I want to create another Database using ASP, this I can do. However, what is the easiest way to copy tables from one DB to this new DB?
I dont really want to have to write the SQL to create each table and then to use a 'select into' code for table, especially as I have around 15 tables to do!
View Replies
View Related
I need to create a chart/graph with the following data from my database:
Each record is opened and then closed at a later stage. I then calculate the time it took from when the record was entered to when it was closed.
Now i need a pie chart to display how many records was closed in certain times. for example 10 records was closed within the first 10 minutes, 2 in 20 minutes and so on.
this also is to happen for dates that the user entered. i.e a Weekly report and a monthly report.
Any advice and help will be appreciated. I found alot of examples of hardcoded graphs but none extracting data from database.
So first i need to count the records that fits each section of minutes and then use that data to draw my graph?
View Replies
View Related
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag.
On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
View Replies
View Related
I need help creating a form for my website. I want to use an ASP page. My form will contain a few text boxes for name, a dropdown list box, and will have a "browse" button so that users can upload documents/files. Would also like to add a confirmation ASP page upon successful form submit.
View Replies
View Related
I got a ASP page where one can add a record or update any existing records.
As soon as a record is added it is appended to the existing records. With
this design user can check for erors in existing records or the added record.
Initially, there was ino data validation rule.
Now, as soon as I am putting
data validation via script, I cannot update the exisiting data as the
validation looks for empty space in the text boxes meant for adding data. Is
there any way, I can avoid this situation and can update existing records. If
this is possible, how does one validate the existing records.
View Replies
View Related
