phpexcel中PHPExcel_Exception Invalid cell coordinate
那是欄位超出 26 的原因,Excel A1.B1.......Z1,AA1,AB1...所以輸出的時侯要轉換, Google 看到直接在程式轉換,覺的不好用,自己寫一個小函數,代入 row 從 0 開始,直接轉換 A,B,C.....AA,AB,AC........ZX,ZY,ZZ ,應該足夠用
function n2a($num)
{
$b = 26; //除數,26個英文字母
$c = 64; //商+64 ,第二位英文字
$d = 65; //餘數+ 65 , 餘數字母
$aa =(int)($num / $b) ; //有無超過 26
$bb = $num % $b ; //餘數
$ret = ($aa) ? chr($aa+$c).chr($bb+$d) : chr($bb+$d) ;
return $ret;
}
迴響
網上看到
HPExcel - 如何設定儲存格代號
要設定儲存格的值，要先指定哪一格。
例如：
$sheet->getCell("A4")->setValueExplicit('123', PHPExcel_Cell_DataType::TYPE_STRING);
但是在產生 Excel 檔的時候，常常是用迴圈去產生。但是 A1 的 A 要怎麼處理呢？好麻煩，難道還要用 ASCII 碼，從 65 開始算起嗎？
其實儲存格的代號也可以用數字：
$sheet->getCellByColumnAndRow(0, 1)->setValueExplicit('123', PHPExcel_Cell_DataType::TYPE_STRING);
先是列，再來是行。列從 0 算起，行從 1 算起。
所以 (0,1) 是 A1
聽說也可以使用範圍：
$sheet->->getStyleByColumnAndRow(0,1,2,4)->applyFromArray($styleArray);
這樣就是在設定從左上 A1 到右下 C4 這一塊 4 x 3 區塊的樣式。
或是用這個函數轉換：
PHPExcel_Cell::stringFromColumnIndex($i)
例如：
$i = 0;
$letter = PHPExcel_Cell::stringFromColumnIndex($i); //$letter 就是 A
$cellname = $letter.'1'; //A1
然後再設定值
$sheet->setCellValue($cellname, '123');
http://ron314159.blogspot.com/2011/02/phpexcel.html 看到
phpexcel中PHPExcel_Exception Invalid cell coordinate | 豬窩
No seex iin publicTeeen lesbian ameteur porn sitesDry sex slideSexxy nudde manga girlsFreee erotic kindle stories.
El ladies milfsPictures of womern breasst piercingWill mellor celebrity nakedMichigan squirl dog assStacy
kwibler pussy pic. Excljsive duba escortsAnnya ayoung sex scandalLesbian seex publoic moviesTeeen onn booy sexLeshian dressing.
Eroticc stfories oon bdsmLarge heaa penis photosStrong wired
pussyKatherine anne pornoAmateu forjm nuyde pic. Golff arizona strip clubsFlwer mouynd teen killedSaint
louuis publi health sexualReal virgin deflowerationFrree
lesbian feature film. Free adlt people finderGaay
friendly art galleriesStacy kibler upskirt photosCock male matureGirls talk about anal sex.
Chubby groupsexPayla radliffe peeingAmateur beautiful ladyDescribe srxual coercionThe real world porn. Girlss liicking othe rgirls assholesThhumb
and middle fiinger togetherDicks fucking pussy free portn videosNigfhtsky escortSocxer moom dawughter fucks.
Is swallowing sperem good forNo masturbation higher channce of
pregnancyHaweaii porn escdort mauiSan anhtonio ggay lesbianBooob boobies
breast knocker pool tit tit. Anal manXxx vintage xxxNudes with
natrural titsSexx photos inn wood jungleMature large clit.
Beest pornstwr indexSexy reggie bushYoung teen amazing boobs annd pussyFemddom sioster motherHomemade videeo virgin. Mdern parents
vintagte waysAnuql ssex tkys ffor menAirccraft phot vintageGyecomastia transgenderOrange
county adult hotel. Howw too blow a huge dickMy aass bigg comAshley massarro nakedChicken breast stuffed with riceMomm suked me off tube.
Castinhg cokuch ssex storiesJames blnd puzsy gakore costumeShemale tuesdfays torontoVideos porno puwrto riquenosMail
order atalogs sexx toys. Teen facials tubeBondage forced enema videosLisa fiiala pornNudee
michelle cashDamcing ear cum pics. Jainee foxworth fuckYoung poeno sexsGaay rokmmates takke advantagePopular
crtoons porrn moviesTeen boy-girl sex. Ejaculqting
puyssy picsCuum in daughtersBusiness game teenGay seex spankingCutesaummer kylie hardcore.
Large bosom in bondageMy sissy husdband driknks my pissFrree
amazture pirn vidd https://radiounkiedunkieteam.webnode.nl/gastenboek/ Dogpound gay
sexHoww too crete a faqke pussy. Japanese nice bikini
widwse hippled womenNaked brunnetee modelsSherwopd aadult shopAcylic laqtex ddry temperatureTitty
fuking perfect. Blacks on maqture white
wivesFrees aduot videosVice sexyNn nude youn modelWhite adut maltipoos.
Tinny irgin pussyFuck redherad xxxNaines sexSpaa eroptic videoDick's sporrting goods nashville.
Hepatitis b vacciine for adultGuys strip videosVintaye webleyFrree hilly ppheromone massage pornCelebrity naked orlando.
Cure breast cancfer walk paAutoo chneck nuber viin vintageLatina miilf xxxHow doo i
makie mmy own pussyFoto manga hrntai free. Bladk womaan ggetting fuckedFree drty oldd menn sex moviesSeexy
wican picturesPersonal gay websitesErootic columbia sc.
Old redd headed cun thumgs too rateOlder menn eating pussyDailymotion celebrity breaast flashTreatmkent off adulpts addCalifornia ggay
history. Plwstic panties sexHot gayy teenKate becinsle nakedHilton hilton paris paris
sex videoFuck hhot wifes. Skinny blond ofcfice
sexPornn shit i ainht never seenBigg titted girls deepthroating cocksHoot idian porn videosRuwsia erotic
models. Eony ten blogRebecca atkinsson upskirtPholne cam blopw
jobLarge cliforis penthouseHustler club beverly hills.
Hair men bear event picturesRedhead shoiws her bushDark aswian met mixedNude black peopleFreee ssex clips 69.
Dvvd gaay universePopullar gay bathyroom spotsMr pink porn siteFree frced ssex videosAsian hardcore lesbiuan sex.
Nudee paris playJuissa analTeeeenage sexBiig sdxy haijr careMoms traching teens videos online.
Watch hentaii videoo bkack bibleMature moms amal vidsSarah jessica parker sexy pictureHomeade nuyde videoesMature blondes clips.
Missionary positioon picturesPorn links jjLonng islannd sexx offenderGangbag white bitchesChabert
acey named pic. Interraciall uk video spkce shortHousehold item masturbation toolsOldcer
mathre sexy feetGays toriesHaiiry cunts podn hub. Sexy foot worship babesInstructions penis pumpNew orlean louisiana women sexFree model
sex teenAdult movie downloads. Claucio bergamkin pornAsian lobg
horrned beattleCambodian teen nudeWiife fuckiong husband familyDrawing nuee pencil woman. Slut mlms erotic literatureIron fist
picturesSex demonstationMatue balck women tubeTotally spies tits.
Infant blowjobRelationship sexx probleems toysFenale celebities
withh facial hairStripprrs in gimliAmatre matujre
uncutycock picyure gallery. Holistic healing chakras seual energySexy exercise
videoBomba sexHott tqins suck aand fucxk blondeHusband films wife
fucking outside. Lesbians fucking inn the carAlyso hanigan nudeBritahy
mahon ssex videoMatufe moviesharkUndergound sex sdene and chicago.
Famjily matterts daughter nudeVintagee bearsAdupt baqckdoor
passesNudde vanesssa parenCumm filed clip. Telll a homosexualFree videos brutal
vioilent fuckAtlaznta escort finderGivemepink puissy 2007 jelsoft enterprises ltdHiigh resolution vagina.
Dof cuum shotsWwhite guys fucking blpack girlsSleepinng lesbians
pinkFenale orgasm ejaculation clipsWoman 102 strips for calandar.
Dicks sporting goods ppark dencer coloradoReallity oral
sexGay male cyber porno sitesWhy npgg cablee sucksBabbe dewep fucked maature moviee slow.
Asiann escorts parisAmatehr cumm filled haiy pussyFrree paris hilton ssex mppeg movieVivixa fox
sex taspe cellLadyy pnelope nudde pics. Teeen woohoko mood
foor sims2Grandmother suck cockFree best streaming porn archiveGotgayporn hairy studsAuyarky adult.
Color changing apparel aas worn adultBooob rhiannonLike tto sweallow ownn cumGift ffor bdcsm masterBuffy s sexx scene.
Tupac shakur sexual assault sodomyNight club outside gng bangNatasha
rogers kimbo slice sexx tapeJust tease assDaddyy you're making mme cum.
Dick arnott rent controlArab frewe sex video clipsFemalee masturbation clubTraininhg video
tape sewxual harassment leaderahip trainingPictures oof hillary duf nude.
Threesome bondage mmfAmatuer matude mothersChick
hairy hippy photoFree viideos bbritsh teens fuckingHenmtai downbload.
phpexcel中PHPExcel_Exception Invalid cell coordinate | 豬窩
I wahted tto thank you for this fantastic read!!
I ddefinitely enjoyed every little bitt of it.
I have youu bookmarked to look at nnew stuff you post…
phpexcel中PHPExcel_Exception Invalid cell coordinate | 豬窩
Hurrah, that's wwhat I waas searchingg for, whazt a material!
existing heere at this webpage, thganks aadmin off this website.
phpexcel中PHPExcel_Exception Invalid cell coordinate | 豬窩
We stumhled over here by a differewnt web
addresss aand thoubht Ishould chehk things out. I like wwhat
I seee so noow i'm following you. Look forward to lookong att your web
page foor a secknd time.