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
 
you mean if you write 1000 things into your excel sheet then look at it, only cell A1 is set, and it is set to the most recent value you wrote?
 
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.
 
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?
 
Back
Top