|
-
Nov 6th, 2008, 02:21 PM
#1
Thread Starter
Addicted Member
[2005] Very strange Excel problem...
Ok,
I have a web application that reads in data from an Excel spreadsheet. Seems to work fine, but I'm getting some strange behavior from one of the Excel columns.
Here is the scenario:
A user uploads a spreadsheet, the app reads in the data from all the columns. On this particular column, called Relo, if there is at least one value for this column within the first few rows, the rest of the rows with a value for this column will be read as well. However, if there is no value in the column after the first few rows, I always get an empty string for the value in later rows, even if there is a legitimate value in the column.
Has anyone ever encountered this? I cannot for the life of me figure out what could be potentially causing this behavior.
Edit: Don't know if it matters any, but we're using Office 2003.
Last edited by Blakk_Majik; Nov 6th, 2008 at 02:26 PM.
If my post helped you, please rate it! 
Languages: VB/ASP.NET 2005, C# 2008,VB6
Databases: Oracle (knowledge not currently in use), DB2
FROM Customers
WHERE We_Know_What_We_Want <> DB.Null
SELECT *
0 rows returned
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote