how to save the data into empty field?

alvinblim

Well-known member
Joined
Jan 7, 2006
Messages
46
Location
malaysia
Programming Experience
3-5
hi,
i am face some excel problem. everytime i save my data in excel, it will alway replace old field. it cant save in the new field. how can i save in the empty field only?
Thank you very much

Best Regards,
Alvin
 

alvinblim

Well-known member
Joined
Jan 7, 2006
Messages
46
Location
malaysia
Programming Experience
3-5
i mean everytime i save i want continue to the next field, not replace the old field. if i am using back the existing excel file. such as 1st time i save the data in the field A1, next time i save into B1. Not replce back to the A1 field.
thank for your reply.
 

cjard

Well-known member
Joined
Apr 25, 2006
Messages
7,052
Programming Experience
10+
I havent ever used Excel as an output mechanism but I'm dimly aware that we address the rows and columns in a similar way to a two dimensional array

Is there the possibility that your code is not advancing to the next field?


Take this example..

VB.NET:
Dim arr as New String(10)
 
for i as integer = 0 to 9
  arr(0) = "hello"
next i

this code reassigns the 0th element of the array ten times.. because i forgot to move the value on


VB.NET:
Dim arr as New String(10)
 
for i as integer = 0 to 9
  arr(i) = "hello"
next i

is there any chance youre doing something like this?

can you post the code that writes values into the cell?
 
Top Bottom