Search.setIndex({docnames:["CodeBaseTools/CodeBaseTools","DBFXLStools2/DBFXLStools2","ExcelComTools/ExcelComTools","ExcelTools/ExcelTools","MPSSBaseTools/MPSSBaseTools","MPSSCommon Module Docs"],envversion:{"sphinx.domains.c":1,"sphinx.domains.changeset":1,"sphinx.domains.cpp":1,"sphinx.domains.javascript":1,"sphinx.domains.math":1,"sphinx.domains.python":1,"sphinx.domains.rst":1,"sphinx.domains.std":1,sphinx:54},filenames:["CodeBaseTools\\CodeBaseTools.rst","DBFXLStools2\\DBFXLStools2.rst","ExcelComTools\\ExcelComTools.rst","ExcelTools\\ExcelTools.rst","MPSSBaseTools\\MPSSBaseTools.rst","MPSSCommon Module Docs.rst"],objects:{"":{CodeBaseTools:[0,0,0,"-"],DBFXLStools2:[1,0,0,"-"],ExcelComTools:[2,0,0,"-"],ExcelTools:[3,0,0,"-"],MPSSBaseTools:[4,0,0,"-"]},"CodeBaseTools.TableObj":{close:[0,2,1,""],newId:[0,2,1,""],next:[0,2,1,""],reset:[0,2,1,""]},"CodeBaseTools._cbTools":{"delete":[0,2,1,""],"goto":[0,2,1,""],TableObj:[0,2,1,""],afielddict:[0,2,1,""],afields:[0,2,1,""],afieldtypes:[0,2,1,""],alias:[0,2,1,""],appendblank:[0,2,1,""],appendfrom:[0,2,1,""],ataginfo:[0,2,1,""],calcfor:[0,2,1,""],cb_shutdown:[0,2,1,""],closedatabases:[0,2,1,""],closetable:[0,2,1,""],closetempindex:[0,2,1,""],convert_vfp_type:[0,2,1,""],copyindexto:[0,2,1,""],copyto:[0,2,1,""],copytoarray:[0,2,1,""],countfor:[0,2,1,""],createtable:[0,2,1,""],cursortoxml:[0,2,1,""],curval:[0,2,1,""],curvaldate:[0,2,1,""],curvaldatetime:[0,2,1,""],curvaldecimal:[0,2,1,""],curvalfloat:[0,2,1,""],curvallogical:[0,2,1,""],curvallong:[0,2,1,""],curvalstr:[0,2,1,""],curvalstrEX:[0,2,1,""],dbf:[0,2,1,""],deleted:[0,2,1,""],deletetag:[0,2,1,""],deletetagall:[0,2,1,""],dispstru:[0,2,1,""],dt2seek:[0,2,1,""],dtd2expression:[0,2,1,""],dtt2expression:[0,2,1,""],dtt2seek:[0,2,1,""],eof:[0,2,1,""],fcount:[0,2,1,""],fielddicttolist:[0,2,1,""],fieldinfo:[0,2,1,""],flock:[0,2,1,""],flush:[0,2,1,""],flushall:[0,2,1,""],gatherdict:[0,2,1,""],gatherfromarray:[0,2,1,""],getNewKey:[0,2,1,""],getValueFromXMLString:[0,2,1,""],getdatasession:[0,2,1,""],getdateformat:[0,2,1,""],getfieldinfo:[0,2,1,""],indexon:[0,2,1,""],insertdict:[0,2,1,""],insertintotable:[0,2,1,""],isexclusive:[0,2,1,""],islargemode:[0,2,1,""],isreadonly:[0,2,1,""],locate:[0,2,1,""],locateclear:[0,2,1,""],locatecontinue:[0,2,1,""],makeXMLValueString:[0,2,1,""],maketempindex:[0,2,1,""],openTableList:[0,2,1,""],order:[0,2,1,""],pack:[0,2,1,""],recall:[0,2,1,""],recallall:[0,2,1,""],reccount:[0,2,1,""],recno:[0,2,1,""],refreshbuffers:[0,2,1,""],refreshrecord:[0,2,1,""],reindex:[0,2,1,""],replace:[0,2,1,""],replacedatetimeN:[0,2,1,""],replacelong:[0,2,1,""],rlock:[0,2,1,""],scan:[0,2,1,""],scatter:[0,2,1,""],scatterblank:[0,2,1,""],scatterraw:[0,2,1,""],scattertoarray:[0,2,1,""],scattertolist:[0,2,1,""],scattertorecord:[0,2,1,""],seek:[0,2,1,""],select:[0,2,1,""],selecttempindex:[0,2,1,""],setcustomencoding:[0,2,1,""],setdatasession:[0,2,1,""],setdateformat:[0,2,1,""],setdeleted:[0,2,1,""],setorderto:[0,2,1,""],setstrictaliasmode:[0,2,1,""],skip:[0,2,1,""],tagcount:[0,2,1,""],unlock:[0,2,1,""],updatestructure:[0,2,1,""],use:[0,2,1,""],used:[0,2,1,""],xmltocursor:[0,2,1,""],zap:[0,2,1,""]},"DBFXLStools2.DbfXlsEngine":{bizobj2excel:[1,2,1,""],dbf2excel:[1,2,1,""],excel2dbf:[1,2,1,""],makeBodyDecimalFormat:[1,2,1,""],makeBodyDecimalFormatXLSX:[1,2,1,""],makeBodyFormat:[1,2,1,""],makeBodyFormatXLSX:[1,2,1,""],makeBodyHiddenFormat:[1,2,1,""],makeHeaderFormat:[1,2,1,""],makeHeaderFormatXLSX:[1,2,1,""],makeTitleFormat:[1,2,1,""]},"DBFXLStools2.dbfxlTools":{dbftoexcel:[1,2,1,""],exceltodbf:[1,2,1,""],geterrormessage:[1,2,1,""],getexcelcolumns:[1,2,1,""],setfielddefault:[1,2,1,""],setheaderlist:[1,2,1,""],setoneproperty:[1,2,1,""],setwidthlist:[1,2,1,""],unpackWidths:[1,2,1,""]},"ExcelComTools.excelTools":{addsheet:[2,2,1,""],closeworkbook:[2,2,1,""],createworkbook:[2,2,1,""],getsheetfromname:[2,2,1,""],getsheetstats:[2,2,1,""],openworkbook:[2,2,1,""],setcurrentsheet:[2,2,1,""],setpagemargins:[2,2,1,""],setpapersize:[2,2,1,""],setprintarea:[2,2,1,""],setprintaspect:[2,2,1,""],setprintpagecountfit:[2,2,1,""],writecellvalue:[2,2,1,""],writerowvalues:[2,2,1,""]},CodeBaseTools:{TableObj:[0,1,1,""],VFPFIELD:[0,1,1,""],_cbTools:[0,1,1,""],cbTools:[0,3,1,""],cbToolsX:[0,3,1,""],copydatatable:[0,3,1,""]},DBFXLStools2:{DbfXlsEngine:[1,1,1,""],dbfxlTools:[1,1,1,""]},ExcelComTools:{calcColumnWidth:[2,3,1,""],excelTools:[2,1,1,""],makeBodyBoldDateFormat:[2,3,1,""],makeBodyBoldFormat:[2,3,1,""],makeBodyDateFormat:[2,3,1,""],makeBodyFormat:[2,3,1,""],makeBodyMoneyFormat:[2,3,1,""],makeBodyNoWrapFormat:[2,3,1,""],makeBodyNumber2DFormat:[2,3,1,""],makeBodyNumberFormat:[2,3,1,""],makeHeaderFormat:[2,3,1,""],makeMainTitleFormat:[2,3,1,""],makeTitleCenterFormat:[2,3,1,""],makeTitleFormat:[2,3,1,""]},MPSSBaseTools:{ADDBS:[4,3,1,""],ADDFS:[4,3,1,""],Bunch:[4,1,1,""],CTOD:[4,3,1,""],CTOT:[4,3,1,""],CTOTX:[4,3,1,""],DELETEFILE:[4,3,1,""],DOW:[4,3,1,""],DTOR:[4,3,1,""],DTOT:[4,3,1,""],FILETOSTR:[4,3,1,""],FORCEEXT:[4,3,1,""],FSacquire:[4,3,1,""],FormatDateString:[4,3,1,""],FormatDateTimeString:[4,3,1,""],HexToStr:[4,3,1,""],IsCanada:[4,3,1,""],IsValidNumber:[4,3,1,""],JUSTFNAME:[4,3,1,""],JUSTSTEM:[4,3,1,""],MPConfirm:[4,3,1,""],MPMsgBox:[4,3,1,""],MPlocal_except_handler:[4,3,1,""],MPshow_variables:[4,3,1,""],NamedTuple:[4,1,1,""],PADRIGHT:[4,3,1,""],PyTime2datetime:[4,3,1,""],RIGHT:[4,3,1,""],RTOD:[4,3,1,""],RemoveTextBlock:[4,3,1,""],STR:[4,3,1,""],STREXTRACT:[4,3,1,""],STRTOFILE:[4,3,1,""],StartOfWeek:[4,3,1,""],StrToHex:[4,3,1,""],TTOC:[4,3,1,""],TTOD:[4,3,1,""],TestTimeEntry:[4,3,1,""],WEEK:[4,3,1,""],baseService:[4,1,1,""],bf:[4,1,1,""],cleanFileName:[4,3,1,""],cleanUnicodeString:[4,3,1,""],clearHTMLCode:[4,3,1,""],confirmPath:[4,3,1,""],convertUnits:[4,3,1,""],deleteByAge:[4,3,1,""],dict2lower:[4,3,1,""],diffInMinutes:[4,3,1,""],dtFromDateAndTime:[4,3,1,""],fDiv:[4,3,1,""],findAllFiles:[4,3,1,""],get:[4,3,1,""],getCSSCalDateFormat:[4,3,1,""],getCustomDateRange:[4,3,1,""],getDateRangeTypeText:[4,3,1,""],getExcelColumn:[4,3,1,""],getJQueryDateFormat:[4,3,1,""],getMIMEType:[4,3,1,""],getTempFileName:[4,3,1,""],getconfig:[4,3,1,""],getfilechanged:[4,3,1,""],getlasterrormessage:[4,3,1,""],getrandomseed:[4,3,1,""],handleError:[4,3,1,""],isBetween:[4,3,1,""],isDateBetween:[4,3,1,""],isDigits:[4,3,1,""],isstr:[4,3,1,""],isunicode:[4,3,1,""],makeNewCSSDateFormat:[4,3,1,""],multiItemFieldToList:[4,3,1,""],rad2mile:[4,3,1,""],rawReplace:[4,3,1,""],removeNonPrint:[4,3,1,""],runPythonApp:[4,3,1,""],safeHTMLcoding:[4,3,1,""],sanitizeHtml:[4,3,1,""],setCommonErrorPath:[4,3,1,""],strRand:[4,3,1,""],thispath:[4,3,1,""],toAscii:[4,3,1,""]}},objnames:{"0":["py","module","Python module"],"1":["py","class","Python class"],"2":["py","method","Python method"],"3":["py","function","Python function"]},objtypes:{"0":"py:module","1":"py:class","2":"py:method","3":"py:function"},terms:{"0th":4,"10s":4,"123456720120629053329unit":0,"129l":4,"12S":4,"1mm":0,"24S":4,"2nd":1,"30am":4,"3rd":4,"45pm":4,"7th":4,"8th":4,"boolean":0,"break":0,"byte":[0,2,4],"case":[0,1,2,4],"char":[0,4],"class":3,"default":[0,1,2,4],"float":[0,1,4],"function":[1,3],"goto":0,"import":[0,1,4],"int":[0,4],"long":[0,4],"new":[0,1,2,4],"null":0,"return":[0,1,2,3,4],"short":0,"switch":0,"throw":0,"true":[0,1,2,4],"try":0,"while":[0,1],AND:[0,1,4],ARE:0,Added:[0,4],BUT:0,But:[0,1],DOS:0,Doing:0,FOR:0,For:[0,4],Its:2,NOT:[0,1,4],Not:[0,1],OLE:0,ONE:0,One:0,Such:0,That:[0,4],The:[0,1,2,3,4],Then:[0,3],There:[0,1,3,4],These:[0,1,3],USE:0,USED:0,Use:[0,1,2,4],Uses:[1,4],WILL:0,WITH:0,Will:[0,1],With:0,XLS:[1,2,3],Yes:4,__del__:0,_cbtool:0,abc:0,abil:4,abl:[0,1,4],about:[0,1,4],abov:[0,1,4],absolut:0,accept:[0,4],access:[0,1,2,3,4],accommod:0,accordingli:[0,1,4],accur:[0,3],across:0,action:[0,1],activ:0,actual:[0,1,2,4],adapt:4,add:[0,1,4],addb:4,added:[0,1,3,4],addf:4,addhiddennam:1,adding:[0,3],addit:[0,4],address:[2,3,4],addsheet:2,adher:0,advantag:0,affect:[0,2],afford:0,afield:0,afielddict:0,afieldtyp:0,after:[0,1,4],again:[0,2],against:4,age:4,alia:[0,1],alias:0,align:4,aliv:0,all:[1,2,3,4],alloabl:0,allow:[0,1,3,4],alon:1,alpha:[0,4],alphabet:4,alphanumer:0,alreadi:[0,1],also:[0,1,3,4],alter:0,altern:[0,3,4],although:[1,3],alwai:[0,1,4],amd:0,american:[0,4],among:0,amongst:0,analog:0,angl:4,ani:[0,1,2,4],anoth:0,ansi:0,answer:4,anyth:[0,4],anywai:4,api:0,app:4,appear:0,append:[0,1,2,4],appendblank:0,appendflag:1,appendfrom:0,appli:[0,1,3,4],applic:[0,2,4],approach:0,appropri:[0,1,4],approxim:[0,1],april:0,archiv:0,area:2,aren:[0,4],arg:0,argument:2,around:[0,1,3,4],arrai:[0,2],arrang:0,asc:0,ascend:0,ascii:[0,3,4],assign:0,associ:0,assum:0,assumpt:0,assur:0,atabl:0,ataginfo:0,attach:1,attempt:[0,1],attribut:[0,4],auto:[0,4],automat:[0,4],avail:[0,1,3],averag:0,avg:0,avi:0,avoid:[0,2,4],awar:0,back:[0,1,4],backward:0,bad:[0,4],badfieldvaluetyp:0,badli:0,ballowspac:4,base:[0,2,3,4],baseservic:[1,4],basic:0,bblankok:4,bbyzap:0,bce:0,bdescend:0,becaus:[0,4],becom:0,bed:0,been:[0,4],befor:0,begin:[0,4],behav:0,behavior:[0,1,4],being:[0,1,4],below:[0,1,4],besid:0,best:[0,1],better:1,between:[0,2,4],bewar:0,bfieldsfromrow1:0,bfixnewlin:4,bforceint:4,bheader:0,bhiddennam:1,bidtool:4,binari:[0,1],biscom:[1,4],bislarg:0,bit:[0,1,4],bitset:4,biz:1,bizobj2excel:1,bizobject:1,blank:[0,1,4],blargemod:0,blob:0,block:[0,4],bmakeascii:4,bmode:0,bnoclos:1,bnotop:0,bnull:0,bodi:1,bof:0,bold:1,bomitcomma:4,book:1,bool:0,both:[0,1,2],bother:0,bottom:[0,2,3],bpartial:0,brand:0,brief:0,british:0,brows:0,brute:[0,4],bsimpl:4,bstripblank:0,buffer:0,bug:4,build:0,built:[0,3,4],bunch:[0,4],bypass:0,bytearrai:[0,4],cach:0,calccolumnwidth:2,calcfor:0,calcul:[0,4],calendar:[0,4],calia:0,call:[0,1,2,3,4],caller:0,came:0,can:[0,1,2,3,4],canadian:4,candid:0,cannot:0,cantones:0,capabl:0,capp:4,caption:[0,1],captur:0,card:4,care:[0,4],caus:[0,4],cb_shutdown:0,cbtool:[0,1],cbtoolsx:0,cbwappendfrom:0,cbwsetdateformat:0,cconvcod:4,ccountri:4,ccyymmddhh:0,cdatadirectori:0,cdatefmat:4,cdatestr:4,cdelim1:4,cdelim2:4,cdelim:[0,4],cdelimit:0,cdialect:0,cdirpath:4,cdx:0,cell:[1,2,3],centimet:4,cerrorfilepath:4,cerrormessag:0,cerrornumb:0,certain:0,certainti:0,cevosfmat:4,cexcelnam:1,cexcl:4,cexpr:0,cext:4,cf2cf:4,cf2cm:4,cfield:0,cfieldlist:[0,1],cfile:4,cfilenam:0,cforexpr:[0,1],chang:[0,1,2,4],charact:[0,1,3,4],characterist:0,charcter:0,check:[0,1,4],chines:0,chomedir:4,claim:0,clean:4,cleanfilenam:4,cleanunicodestr:4,clear:0,clearhtmlcod:4,clever:4,client:[0,1,2],clock:[0,4],close:[0,2,3],closedatabas:0,closet:0,closetempindex:0,closeworkbook:2,cm2cf:4,cm2cm:4,cm2in:4,cm2mt:4,cmsg:4,cname:[0,4],cnew:4,code:[0,1,2,4],codebas:[0,1],codebasepywrapp:0,codebasetool:[1,4],codebasewrapp:0,codec:0,codepag:0,coerc:0,cold:4,collat:0,collect:[0,1,2],colon:0,column:[1,2,3,4],columnsonli:1,com:[0,1,2,3,4],combin:0,come:0,comma:[0,1,4],command:[0,4],comment:0,commerci:[1,3],common:[0,3],compani:0,compar:0,comparison:0,compil:0,complet:[0,4],complex:0,complic:0,compon:[0,3,4],compound:0,compress:2,comprop:2,concanten:0,concantent:0,concept:[0,3],concurr:[0,4],condit:[0,1,4],conf:4,confid:[0,1],configobj:4,configur:[0,1,4],confirmpath:4,conflict:0,confus:4,congruent:0,conjunct:0,connect:0,consecut:0,consid:[0,4],consider:[0,1,3],consist:[0,1,4],constant:0,constantli:0,construct:[0,3,4],consult:0,contain:[0,1,2,3,4],content:[0,1,2,3,4],context:4,continu:0,contrast:0,control:[1,3],conveni:[0,3],convent:0,convers:[0,1,2,3,4],convert:[0,1,4],convert_vfp_typ:0,converttyp:0,convertunit:4,convertyp:0,copi:[0,1,4],copper:0,copydatat:0,copyindexto:0,copyto:0,copytoarrai:[0,1],core:0,correct:[0,3,4],correctli:0,correl:0,correspond:[0,2,4],corrupt:0,cost:3,could:[0,3],count:[0,2,4],counter:2,countfor:0,countrecord:0,cours:0,coutput:0,cp1251:0,cp1252:0,cpad:4,cparmstr:4,cpath:[0,4],cpattern:4,cprovinc:4,cquotechar:0,crangetyp:4,crash:0,creat:[0,1,4],createt:0,createworkbook:2,creation:4,creator:1,criteria:0,cross:3,csep:4,csheetnam:1,cskel:4,csortord:1,csourc:[0,4],csourcealia:0,csourcedir:0,csourcet:0,cspec:4,cspecfil:4,csrc:4,css:4,cstr:4,csv:0,ctablenam:0,ctagexpr:0,ctagfilt:0,ctagnam:0,ctargetalia:0,ctargetdir:0,ctargett:0,ctestexpr:0,ctesttim:4,cthelist:1,ctheprop:1,ctime:4,ctitleon:1,ctitletwo:1,ctod:4,ctot:4,ctotx:4,ctype:[0,3,4],cubic:4,currenc:0,current:[0,2,4],cursor:0,cursortoxml:0,curval:0,curvald:0,curvaldatetim:0,curvaldecim:0,curvalfloat:0,curvallog:0,curvallong:0,curvalstr:0,curvalstrex:0,custom:[0,4],cvalu:[0,4],cxml:0,cyril:0,czip:4,dai:[0,4],dat:0,data:[1,4],databas:0,datadir:0,date:[0,1,4],datefield:0,datepick:4,daterang:4,datetim:[0,4],datetimepicker3_css:4,datetimevalu:0,dateutil:4,datevalu:0,dbase:0,dbf2excel:1,dbf:[0,1,4],dbftoexcel:1,dbftool:1,dbfxlsengin:1,dbfxltool:1,dbz:4,ddata:0,ddict:0,ddthh:4,deal:0,debug:0,dec:[0,4],decim:[0,1,2,4],decod:4,decor:4,decrypt:4,defin:[0,1,2,3,4],definit:0,degre:4,delai:0,delet:[0,1,4],deletebyag:4,deletefil:4,deletetag:0,deletetagal:0,delimit:[0,4],deliv:1,delmit:4,depend:4,deprec:[0,4],deriv:0,descend:0,describ:0,descript:0,design:[0,3,4],desir:[0,2],despit:0,destroi:0,detail:[0,1,2,4],detect:4,determin:[0,1,2,4],develop:[0,3],dialect:0,dict2low:4,dict:[0,4],dictionari:[0,4],didn:0,differ:[0,1,4],diffinminut:4,digit:[0,4],dimens:2,diner:0,directli:[0,1,3],directori:[0,4],discard:[0,2],disk:0,dispatch:1,displai:[0,1],dispstru:0,distribut:[1,3],ditto:0,divid:4,divis:4,dlat:4,dll:[0,1,3],dlon:4,dmmy:4,dmy:[0,4],dmyi:4,doc:0,docstr:[0,3],documen:0,document:[0,1,2,3],doe:[0,1,4],doesn:[0,1,3,4],don:[0,4],done:[0,1],dot:4,doubl:0,doublequot:0,doubt:0,dow:4,down:[0,1,4],drastic:0,drive:4,drop:4,dt2seek:0,dtd2express:0,dtfromdateandtim:4,dthedat:4,dtor:4,dtot:4,dtt2express:0,dtt2seek:0,dttest:1,due:0,duplic:0,dynam:0,each:[0,1,2,3,4],easi:[0,4],easiest:0,easili:[0,4],effect:0,either:[0,1,2,3,4],elabor:0,elect:0,element:[0,2,4],elimin:0,els:[0,4],embed:[0,4],employee1:0,empmyfil:4,empti:[0,1,4],emul:[0,4],encod:[0,3],encount:0,encrypt:4,end:[0,1,2,4],endoffil:0,enforc:0,engin:[0,1,4],enhanc:0,ensur:0,entir:[0,4],entiti:0,entri:[0,4],environ:4,eof:0,equal:[0,1],equival:[0,4],era:0,error:[0,1,2,4],errormessag:0,errornumb:0,escapechar:0,especi:0,etc:[0,1,2,4],europ:0,european:[0,4],evalu:[0,4],even:0,ever:0,everi:[0,2,3,4],evo:4,exact:[0,4],exactli:0,examin:[0,4],exampl:[0,1,3,4],exce:4,excel2dbf:1,excel:[0,1,2,3,4],exceltodbf:1,exceltool:[1,2],except:[0,1,4],excess:0,excl:0,exclud:4,exclus:0,exe:4,execut:[0,4],exist:[0,1,2,4],exit:0,expect:[0,4],explan:0,explanatori:[0,4],explicit:[0,3],explicitli:[0,4],exploit:0,exponenti:4,expr:0,express:[0,1,4],ext:[1,4],extend:[0,4],extens:[0,1,4],extern:[0,3,4],extract:[0,4],extrem:0,factor:0,factori:1,fail:[0,4],failur:[0,1],fairli:1,fall:4,fals:[0,1,2,4],fast:[0,1],faster:[0,1,3],fcount:0,fdiv:4,featur:[0,3],februari:0,fee:3,feet:4,few:0,field:[1,4],fielddicttolist:0,fieldinfo:0,fieldlist:[0,1],fieldnam:0,fieldtomatch:0,file:[0,1,2,3,4],filenam:0,filetostr:4,fill:[0,1],filter:0,find:[0,2,3,4],findallfil:4,fine:0,finish:0,first:[0,1,2,3,4],first_nam:0,firstfield:0,firstnam:0,fit:[0,2,4],five:0,fix:[0,4],flag:[0,1],fldexpr:0,flexibl:0,flock:0,flush:0,flushal:0,fmattyp:4,folder:4,follow:[0,1,2,4],font:[1,3],forc:[0,1,4],forceext:4,forexpr:0,form:[0,2,4],format:[0,1,2,3,4],formatdatestr:4,formatdatetimestr:4,formula:3,forth:0,forward:0,found:[0,1,2,4],foundat:3,four:0,foxpro:[2,4],fpt:0,fraction:[0,2,4],free:0,french:0,from:[0,1,2,3,4],fsacquir:4,ft2ft:4,ft2in:4,ft2mt:4,full:[0,3,4],fulli:[0,1,2,3,4],func:4,further:[0,2],futur:0,gain:1,gather:0,gatherdict:0,gatherfromarrai:0,gathermemvar:0,gb2312:0,gclasterrormessag:[0,4],gear:2,gener:[0,1,3,4],german:0,get:[0,1,2,4],getconfig:4,getcsscaldateformat:4,getcustomdaterang:4,getdatasess:0,getdateformat:0,getdaterangetypetext:4,geterrormessag:1,getexcelcolumn:[1,4],getfieldinfo:0,getfilechang:4,getjquerydateformat:4,getlasterrormessag:[0,4],getlist:0,getmimetyp:4,getnewkei:0,getrandomse:4,getrowvalu:3,getsheetfromnam:2,getsheetstat:2,gettempfilenam:4,getvaluefromxmlstr:0,gigabyt:0,give:[0,1],given:0,glob:4,global:[0,4],gnu:0,goe:0,going:0,gomod:0,gonum:0,govern:[2,4],gpl:0,granular:3,great:0,greater:[0,2,4],grill:0,guarante:0,had:0,hamberg:0,hand:0,handl:[2,3],handleerror:4,happen:0,has:[0,1,2,3,4],hasn:0,have:[0,1,4],haven:0,head:1,header:[0,1],headerlist:1,height:2,help:0,helper:4,here:[0,1,2,4],hex:4,hexadecim:4,hextostr:4,hidden:1,hiddennam:1,high:[0,2],higher:[3,4],highest:0,highli:3,hitch:0,honor:0,hour:[0,4],hourtyp:4,how:[0,3],howev:[0,1,3],html:4,human:[1,4],hybrid:1,ident:[0,1,4],identifi:0,ieee:0,ignor:[0,1,4],illeg:[0,4],immedi:0,implement:[0,3],imposs:0,improv:0,in2cm:4,in2ft:4,in2in:4,in2mt:4,inc:[0,1,3],inch:[2,4],includ:[0,1,3,4],inclus:4,incorrect:2,incr:0,increment:0,incur:0,index:[0,1,2,3,4,5],indexon:0,indextag:0,indic:0,indict:0,indistinguish:0,individu:[0,3,4],ineffici:0,inert:0,info:0,inform:[0,1,4],ingnor:1,inherit:[0,1,2,4],initi:[0,4],input:[0,1,4],insert:[0,1],insertdict:0,insertintot:0,insertintotableex:0,inspect:[0,1],instal:1,instanc:[0,1,3,4],instead:[0,1,4],intact:0,integ:[0,1,3,4],integr:1,intend:[0,1,2],interact:4,interfer:0,intern:[0,1,3],interpret:[0,4],interrog:0,interv:0,invalid:0,investig:1,invok:1,involv:0,isbetween:4,iscanada:4,isdatebetween:4,isdigit:4,isdir:4,isexclus:0,isformula:2,islargemod:0,isn:0,iso:4,isol:0,ispassword:4,isreadonli:0,isstr:4,issu:0,isunicod:4,isvalidnumb:4,italian:0,item:[0,1],iter:0,its:0,itself:[0,4],jan:[0,3],japan:0,javascript:4,jmc:[3,4],joe:0,john:0,jone:0,jqueri:4,jsh:[0,3,4],json:4,juli:0,julian:0,june:4,just:[0,1,4],justfnam:4,justifi:4,juststem:4,keep:0,kei:[0,4],keyerror:0,keyword:0,kg2lb:4,kilogram:4,kind:0,know:[0,1,2],known:0,kt2kg:4,kwarg:0,landscap:2,languag:0,lappendsheet:1,larg:0,larger:[0,1],largest:0,last:[0,4],last_nam:0,lastnam:0,lat:4,later:0,latest:0,latter:0,launch:1,lb2kg:4,lb2lb:4,lbappend:4,lbbinaryasunicod:0,lbhow:0,lbignoremiss:0,lbstrip:0,lbstripblank:0,lbtotext:0,lcalia:0,lcdbf:1,lcdbfname:1,lcdelimit:0,lcexcel:1,lcexcelnam:1,lcexpr:0,lcfield:0,lcfieldnam:0,lcfile:4,lcformat:0,lcpath:4,lcsheetnam:1,lcsourc:4,lcsourcetyp:0,lcsourcevalu:0,lcstring:4,lctablenam:0,lctag:0,lctype:2,lcwhich:2,least:[0,1],leav:[0,4],left:[0,2,4],legaci:0,legal:[0,1,2],len:0,length:[0,4],less:[0,4],lesser:0,let:1,letter:[0,1,2,4],level:0,librari:[0,3],libxl:[1,3],libxllicenseinfo:1,libxlwrapp:[1,3],licens:[0,1,3],light:0,like:[0,1,2,4],limit:[0,1],line:[0,4],linetermin:0,list:[0,1,4],littl:0,live:0,lmonth:4,lncode:0,lnfromcol:2,lnfromrow:2,lnpageheight:2,lnpagewidth:2,lnsheet:2,lntocol:2,lntorow:2,lnwidth:2,load:[0,1,2],local:0,locat:[0,3],locateclear:0,locatecontinu:0,lock:0,logic:[0,4],login_id:4,lon:4,longer:[0,1],look:[0,4],lookup:[0,4],loop:0,lose:4,lost:0,lot:0,lower:[0,1,4],lpavalu:2,lpbblankok:4,lpbdosav:2,lpcalia:0,lpcdefaultvalu:1,lpcdelim1:4,lpcdelim2:4,lpcencod:0,lpcext:4,lpcfieldnam:[0,1],lpcfile:4,lpcfilenam:[2,4],lpcfirstsheetnam:2,lpcfldname:0,lpcformat:0,lpchex:4,lpchow:2,lpckei:4,lpcsheetnam:2,lpcsourc:4,lpcstr:4,lpcstring:4,lpctype:2,lpddate:4,lpncnt:4,lpncol:[2,4],lpndai:0,lpndec:4,lpnfrom:4,lpnhour:0,lpnindex:2,lpnlen:4,lpnminut:0,lpnmonth:0,lpnrow:2,lpnsecond:0,lpnstartcol:2,lpntest:4,lpnto:4,lpnval:4,lpnvalu:0,lpnyear:0,lpxvalu:[0,2],lquarter:4,ltdate:4,lweek:4,lxdict:0,lxfield:0,lxfieldinfo:0,lxvalu:0,lyear:4,machin:[0,1],made:[0,1],mai:[1,2,3,4],main:1,mainli:0,make:[0,1,2,4],makebodybolddateformat:2,makebodyboldformat:2,makebodydateformat:2,makebodydecimalformat:1,makebodydecimalformatxlsx:1,makebodyformat:[1,2],makebodyformatxlsx:1,makebodyhiddenformat:1,makebodymoneyformat:2,makebodynowrapformat:2,makebodynumber2dformat:2,makebodynumberformat:2,makeheaderformat:[1,2],makeheaderformatxlsx:1,makemaintitleformat:2,makenewcssdateformat:4,maketempindex:0,maketitlecenterformat:2,maketitleformat:[1,2],makexmlvaluestr:0,manag:[0,1,3],mani:[0,2,3,4],manipul:0,manual:0,mar:4,march:4,margin:2,mark:0,marker:0,markeup:4,match:[0,4],matchtyp:0,matchvalu:0,max:0,maxcount:0,maximum:0,mdy:[0,4],mdyi:4,mean:[0,1,4],meaning:1,measur:0,mechan:[0,1],meet:0,memo:[0,1,4],memori:[0,2],mercuryg:4,messag:[0,1],meter:4,method:[0,1,2,3,4],microsoft:3,middl:0,midnight:4,midst:0,might:0,militari:4,million:1,millisecond:0,min:0,minim:0,minimum:[0,3],minu:0,minut:[0,4],mismatchedfield:0,miss:1,mode:[0,1],model:3,modest:0,modif:4,modifi:[0,4],modul:[0,1,2,3,4],mondai:4,mongodb:1,month:[0,4],more:[0,1,3,4],most:[0,2,4],move:[0,1,2],mpconfirm:4,mplocal_except_handl:4,mpmsgbox:4,mpshow_vari:4,mpss:[3,4],mpssbasetool:1,mpsslib:4,mt2cm:4,mt2ft:4,mt2in:4,mt2mt:4,mtd:4,mtool:4,much:[0,1],multi:0,multibyt:0,multiitemfieldtolist:4,multipl:[0,3,4],must:[0,1,2,4],mybitfield:4,mydatetim:4,myfield01:0,myfil:4,myresult:0,mytag:0,name:[0,1,2,3,4],namedtupl:4,nativ:[0,2,4],navig:0,navigation:0,ndai:4,ndecim:0,ndegre:4,ndirect:0,ndividend:4,ndivisor:4,necessari:[0,4],necessarili:0,need:[0,1,2,3,4],neg:[0,1,4],nerrornumb:0,nest:0,network:0,never:0,newcsscal:4,newid:0,newli:[0,1],newlin:0,next:0,nextkei:0,nextkeyv:0,nfromnumb:4,nhow:4,nlen:4,nlength:0,nobuff:0,noclos:1,nodata:0,noflush:0,non:[0,1,2,3,4],none:[0,1,4],nor:0,normal:[0,1,4],notat:[0,4],note:[0,1,2,4],noth:[0,1,4],now:[0,4],nradian:4,nsession:0,nsize:4,nth:4,ntherecord:0,number:[0,1,2,4],numer:[0,1,4],numericoverflow:0,nuniqu:0,nval2:4,nval:4,nwidth:0,obei:0,obiz:1,obj:4,object:[0,1,3,4],obsolet:0,obtain:0,ocbt:0,occur:0,occurr:[0,4],ocfg:1,ocsv:0,oct:[0,4],octob:0,odditi:0,oengin:1,off:0,offer:0,offset:3,often:4,olat:4,old:0,older:[0,4],olon:4,omit:[0,4],onc:0,one:[0,1,2,3,4],ones:0,onli:[0,1,2,3,4],open:[0,1,2,3],openli:2,opentablelist:0,openworkbook:2,oper:[0,2],opposit:0,opt:0,optim:0,optimiz:0,option:[0,1,4],order:[0,1,4],origin:0,other:[0,1,2,4],otherwis:[0,1,2,4],our:4,out:[0,1,4],output:[0,1,2,4],over:[0,1],overhead:0,overrid:[0,1,2,4],overridden:0,overwrit:[0,1],overwritten:[0,1],ovfp:1,own:0,owner:0,pack:0,packag:1,pad:[0,4],padright:4,page:[0,1,2,4,5],paper:2,param:[0,1,2,4],paramet:[0,1,2,4],parm:[0,4],pars:[0,4],parser:4,part:[0,1,4],partial:[0,4],particular:0,partwai:0,pass:[0,1,2,3,4],password:4,past:0,path:[0,1,2,4],pathlik:0,pattern:[0,4],paus:0,pend:[0,2],per:[0,4],perform:[0,1,3],period:0,permit:[1,3],pete:0,peter:0,physic:[0,4],pixel:1,place:[0,1,4],plain:[0,3],plantool:4,plantoolspythonsservic:1,platform:3,plu:0,point:[0,1],pointer:0,poor:4,popul:[0,1],portion:[0,2,4],portrait:2,posit:[0,1,4],possibl:[0,1,2,4],potenti:0,pound:4,power:[0,3],practic:[0,4],pre:0,preced:0,precis:0,prefer:0,prefix:0,prepar:0,prepend:0,presenc:0,preserv:0,prev:0,prevent:0,preview:2,previou:0,previous:0,prg:4,primari:0,print:[0,2,4],printabl:2,printer:2,prior:[0,1,4],problem:[0,1],process:[0,1,2,4],produc:[0,1,2],product:[1,3],program:[0,1,3,4],programm:0,proper:0,properli:[0,1],properti:[0,1],protect:[3,4],provid:[0,1,2,3,4],ptdate:4,pull:1,punctuat:[0,4],pure:0,purg:0,purport:4,purpos:[0,4],put:[0,4],pycomsupport:2,pyd:0,python27:4,python36:4,python:[1,2,3,4],pythonpath:4,pytime2datetim:4,qtd:4,qualifi:[0,1,2,4],quarter:4,question:4,quick:[0,4],quickli:0,quot:0,quotat:0,quotechar:0,rad2mil:4,radian:4,rainforest:4,rais:[0,4],random:[0,4],rang:4,rather:[0,4],raw:[0,1],rawcopi:1,rawreplac:4,reach:0,read:[0,1,2,3,4],readabl:[0,1,4],reader:0,readi:0,readonli:0,realli:[0,4],reason:0,recal:0,recallal:0,reccount:0,receiv:[0,4],recent:[0,4],recno:0,recogn:[0,2,4],recommend:0,reconstruct:0,record:[0,1],recordkei:0,reduc:0,refer:[0,1,2,3],referenc:[0,3],refin:0,reflect:4,refresh:0,refreshbuff:0,refreshrecord:0,regardless:[0,4],regular:0,reindex:0,rel:[0,1,4],relat:0,releas:0,reliabl:4,remain:0,rememb:0,remov:[0,1,4],removenonprint:4,removetextblock:4,renam:0,render:0,reopen:0,repeat:[0,4],repeatedli:[0,2],replac:[0,1,4],replacedatetimen:0,replacelong:0,replic:[0,4],report:[0,1,4],repres:[0,4],represent:[0,4],request:0,requir:[0,1,2,4],reset:0,respect:[0,1],respons:[0,4],restor:0,restrict:1,restructur:0,result:[0,1,2,4],retain:0,reteiev:0,retri:0,retriev:[0,4],revers:[0,1,4],revis:0,right:[0,1,2,4],risk:0,riski:0,rlock:0,root:4,round:0,routin:0,row:[0,1,2,3],rtod:4,rule:[0,1],run:[0,1,3,4],runpythonapp:4,russian:0,s_num:0,safe:[0,1],safehtmlcod:4,sai:0,salari:0,same:[0,1,3,4],sanitizehtml:4,satisfi:0,saturdai:4,save:[0,2,3],scalar:0,scan:0,scatter:0,scatterblank:0,scatterraw:0,scattertoarrai:0,scattertolist:0,scattertorecord:0,scratch:0,sdf:0,search:[0,5],second:[0,1,2,4],section:0,see:[0,1,2,4],seed:4,seek:[0,4],seem:1,select:[0,2,4],selector:4,selecttempindex:0,self:0,sensit:[0,1,2],sent:0,sep:3,separ:[0,1,3,4],septemb:0,sequenc:[0,4],sequenti:0,sequit:0,seri:0,server:0,servic:[0,1,4],session:0,set:[0,1,2,4],set_properti:1,setcommonerrorpath:4,setcurrentsheet:2,setcustomencod:0,setdatasess:0,setdateformat:0,setdelet:0,setfielddefault:1,setheaderlist:1,setoneproperti:1,setorderto:0,setpagemargin:2,setpapers:2,setprintarea:2,setprintaspect:2,setprintpagecountfit:2,setstrictaliasmod:0,setwidthlist:1,sever:0,share:[0,1],sheet:[1,2],sheetnam:1,shortcom:4,shorter:0,should:[0,1,2,4],show:4,showerror:1,shown:0,side:[0,2],sign:[0,4],signatur:0,signific:[0,3],similar:[0,1,4],simpl:[0,1,4],simpler:[0,1],simpli:[0,4],simplifi:[0,3,4],simultan:3,sinc:[0,2,3,4],singl:[0,4],situat:[0,4],six:4,size:[0,2,4],skeleton:4,skip:0,skipinitialspac:0,slice:4,slightli:0,slow:1,slower:[0,1],smaller:0,some:[0,1,4],somed:0,somehow:0,someth:0,somewhat:1,sort:[0,1],sourc:[0,1,4],sp2:0,space:[0,4],spcifier:0,spec:0,special:[0,4],specif:[0,1,4],specifi:[0,1,2,4],speed:[0,1],spell:0,spreadsheet:[1,2,3,4],sql:0,ssn:0,ssssss:4,stand:1,standard:[0,1,4],start:[0,1,2,4],startofweek:4,stat:0,state:0,statist:0,statu:0,stayopen:0,stdout:0,step:0,still:[0,2],stod:0,stop:0,storag:0,store:[0,1,3,4],str:[0,4],strextract:4,strictli:0,string:[1,2,3,4],stringifi:1,strip:0,stripblank:0,strlength:4,strongli:0,strrand:4,strtofil:4,strtohex:4,structur:[0,1,3,4],struggl:4,stuff:4,sub:[0,4],subdirectori:0,subject:0,subsequ:0,subset:0,substanti:0,substitut:0,subtl:0,success:[0,1,4],successfulli:0,suffici:[0,4],suit:1,suitabl:0,sum:0,sundai:4,suppli:[0,1,4],support:4,sure:[0,1],surviv:0,synonym:0,syntax:0,sys:4,system:[0,1,4],tab:0,tabl:[0,1,4],table_nam:0,tablenam:0,tableobj:0,tag:[0,1,4],tagcount:0,tagfilt:0,tagnam:0,tailor:0,taiwan:0,take:[0,1,4],taken:1,talli:0,target:[0,1,3,4],targmatch:0,task:[0,3],tdatetim:4,tdatetime1:4,tdatetime2:4,tell:[0,1],temp:0,templat:1,templatedbf:1,temporari:[0,4],termin:0,terribl:0,test:[0,3,4],testtimeentri:4,text:[0,1,2,4],textual:0,tfrom:4,tfromdat:4,than:[0,1,2,3,4],thei:[0,1],them:[0,1,2,3,4],themselv:0,thepath:4,therefor:0,thi:[0,1,2,3,4],thing:1,think:[0,4],third:1,thispath:4,those:[0,1,4],though:0,thousand:1,thousandth:0,three:[0,2,3,4],through:[0,4],thu:0,tight:0,time:[0,2,3,4],titl:1,titleon:1,titletwo:1,tmp:[0,4],toascii:4,todai:4,togeth:0,toler:0,too:[0,4],tool:[0,1,2,4],top:[0,1,2],total:0,trail:0,transfer:0,transform:[0,4],translat:0,trap:[0,4],travers:0,treat:[0,4],tri:4,trigger:[0,4],trim:0,truncat:[0,4],ttest:4,tthedt:4,tto:4,ttoc:[0,4],ttod:4,ttodat:4,ttt:0,tupl:[0,1,2,4],tupleclassnam:4,tuplefieldnam:4,turn:[0,3,4],twiddl:4,two:[0,1,3,4],txt:[0,1,4],type:[0,1,2,4],typic:[0,2,4],unabl:0,unassign:4,unconvert:0,undefin:0,undelet:0,under:0,underli:0,underscor:[0,1],undetermin:0,undocu:[0,2,4],unfortun:3,unicod:[0,4],uniqu:0,unit:[1,4],unless:0,unlik:0,unlock:0,unnecessari:2,unpackwidth:1,unrecogn:[0,1,2,4],unrel:0,unsaf:4,unsav:[0,2],unsign:4,until:0,unus:0,updat:[0,4],updatestructur:0,upper:[0,1,4],uppercas:[0,4],usa:0,usabl:0,usag:1,use:[0,1,3,4],used:[0,1,4],useful:0,useless:0,user:[0,1,4],uses:[0,1,4],using:[0,1,2,3,4],usual:0,utf8:4,utf:[0,4],util:[0,1,4],valid:[0,1,2,4],valu:[0,1,2,3,4],valueerror:[0,4],varbinari:0,varchar:0,variabl:[0,4],variant:2,variat:[0,4],variou:0,ver:0,veri:[0,1,4],version:[1,3,4],versiona:0,vfp:[0,1,2,4],vfpdata:0,vfpfield:0,vfpindextag:0,vfpstyle:4,vfx:0,via:[0,1,4],violat:1,visibl:0,visual:[2,4],wai:[0,1,4],wait:0,want:[0,1,2,4],warn:[0,2],wast:0,web:4,webservertool:2,week:4,well:[0,3],were:0,western:0,what:[0,1,4],whatev:0,when:[0,1,4],whenev:0,where:[0,4],whether:[0,1,4],which:[0,1,3,4],who:4,whole:0,whose:0,why:[0,1],wide:2,widget:4,width:[0,1,2],wild:4,wildcard:4,win32:[0,1],window:0,wirh:0,wish:0,within:[0,2,3,4],without:[0,1,2,3],won:[0,4],word:0,work:[2,3,4],workbook:[1,2,3],worksheet:[1,2,3],world:0,worri:0,would:[0,4],wrap:[0,4],wrapper:[0,1,3],write:[0,1,2],writecel:3,writecellvalu:2,writerow:3,writerowvalu:2,written:[0,2,3],wrong:[0,1],www:[3,4],xbase:0,xcbtool:0,xcode:0,xdate:4,xdict:4,xheaderlist:1,xls:1,xlsx:[1,2,3],xlware:3,xlwrap:3,xlwsetlicens:3,xlx:2,xml:[0,4],xmltocursor:0,xstr:4,xthevalu:1,xtraceback:4,xvalu:[0,4],ycode:0,ydm:4,year:[0,4],yes:0,yield:4,yior:0,ymd:[0,4],you:[0,1,2,3,4],your:[0,4],yourself:0,ytd:4,yydm:4,yymd:4,yyyi:[0,4],yyyy_mm_dd_hh_mm_ss:4,yyyymmdd:[0,4],yyyymmddhh:[0,4],yyyymmddhhmmss:[0,4],zap:[0,1],zero:[0,2,4]},titles:["<code class=\"docutils literal notranslate\"><span class=\"pre\">CodeBaseTools</span></code>","<code class=\"docutils literal notranslate\"><span class=\"pre\">DBFXLStools2</span></code>","<code class=\"docutils literal notranslate\"><span class=\"pre\">ExcelComTools</span></code>","<code class=\"docutils literal notranslate\"><span class=\"pre\">ExcelTools</span></code>","<code class=\"docutils literal notranslate\"><span class=\"pre\">MPSSBaseTools</span></code>","Welcome to MPSSCommon Modules\u2019s documentation!"],titleterms:{"class":[0,1,2,4],"function":[0,2,4],all:0,codebasetool:0,compat:0,data:0,dbfxlstools2:1,depend:0,document:5,earlier:0,excelcomtool:2,exceltool:3,field:0,foxpro:0,handl:0,higher:0,indic:5,internation:0,mai:0,modul:5,mpssbasetool:4,mpsscommon:5,offici:0,python:0,string:0,support:0,tabl:5,version:0,visual:0,welcom:5,work:0}})