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

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

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

when i try using AE CC 3d camera tracker after the first step it says "Analysis solve failed." help?

-
im attempting editor , trying edit segment video game (bo2) , im trying have text stick wall in video. every time try using camera tracker spends 5 minutes completing first step , guess succeeds because goes second step says "solving camera" or that, red bar appears saying "analysis solve failed." do? if you're trying use 3d camera tracker on movie froma vieo game not shot real camera, camera tracker unable solve "real" camera matched scene. More discussions in After Effects adobe
Read more