Skip to main content
August 24, 2010
Question

excel issue using cf

  • August 24, 2010
  • 1 reply
  • 571 views

Hi all,

        In my application i wanted to download some information in excel file to user and the user can edit the downloaded file and upload again...ie dynamic excel creation... downloading is working fine, but when he tries to upload and at this time when cf server reads the file, it brings problems...I tried two ways to read the file

1) using cfx_excel2query custom tag to read

case1: In this case,  i created file using cfcontent-cfheader, it gives error like  some 12000 bytes read and -244545000 expected.

  case2: in this case, i created file using ben nadel's poi utility and try to upload, giving error as an error occured..  '3'

and 2)

        ben nadel's poi utility to read

  case1:using the poi to create file and export to user,  in this case, in some cases it will not consider all column in excel file, like if 4 columns are there in excel, then the dump after reading shows only 3 columns..looking strange

case2: In this case,  i created file using cfcontent-cfheader, gives error like object instantiation problem in poi read function..

note: if i just create an excel file in my desktop with manaully filled data, it will work in all cases.. and also if I keep a blank excel in cf-server and using the same after downloading to manually fill..and again upload also works...

So I suspect problem is with dynamic creation of the file....

Please help, its very urgent..

Thanks in advance...

    This topic has been closed for replies.

    1 reply

    Inspiring
    August 24, 2010

    Questions:

    1. Have you tried the CFSPREADSHEET tag?

    http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec17cba-7f87.html

    2. Can you post your code?

    August 24, 2010

    hi Bob ,

              I am using MX7 server..so no spreadsheet tag and one more i am using excel 2007 version