Printable View
sorry guys my mistake for the previous mail. The 'excel' generation is actually in .csv format. In other words, I use Open xxxxx ..(where xxx is .csv format) then using a string, i pass the string into the file row by row through a loop. This is not the normal excel application whereby i can use the .numberformat ...if thats the case how do i perform the insertion of zero number in front?
Answered the question in your previous thread :D
the cell should be defined as containing text data type... otherwise if its interpreted as numeric, the leading zero is automatically dropped.
but how do I make use of the .numberformat? I mean the current codes Open and Print and close the file, insert data and close,without using the object like xlapp. etc.?
I realise that if the data has at least alph. the 0 in front will appear..whereas if all numbers , it will disappear.
is there anything i can add in as a alph. but is invisible when input to the cell ?
Excel question moved to Office Development.