AnsweredAssumed Answered


Question asked by VRFuser on May 13, 1998
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"><HTML><HEAD><META content=text/html;charset=iso-8859-1 http-equiv=Content-Type><META content='"MSHTML 4.71.1712.3"' name=GENERATOR></HEAD><BODY bgColor=#ffffff><DIV><FONT color=#000000 size=2>Hello all!</FONT></DIV><DIV><FONT color=#000000 size=2></FONT> </DIV><DIV><FONT color=#000000 size=2>For a change, not a problem, but a solution.</FONT></DIV><DIV><FONT color=#000000 size=2></FONT> </DIV><DIV><FONT color=#000000 size=2>At least, is has proven to be a solution for me.</FONT></DIV><DIV><FONT color=#000000 size=2>When writing big arrays to EXCEL, duh data evaporates. Indeed it does. But, as long as the sheet you are writing to is completely blank, DDDNE, as in Duh Data Does Not Evaporate. I am now able to write an array as big as 10000 (ten-thousand) to EXCEL withput any loss of Data.</FONT></DIV><DIV><FONT color=#000000 size=2></FONT> </DIV><DIV><FONT color=#000000 size=2>For all who have reacted to my problem with this, thank you, your answers put me in the right direction. It turns out that EXCEL97 is limited to 2^14 = 16384 rows, after that, EXCEL won't recognize any data. EXCEL97 itself has a limit of 2^16 rows.</FONT></DIV></BODY></HTML>