【正文】 dHtmlxGrid使用手冊Phoenixjava 整理于20111102目錄 一、 dhtmlxGrid介紹 71. 自定義XML: 72. 支持多行表頭、表尾展現(xiàn) 73. 移動、添加、刪除列 84. 處理大型數(shù)據(jù)集支持分頁 85. 處理大型數(shù)據(jù)集智能渲染 96. 與數(shù)據(jù)庫交互 97. 擴(kuò)展單元格EXCEL 108. 拆分模式（凍結(jié)欄） 109. 控制于一體的網(wǎng)絡(luò)和樹 11二、 dhtmlxgrid配置部分 12 表格操作API 12 attachEvent(evName , evHandler) 12 attachFooter(values, style) 14 attachHeader(values, style) 15 attachToObject(obj) 16 destructor 17 detachEvent(id) 17 detachFooter(index) 18 表格樣式API 19 detachHeader(index) 19 enableAutoHeight(mode,maxHeight, countFullHeight) 19 enableAutoWidth (mode, max_limit, min_limit) 20 enableCellIds(mode) 21 enableHeaderImages(fl) 21 init 22 setAwaitedRowHeight(height) 22 setCSVDelimiter(str) 22 setColAlign(alStr) 23 setColSorting(sortStr) 23 setColTypes(typeStr) 24 setColVAlign(valStr) 24 setColWidth (ind, value) 24 setDelimiter (delim) 25 setHeader (hdrStr, splitSign, styles) 25 setIconPath (path) 26 setImagePath (path) 26 setInitWidths (wp) 27 setInitWidthsP(wp) 27 setNoHeader(fl) 28 setSkin(name) 28 setStyle (ss_header, ss_grid, ss_selCell, ss_selRow) 29 29三、 數(shù)據(jù)處理部分 30 dhtmlxgrid數(shù)據(jù)加載部分 30 changePage(pageNum) 30 changePageRelative(ind) 30 clearAll(header) 30 clearAndLoad (url, call, type) 30 enableCSVAutoID(mode) 31 enableCSVHeader(mode) 31 enableDistributedParsing(mode, count, time) 31 enablePaging 31 enableSmartRendering (mode,buffer,reserved) 32 getRowAttribute (rId, name) 32 getStateOfView 32 load (url, call, type) 33 loadCSVFile (path,afterCall) 33 loadCSVString(str) 34 parse(data,call,type) 34 preventIECaching(mode) 34 setPagingSkin(name) 34 setPagingTemplates(navigation_template,info_template) 35 setPagingWTMode(navButtons,navLabel,pageSelect,perPageSelect) 35 setRowAttribute(rId, name, value) 35 setUserData (row_id, name, value) 35 startFastOperations 36 stopFastOperations 36 updateFromXML (url, insert_new, del_missed, afterCall) 36 dhtmlxgrid保存數(shù)據(jù)操作 36 enableMathSerialization (mode) 37 serialize 37 serializeToCSV (textmode) 37 setFieldNam (mask) 37 setSerializableColumns (list) 37 setSerializationLevel (userData, selectedAttr, config, changedAttr, onlyChanged, asCDATA) 38四、 Dhtmlxgrid操作 39 dhtmlxgrid行操作 39 addRow (new_id, text, ind) 39 changeRowId (oldRowId, newRowId) 40 copyRowContent (from_row_id, to_row_id) 40 deleteRow(row_id) 40 deleteSelectedRows 40 doesRowExist(row_id) 41 enableAlterCss (cssE, cssU, perLevel, levelUnique) 41 enableMultiline(state) 41 enableRowsHover (mode, cssClass) 42 enableRowspan 42 forEachRow (custom_code) 42 getAllRowIds(separator) 43 getChangedRows (and_added) 43 getCheckedRows (col_ind) 43 getRowId(ind) 43 getRowIndex(row_id) 44 getRowsNum 44 getSelectedRowId 44 lockRow(rowId,mode) 44 moveRow (rowId,mode,targetId,targetGrid) 44 moveRowDown(row_id) 45 moveRowTo(srowId,trowId,mode,dropmode,sourceGrid,targetGrid) 45 moveRowUp(row_id) 45 selectRow (rIndex, fl, preserve, show) 46 selectRowById (row_id, preserve, show, call) 46 setCheckedRows (cInd,v) 46 setRowColor(row_id,color) 46 setRowExcellType (rowId, type) 47 setRowHidden (id, state) 47 setRowId (ind, row_id) 47 setRowTextBold (row_id) 47 setRowTextNormal(row_id) 48 setRowTextStyle (row_id, styleString) 48 showRow (rowID) 48 dhtmlxgrid列操作 48 adjustColumnSize(cind) 48 deleteColumn(ind) 49 enableColumnMove (mode,columns) 49 enableHeaderMenu 49 enableResizing(list) 49 enableTooltips(list) 49 getColIndexById (id) 50 getColType(index) 50 getColTypeById (cID) 50 getColWidth (ind) 50 getColumnId (cin) 51 getColumnLabel (cin, ind) 51 getColumnsNum 51 getFooterLabel (cin, ind) 51 insertColumn(ind,header,type,width,sort,align,valign,reserved,columnColor) 51 isColumnHidden (ind) 52 moveColumn (oldInd,newInd) 52 setColumnColor (clr) 52 setColumnExcellType (colIndex, type) 53 setColumnHidden (ind, state) 53 setColumnId (ind, id) 53 setColumnIds (ids) 53 setColumnLabel (col, label, ind) 53 setColumnMinWidth (width, ind) 54 setColumnsVisibility (list) 54 setFooterLabel (c, label, ind) 54 dhtmlxgrid單元格操作 55 cellById (row_id, col) 55 cellByIndex (row_index, col) 55 cells(row_id, col) 55 cells2 (row_index, col) 55 checkAll(mode) 55 clearChangedState 56 editCell 56 editStop 56 enableColSpan (mode) 56 enableEditEvents (click, dblclick, f2Key) 56 enableMarkedCells (mode) 57 enableMathEditing (mode) 57 forEachCell (rowId, custom_code) 57 getCombo (col_ind) 57 getCustomCombo (id, ind) 57 getMarked 58 getSelectedCellIndex 58 mark (rid,cindex,fl) 58 selectCell (r, cInd, fl, preserve, edit, show) 58 setCellExcellType (rowId, cellIndex, type) 59 setCellTextStyle (row_id, ind, styleString) 59 setColspan (row_id, col_ind, colspan) 59 setDateFormat (mask) 60 setEditable (mode) 60 setMathRound (digits) 60 setNumberFormat (mask, cInd, p_sep, d_sep) 60 setRowspan (rowID,colInd,length) 61 uncheckAll 61 unmarkAll 61 dhtmlxgrid選擇過濾操作 61 clearSelection 61 enableBlockSelection(mode) 62 enableMultiselect (state) 62 forceLabelSelection(mode) 62 selectAll 62 enableStableSorting (mode) 62 getSortingState 63 setCustomSorting (func, col) 63 setSortImgState (state, ind, order, row) 63 sortRows (col, type, order) 64 collectValues (column) 64 filterBy (column, value, preserve) 64 filterByAll 65 findCell (value, c_ind, first) 65 getFilterElement (index) 65 makeFilter (id,column,preserve) 66一、 dhtmlxGrid介紹dhtmlxGrid啟用Ajax的JavaScript網(wǎng)格控制與尖端功能，強(qiáng)大的數(shù)據(jù)綁定，并與大型數(shù)據(jù)集的出色表現(xiàn) 。組件是易于使用，并提供了極大的靈活性，由于其豐富的客戶端API 。dhtmlxGrid支持不同的數(shù)據(jù)源（XML，JSON，CSV，JavaScript數(shù)組，和HTML表格），也可以從自定義的XML格式加載。網(wǎng)格組件可以輕松實(shí)現(xiàn)豐富的單元格內(nèi)編輯和內(nèi)置的好看的DHTML表（通過CSS或預(yù)定義的皮膚管理），過濾、搜索和分組功能。眾多的事件處理程序，可以添加必要的交互性到您的基于網(wǎng)格的接口。智能渲染和分頁支持，讓這個JavaScript的DataGrid有效地開展工作，甚至與龐大的數(shù)據(jù)集。作為一個100％的客戶端的JavaScript解決方案，dhtmlxGrid可以集成與任何服務(wù)器端技術(shù)（PHP，JAVA的Ruby on – Rails等 ）。dhtmlxConnector庫Ajax支持，提供實(shí)時保存和更新服務(wù)器上的網(wǎng)格數(shù)據(jù)的情況下自動重新加載頁面的能力。dhtmlxGrid支持強(qiáng)大的功能，如必要的基于Web的電子表格、合并單元格、拆分模式、網(wǎng)格列拖動和拖放或腳本方法和數(shù)據(jù)復(fù)制到剪貼板（CSV格式） 。AJAX DataG