title: PHP to Excel, not allowing more than 255 characters?
body: <p>I'm using the following code to create an xls file from php.</p>
  
  <p><a href="http://www.appservnetwork.com/modules.php?name=News&amp;file=article&amp;sid=8" rel="nofollow noreferrer">http://www.appservnetwork.com/modules.php?name=News&amp;file=article&amp;sid=8</a></p>
  
  <p>However, for some reason if the row "comments" is more than 255 characters, it doesn't output anything..</p>
  
  <p>The code which writes the String to the XLS file is:</p>
  
  <pre><code>function xlsWriteString( $Row, $Col, $Value ) {
      $L = strlen( $Value );
      echo pack( "ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L );
      echo $Value;
  return;
  };
  </code></pre>
  
  <p>Could someone help me get this to display the field regardless of how many characters are in the string?</p>
  
  <p>Thanks</p>
  
  <p>EDIT: I found this: <a href="http://support.microsoft.com/kb/213841" rel="nofollow noreferrer">http://support.microsoft.com/kb/213841</a> but not sure how to implement the work around into php..</p>
  
  <p>ANOTHER EDIT: Even if anyone knows how to merge cells? That would also work?? :)</p>