I Dunno
I'm getting an error on the line with the *****
HRESULT: 0x800A03EC. I've seen this error so many times in so many
instances but I can't seem to figure out why I'm getting it here. Perhaps my
indexes are are throwing it out of bounds? How do I test for this? I placed
an if statement prior to that line testing
((Excel.Range)oSheet.Cells[prodNumsRow, localColumnCount]) != null but I
think it's alway != null. This is becoming a fairly complex app and if you
need me to explain the whole thing then so be it. As you can see I'm testing
that nextItem is != null and getting rid of any extra spaces, not the problem.
Somebody help, I'm sick of this thing.
if (ds.Tables[0].Rows.Count 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
object[] items = dr.ItemArray;
foreach (object o in items)
{
string nextItem = "";
nextItem = o.ToString().Trim();
if (nextItem != null)
{
***** ((Excel.Range)oSheet.Cells[prodNumsRow, localColumnCount]).Value2 =
nextItem;
}
errCount++; //ignore this
localColumnCount++;
}
}
}
Thank you
KB
--
Kevin C. Brown
Developer
|