Updating Excel Spreadsheet Through ASP.NET
I am encountering quite an unusual sort of problem while updating my Excel spreadsheet from an ASP.NET application. Basically I have an excel worksheet (Sheet1$) that contains contact information. Two columns are totally blank and I want to update all rows in that column with a single value. I am currently using the following code to perform this action...
Code to Execute Query:
A. Checked file permissions on the directory and the file itself.
B. Added some extended properties to the connection string (ReadOnly, Mode=ReadWrite) with no change in results.
C. Tried updating a single record but the column row still remained blank.
D. Debugged to make sure the variables listName and active had values (they did)
If any of you have some insight on this please let me know. Thanks in advance.
|All times are GMT. The time now is 07:06 PM.|
Powered by vBulletin®. Copyright ©2000 - 2013, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.