Manipulating Excel data with ASP.NET

[Jim]

I have a Web application that needs to update a Microsoft Excel spreadsheet
for complex calculations, whereby I read the results into a dataset for
display. I am accessing my spreadsheet using OLE DB and ADO. I'm trying to
use and SQL update statement to update a cell in my spreadsheet, but I keep
receiving the error: No value given for one or more required parameters.

From this SQL statement: UPDATE BallisticInfo SET [Info] =3200 WHERE [Index]
= 1

BallisticInfo is the name of the spreadsheet and Info and Index or column
names. Any ideas?

[Paul Clement]

On Wed, 2 Nov 2005 10:10:03 -0800, Jim <Ji*@discussions.microsoft.com> wrote:

¤ I have a Web application that needs to update a Microsoft Excel spreadsheet
¤ for complex calculations, whereby I read the results into a dataset for
¤ display. I am accessing my spreadsheet using OLE DB and ADO. I'm trying to
¤ use and SQL update statement to update a cell in my spreadsheet, but I keep
¤ receiving the error: No value given for one or more required parameters.
¤
¤ From this SQL statement: UPDATE BallisticInfo SET [Info] =3200 WHERE [Index]
¤ = 1
¤
¤ BallisticInfo is the name of the spreadsheet and Info and Index or column
¤ names. Any ideas?

So "Info" and "Index" are values in respective cells of the first row in the BallisticInfo
Worksheet?

In addition, have you specified HDR=Yes in your connection string?
Paul
~~~~
Microsoft MVP (Visual Basic)

[Elton W]

Try

UPDATE [BallisticInfo$] SET [Info] =3200 WHERE [Index] = 1
HTH

Elton Wang

"Jim" wrote:

I have a Web application that needs to update a Microsoft Excel spreadsheet
for complex calculations, whereby I read the results into a dataset for
display. I am accessing my spreadsheet using OLE DB and ADO. I'm trying to
use and SQL update statement to update a cell in my spreadsheet, but I keep
receiving the error: No value given for one or more required parameters.

From this SQL statement: UPDATE BallisticInfo SET [Info] =3200 WHERE [Index]
= 1

BallisticInfo is the name of the spreadsheet and Info and Index or column
names. Any ideas?

[Jim]

I tried that parameter, and OLE DB throws this exception: Could not find
installable ISAM.

"Paul Clement" wrote:

On Wed, 2 Nov 2005 10:10:03 -0800, Jim <Ji*@discussions.microsoft.com> wrote:

¤ I have a Web application that needs to update a Microsoft Excel spreadsheet
¤ for complex calculations, whereby I read the results into a dataset for
¤ display. I am accessing my spreadsheet using OLE DB and ADO. I'm trying to
¤ use and SQL update statement to update a cell in my spreadsheet, but I keep
¤ receiving the error: No value given for one or more required parameters.
¤
¤ From this SQL statement: UPDATE BallisticInfo SET [Info] =3200 WHERE [Index]
¤ = 1
¤
¤ BallisticInfo is the name of the spreadsheet and Info and Index or column
¤ names. Any ideas?

So "Info" and "Index" are values in respective cells of the first row in the BallisticInfo
Worksheet?

In addition, have you specified HDR=Yes in your connection string?
Paul
~~~~
Microsoft MVP (Visual Basic)

[Jim]

I just tried that, and I received this exception: 'BallisticInfo$' is not a
valid name. Make sure that it does not include invalid characters or
punctuation and that it is not too long.

"Elton W" wrote:

Try

UPDATE [BallisticInfo$] SET [Info] =3200 WHERE [Index] = 1
HTH

Elton Wang

"Jim" wrote:

I have a Web application that needs to update a Microsoft Excel spreadsheet
for complex calculations, whereby I read the results into a dataset for
display. I am accessing my spreadsheet using OLE DB and ADO. I'm trying to
use and SQL update statement to update a cell in my spreadsheet, but I keep
receiving the error: No value given for one or more required parameters.

From this SQL statement: UPDATE BallisticInfo SET [Info] =3200 WHERE [Index]
= 1

BallisticInfo is the name of the spreadsheet and Info and Index or column
names. Any ideas?

[Paul Clement]

On Wed, 2 Nov 2005 12:05:03 -0800, Jim <Ji*@discussions.microsoft.com> wrote:

¤ I tried that parameter, and OLE DB throws this exception: Could not find
¤ installable ISAM.
¤

The syntax is a little tricky once additional arguments are added.

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\Book20.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
Paul
~~~~
Microsoft MVP (Visual Basic)

[Jim]

Thank you, that works

"Paul Clement" wrote:

On Wed, 2 Nov 2005 12:05:03 -0800, Jim <Ji*@discussions.microsoft.com> wrote:

¤ I tried that parameter, and OLE DB throws this exception: Could not find
¤ installable ISAM.
¤

The syntax is a little tricky once additional arguments are added.

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\Book20.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
Paul
~~~~
Microsoft MVP (Visual Basic)