Update Excel - Newbie To ASP

[crusader]

Hi,

How do you update an existing excel sheet?
Is it possible with out using ADO.

The excel sheet already has headings, I wish to populate the spreadsheet with data from a HTML form.

Crusader

 

[Krickles]

Where are you storing the data from the HTML form? Or are you wanting to post directly to Excel? If you want to post directly to an existing spreadsheet, do you plan on appending or over-writing?

Krickles | 1.6180

 

[crusader]

Hi Krickles,

Thanks for the reply, in answer to your question I'm trying to post form data into an Excel sheet, and appending under a row of column headings.

Thanks,
Crusader

 

[DreXor]

a csv file, yes, using FSO, but excel has binary data at the beginning, column widths, functions, etc, you'll need to use ado to update it

DreX
aKa - Robert

 

[crusader]

Thanks DreXor,

I found that this works:

dim fsoObj, sFileName, objtextFile, fieldName, fieldValue
sFileName = server.MapPath("test.csv")
set fsoObj = Server.CreateObject("Scripting.FileSystemObject")
set objtextFile = fsoObj.OpenTextFile(sFileName, 8)
For ix = 1 to Request.Form.Count
fieldName = Request.Form.Key(ix)
fieldValue = fieldValue&Request.Form.Item(ix)&","
Next
objTextFile.WriteLine(fieldValue)
objTextFile.Close
set objTextFile = nothing
set fsoObj = nothing