Cfpsreadsheet read strangeness

-

i have spreadsheet update , process.

it has numbers on top row use index.

i asked remove number row causing problems when people don't renumber top row properly, when do, dat gets inported ver strangely - columns duplicated , others totally left out.

 

here pictures of top few rows of spreadsheet , dump of query produced cfspreadsheet read.

the top 1 has rows , works.

the second set not.

excelworks.png

importworks.png

the same spreadsheet no top numbers produces - first record department number  duplicated 6 times instead of 1 column each column in spreadsheet:

 

 

importfails.png

<cfelseif isdefined('uploaddatatype') , uploaddatatype 'xxx'>

     <cfspreadsheet action="read" src="#thefile#" sheetname = "xxxdata" query="xxxdata" headerrow="1"   >

    </cfif>

 

any suggestions on how correct appreceated. have tried both including anx excluding header row same results.

thanks



More discussions in ColdFusion


adobe

Comments

Post a Comment

Popular posts from this blog

Adobe Acrobat Pro , Terminal Server Use

-
hello,   a fellow employee requires adobe acrobat pro installed use, , management me have sorted out. employee uses thin client connect terminal server of administration work.   i require single license adobe acrobat pro used single user.   will there license issues installing adobe acrobat pro on terminal server?   can install adobe acrobat pro on terminal server?   thanks, david hi david,   yes, can install acrobat terminal servers... !   the licensing terminal server considered normal licensing process, means need buy many number of licenses acrobat number of users accessing terminal server (like citrix) access software. eg if 10 users accessing citrix server @ particular time use acrobat software need 10 licenses same. More discussions in Installing, Updating, & Subscribing to Acrobat adobe
Read more

Thread: transmission-daemon isn't playing nice: "409: Conflict"

-
409: conflict request had invalid session-id header. fix this, follow these steps: when reading response, x-transmission-session-id header , remember it add updated header outgoing requests when 409 error message, resend request updated header requirement has been added prevent csrf attacks. error occurs when apache not running. i've tried zillion different proposed solutions involving rewriterules , proxypasses golly i'm clueless. me? following apache thing, y'know, in case. code: <virtualhost *:80> rewriteengine on documentroot /var/www <directory /> options followsymlinks allowoverride none </directory> <directory /var/www/> options indexes followsymlinks multiviews allowoverride none order allow,deny allow </directory> scriptalias /cgi-bin/ /usr/lib/cgi-bin/ <directory "/usr/lib/cgi-bin"> allowov...
Read more

Thread: gpg: Conflicting Commands

-
Image
hi, relatively new linux (have used many live disks) , have had install of ubuntu 12.04 few days now. part have found easy use , have been comfortable it. have first question can't resolve myself: adding googles repository list. when first ran command supplied google found did not have wget installed. used apt-get install it. worked fine (as far can tell) re-ran googles code : wget -q https://dl-ssl.google.com/linux/linux_signing_key.pub -o- | sudo apt-key add -deb http://dl.google.com/linux/deb/ stable non-free , message 'gpg: conflicting commands' tell me going wrong , how fix please new script : wget -q https://dl-ssl.google.com/linux/linux_signing_key.pub -o- | sudo apt-key add linux_signing_key.pub need edit /etc/apt/sources.list , add line @ end deb http://dl.google.com/linux/deb/ stable non-free end hope find usefull edit: need root or use sudo make changes /etc/apt/sour...
Read more