excel issue using cf

-

hi all,

        in application wanted download information in excel file user , user can edit downloaded file , upload again...ie dynamic excel creation... downloading working fine, when tries upload , @ time when cf server reads file, brings problems...i tried 2 ways read file

 

1) using cfx_excel2query custom tag read

 

case1: in case,  created file using cfcontent-cfheader, gives error like  12000 bytes read , -244545000 expected.

  case2: in case, created file using ben nadel's poi utility , try upload, giving error error occured..  '3'

 

 

and 2)

        ben nadel's poi utility read

 

  case1:using poi create file , export user,  in case, in cases not consider column in excel file, if 4 columns there in excel, dump after reading shows 3 columns..looking strange

 

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

 

 

note: if create excel file in desktop manaully filled data, work in cases.. , if keep blank excel in cf-server , using same after downloading manually fill..and again upload works...

 

so suspect problem dynamic creation of file....

please help, urgent..

 

thanks in advance...

questions:

 

1. have tried cfspreadsheet tag?

http://help.adobe.com/en_us/coldfusion/9.0/cfmlref/wsc3ff6d0ea77859461172e0811cbec17cba-7f 87.html

 

2. can post code?



More discussions in ColdFusion


adobe

Comments

Post a Comment

Popular posts from this blog

How to decompile jsxbin to jsx

-
hi all, i have jsxbin script. want edit script, need decompile script jsx. how can possible.     thanks in advance, mahesh it's not.   the whole idea behind jsxbin, protect being viewed , edited...   harbs More discussions in InDesign Scripting adobe
Read more

Gavik Photoslide GK2: Not able to upload photos - Joomla! Forum - community, help and support

-
my first slide show works. i upgraded joomla 1.5.14. created new slide show, no images shown. i checked firebug , found images should go http://mywebsite.com/components/com_gk2 ... es/thumbm/ directory. however images go /components/com_gk2_photoslide/images/ directory. catalog permission says followings. 1. images/ unwritable 2 images/thumbm/ unwritable 3 images/thumbs/ unwritable 4 configuration/ unwritable 5 configuration/plugins/ unwritable 6 configuration/extensions/ unwritable i checked chomd ftp , 755. could tell me how fix please? thanks in advance. you'll have better luck on developers website, bug component , there 2 or 3 different reasons. seem remember 1 thing make sure php extension enabled on server. fixed problem hacking php files months ago have assumed had fixed bug. dm Board index Joomla! Older Version Support Joomla! 1.5 Extensions for Joomla! 1.5 ...
Read more

Phoca Guestbook logger registret bruger af - Joomla! Forum - community, help and support

-
hej, problemet jeg har installeret phoca guestbook og det virker næsten. hvergang en registreret bruger har skrevet gæstebogen og trykker på send, så bliver brugeren logget af. så skal man logge på igen og kan konstatere @ indlægget er sendt og står pænt gæstebogen. hvordan forhindrer jeg joomla! og phoca guestbook @ smide brugeren af? lidt mere om opsætningen for @ skrive gæstebogen, så skal brugeren være registreret. derfor har jeg lavet et menupunkt, som kun kommer frem, når brugeren er registreret. og når man logger ind så åbner joomla! gæstebog-siden. jeg har indstillet gæstebog-siden til @ være registrerede brugere og menupunktet er sat op til de samme brugere. jeg håber @ nogle kan hjæpe. -- jan rou hej igen, og lige en detalje mere, der kan have betydning: .htaccess er aktiveret. -- jan rou Board index Joomla! International Language Support International Zone Danish Forum Ældre versioner (disse...
Read more