Excel Export

Comments

• gpi

  January 2015 edited 7:23PM

  Try to use export to XML, XLSX, BIFF8
• MikeCalm

  January 2015 edited January 2015

  gpi wrote: »

  Try to use export to XML, XLSX, BIFF8

  
  Thanks, do you think each has different limit ? I didn't write the software I use this component in , so will try your suggestion...
  
  The result is :
  
  for XLSX , Excel reports error and asks for repair this file. I could
  open file after repairing , but it's not WYSIWYG - no merged cells, no borders around cells - not usable.
  All columns are present.
  
  for XML, Excel load file without error, but data is present up to 256th column [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />, rest is empty. No merged columns despite appropriate option checked. Above exports are fine up to 256 columns ( with correct WYSIWYG ) At least I have something to raise officially. Thanks anyway.[/img]
• gpi

  January 2015 edited 7:23PM

  wrote:

  for XML, Excel load file without error, but data is present up to 256th column smile.gif, rest is empty.

  XML and XLSX works OK. See attach

  test.zip 10.1K
• MikeCalm

  January 2015 edited 7:23PM

  gpi wrote: »

  gpi wrote: »

  for XML, Excel load file without error, but data is present up to 256th column smile.gif, rest is empty.

  XML and XLSX works OK. See attach

  
  It looks nice , but real report looks very bad and I raised ticket already.
  I can't post samples here.
  
  Thanks a lot.