OpenHarmonySheet锛屾槸涓€涓熀浜嶤anvas瀹炵幇鐨勯珮鎬ц兘Excel琛ㄦ牸寮曟搸缁勪欢銆傜敱浜庡ぇ閮ㄥ垎鍓嶇椤圭洰鐨勬覆鏌撳眰閮芥槸浣跨敤妗嗘灦鎸夌収甯冨眬妯″瀷鏍戠粨鏋勯€愬眰娓叉煋鐨勶紝鎵€浠ユ暣涓覆鏌撴爲涔熸槸鍜屽竷灞€妯″瀷鏍戜竴涓€瀵瑰簲鐨勩€傚洜姝わ紝鏁翠釜娓叉煋鐨勮妭鐐逛篃寰堝銆傚綋椤圭洰杈冨ぇ鏃讹紝鎬ц兘浼氬彈鍒版洿澶х殑褰卞搷銆備负浜嗘彁楂樻覆鏌撴€ц兘锛屾彁渚涙洿濂界殑缂栬緫浣撻獙锛屽皢DOM鏇挎崲涓篊anvas娓叉煋锛屾柟渚垮紑鍙戣€呮惌寤哄ぇ鍨嬬殑閲嶅墠绔湪绾挎枃妗ｉ」鐩€傚浗鍐呭瀹炵幇绫讳技寮曟搸鐨勫叕鍙稿彧鏈夊嚑瀹讹紝濡傦細鑵捐鏂囨。銆侀噾灞辨枃妗ｃ€佽胺姝屾枃妗ｇ瓑銆傚彧闇€灏?Sheet>缁勪欢瀵煎叆鍒伴」鐩腑锛屽苟鎸夊涓嬫柟寮忎娇鐢ㄥ畠锛?elementname="Sheet"src="../../components/index.hml">鐢熷懡鍛ㄦ湡鍜屼簨浠惰〃琛ㄦ牸鏁版嵁@sheet-show琛ㄦ牸鏄剧ず@sheet-hide琛ㄦ牸闅愯棌@click-cell-start鍗曞厓鏍粿click-cell-end鍗曞厓鏍间箣鍓峜lick缃戞牸琚偣鍑诲悗@click-cell-longpress闀挎寜琛ㄥ崟@change淇敼鍗曞厓鏍兼暟鎹瘮濡傛垜浠彲浠ョ洃鍚緥瀛愪腑鐨勯暱鎸変簨浠讹紝褰撶敤鎴锋寜涓嬮暱鎸夈€傜ず渚嬩唬鐮佸涓嬶細clickCellLongpress(evt){prompt.showDialog({buttons:[{text:'Test',color:'#666666',}],});}浠ヤ笂鎵€鏈夋帴鍙ｉ兘浼氳繑鍥炰竴涓槑缁嗚〃瀵硅薄锛屽寘鍚互涓嬩俊鎭細eltablenodetextareaCellinputboxnodeviewportcellhighlightselectortablecelloperationobjectsheetShow(sheet){this.el=sheet.detail.el;this.textarea=sheet.detail.textarea;this.viewport=sheet.detail銆傝鍙ｏ紱this.table=sheet.detail.table;}API鎺ュ彛娓叉煋寮曟搸灏佽浜嗗父鐢ㄧ殑琛ㄦ牸鏁版嵁鎿嶄綔绛夋帴鍙ｃ€倀his.table.xxx鐢ㄦ潵甯綘鎿嶄綔鍗曞厓鏍肩殑鎵€鏈夋暟鎹拰鏍煎紡锛屼篃寰堟柟渚夸綘鑷畾涔変竴涓姛鑳介綈鍏ㄧ殑宸ュ叿鏍忥細this.viewport.xxx鐢ㄦ潵甯綘鎿嶄綔楂樹寒閫夊尯鐩掑瓙鍦ㄥ崟鍏冩牸鐨勪笂灞傘€倀his.textarea.xxxthis.textarea鏄缚钂欏師鐢?textarea>缁勪欢鐨勫皝瑁呮帴鍙ｏ紝鐢ㄦ潵甯姪浣犲湪鐣岄潰鎺ュ彈鐢ㄦ埛杈撳叆锛岀劧鍚庨厤鍚坱his.table.xx娓叉煋鏁版嵁灞傜殑鏁版嵁鍒拌〃鏍兼覆鏌撳眰銆傝繖閲岀殑杈撳叆闇€瑕佺湡鏈鸿皟璇曪紝鍥犱负鐪熸満鑷甫杈撳叆娉曪紝瀹為檯娴嬭瘯Previewer鏄棤鏁堢殑銆傚垵濮嬪寲琛ㄦ牸娓叉煋灞俰mportTablefrom"./sheet/";this.el=this.$refs.canvas;this.table=Table.create(this.el,850,800).render();鍒濆鍖栭€夋嫨灞倂iewport鐢ㄤ簬鍒涘缓鍜屾帶鍒跺崟鍏冩牸楂樹寒閫夊彇妗嗭紝缁樺埗鍦ㄥ崟鍏冩牸涓婂眰鍜岃緭鍏ユ涓嬪眰锛屾敮鎸佸垪閫夈€佽閫夊拰鑼冨洿閫夋嫨銆倀his.viewport=newViewport(this.table).render();鍒濆鍖栬〃鏍兼暟鎹湪浠讳綍鎯呭喌涓嬶紝鎮ㄩ兘鍙互浣跨敤.cell鏂规硶鍏ㄥ眬鏇存柊浠讳綍浣嶇疆鐨勬暟鎹€倀his.table.cell((ri,ci)=>`${ri}-${ci}`).render();鍚堝苟鍗曞厓鏍兼槸琛ㄦ牸涓父鐢ㄧ殑鏂规硶锛屾垜浠彲浠ュ灞€閮ㄥ崟鍏冩牸杩涜鍚堝苟鎿嶄綔銆倀his.table.merges(["G9:H11","B9:D11"]).render();璁剧疆鍒楄〃鏍囬鍙互璁剧疆鎮ㄧ殑鍒楄〃鏍囬鍙婂叾楂樺害銆倀his.table.colHeader({height:50,rows:2}).render();鍐荤粨鍖哄煙鍦ㄦ煇浜涙儏鍐典笅锛屾垜浠湪鏌ユ壘琛ㄦ牸鐨勬椂鍊欙紝鍙兘闇€瑕佸浐瀹氬崟鍏冩牸鐨勬煇浜涜鍜屾煇浜涘垪锛屼互鎻愰珮琛ㄦ牸鐨勫彲璇绘€э紝杩欐椂鍊?freeze灏卞彲浠ユ淳涓婄敤鍦轰簡銆倀his.table.freeze("C6").render();婊氬姩鍖轰竴鑸笌鍐荤粨鍖洪厤鍚堜娇鐢紝鍙互婊氬姩鍐荤粨鍖轰互澶栫殑閫変腑鍖哄煙銆倀his.table.scrollRows(2).scrollCols(1).render();璁剧疆閫夋嫨鍖哄煙鏃舵棤闇€鑺辨椂闂存搷浣滃崟鍏冩牸閫夋嫨妗嗐€傞€氬父锛岄€夋嫨妗嗘帴鍙楄缁樺埗鐨勫崟鍏冩牸鐨勭浉瀵逛綅缃€傚父閲忚寖鍥?this.viewport.range(evt.changedTouches[0].localX,evt.changedTouches[0].localY);this.table.selection(range);this.viewport.render(this.table.$draw);Cell,RowandColumnInterfaceCell,RowandColumn琛ㄦ牸缁撴瀯濡備笅锛氱浜屽垪鏁版嵁涓?848锛岄鑹蹭负绾㈣壊锛歵his.table.cell((ri,ci)=>{if(ri===2&&ci===2){return{text:"8848",style:{color:"red",},};}returnthis.sheet?.[ri]?.[ci]||"";}).render();褰撶劧锛屼綘鍙互浠旂粏瀹氬埗姣忎釜cell鐨勬暟鎹紝杩欎簺鏁版嵁鍙互鏉ヨ嚜浣犵殑鍚庣鏈嶅姟鍣紝涔熷彲浠ユ潵鑷鎴风鐨勮緭鍏ワ紝閰嶅悎瀹㈡埛绔拰鏈嶅姟绔殑瀛樺偍鑳藉姏锛屽皢鏁版嵁鎸佷箙鍖栧瓨鍌ㄣ€倀his.sheet=[["馃挘","馃挘","馃挘"],["馃挘","馃檳","馃挘"],["馃挘","馃挘","馃挘"],];杩?table.cell((ri,ci)=>this.sheet?.[ri]?.[ci]||"").render();濡傛灉浣犳兂鎿嶄綔鏇村鍗曞厓鏍肩殑鏁版嵁鍜屾牱寮忋€佽鍜屽垪鐨勭粨鏋勶紝姣斿琛岄珮銆佸垪楂樸€佸崟鍏冩牸杈规銆佸瓧浣撳竷灞€銆佸唴澶栬竟璺濄€佷笅鍒掔嚎銆佽儗鏅壊鍜屾棆杞搴︾瓑銆傝鎯呰鐪嬶紝璇峰弬鑰冨涓嬫帴鍙ｏ紝鏀寔鍚勭涓板瘜澶氭牱鐨勫彉鍖栵細{row:{height,hide,autoFit},col:{width,hide,autoFit},cell:{text,style:{border,fontSize,fontName,绮椾綋锛屾枩浣擄紝棰滆壊锛宐gcolor锛屽榻愶紝valign锛屼笅鍒掔嚎锛屽垹闄わ紝鏃嬭浆锛宼extwrap锛屽～鍏咃紝}锛岀被鍨嬶細鏂囨湰|鎸夐挳|閾炬帴|澶嶉€夋|鏀堕煶鏈簗娓呭崟|杩涘睍|鍥剧墖|鍥剧墖鎸夐挳|date,}}鍏朵粬鎺ュ彛闄ゆ涔嬪杩樻彁渚涘叾浠栧畬鏁寸殑琛ㄦ牸鎿嶄綔鎺ュ彛绛夊緟浣犵殑鎺㈢储:scrollRowsscrollColscellrowcellStylefreezemergescolHeaderrenderselectiononClickonSelectedfocusselectionStyleheaderCellStylefreezeLineStyleheaderLineStyletargetscrollColsscrollRowsstartColstartRow鏁堟灉婕旂ず鎴戜滑Makesomedemonstrationsoftheabovecommoninterfaces,runOpenHarmonySheet,pressandholdanycelltopopupadialogbox骞剁偣鍑诲搴旂殑閫夐」锛屽彲浠ユ煡鐪嬪父鐢ㄦ帴鍙ｇ殑杩愯缁撴灉銆傛湰婕旂ず浠呬緵鍙傝€冦€傛洿澶氬疄闄呬娇鐢ㄥ満鏅紝璇峰弬鑰冩枃妗ｅ疄鐜帮細瀹炵幇鏂规璇村疄鐜版柟妗堜箣鍓嶏紝鍏堣璇磋〃鏍兼覆鏌撳埌搴曟湁澶氬鏉傘€備竴鑸潵璇达紝琛ㄦ牸娓叉煋鏈変袱绉嶅疄鐜版柟妗堬細DOM娓叉煋銆傜敾甯冩覆鏌撱€備笟鐣岀煡鍚嶇殑handsontable寮€婧愬簱灏辨槸鍩轰簬DOM鏉ュ疄鐜版覆鏌撶殑銆傜浉鍚岀殑娓叉煋缁撴灉闇€瑕佺簿蹇冭璁″拰鏋勫缓DOM鑺傜偣锛屼絾寰堟槑鏄綝OM娓叉煋10涓囨垨100涓囦釜cell浼氶€犳垚杈冨ぇ鐨勬€ц兘闂銆傛墍浠ョ幇鍦ㄥ緢澶氱嚎涓婄殑琛ㄦ牸瀹炵幇閮芥槸鍩轰簬Canvas鍙犲姞DOM锛屼絾鏄娇鐢–anvas瀹炵幇闇€瑕佽€冭檻鍙鍖哄煙銆佹粴鍔ㄦ搷浣溿€乧anvas灞傜骇鍏崇郴锛屼互鍙奀anvas鏈韩闈复鐨勪竴浜涙€ц兘闂锛屽寘鎷浣曠洿鎺ユ樉绀篊anvas绛?,瀵瑰紑鍙戞湁鏇撮珮鐨勮姹傦紝浣嗘槸涓轰簡鏇村ソ鐨勭敤鎴蜂綋楠岋紝鏇村€惧悜浜嶤anvas娓叉煋鐨勫疄鐜般€傛垜浠寜绫诲埆鏀堕泦瑙嗗浘鍏冪礌锛岀劧鍚庢寜绫诲埆娓叉煋瀹冧滑锛屼互鍑忓皯Canvas缁樺浘寮曟搸鍒囨崲鐘舵€佹満鐨勬鏁帮紝鍑忓皯鎬ц兘鎹熷け锛屼紭鍖栨覆鏌撴椂闂淬€傛暣涓牳蹇冨紩鎿庝唬鐮佹帶鍒跺湪1500琛屽乏鍙筹紝鍙﹀澧炲姞浜?00琛宒emo浠ｇ爜锛屾柟渚垮ぇ瀹剁悊瑙ｉ槄璇诲拰杩涜浜屾寮€鍙戙€傞《灞傗啈DOM瀹瑰櫒鎻掍欢杈撳叆妗嗙瓑鈫慍anvas楂樹寒閫夋嫨鍖哄煙绛夆啈Canvas鍐呭銆佸瓧浣撱€佽儗鏅鑹茬瓑搴曞眰銆傛湰椤圭洰鐨勫紑鍙戝熀浜嶰penHarmony涓嬬殑JavaScriptUI妗嗘灦銆傝繍琛岀幆澧冭鍙傝€僌penHarmony椤圭洰閰嶇疆鏂规硶杩涜椤圭洰閰嶇疆鍜岃繍琛屻€傚鏋滄偍涓嶇啛鎮変娇鐢∣penHarmony杩涜JavaScript寮€鍙戯紝璇峰弬闃呭畼鏂规枃妗ｃ€傝繍琛屽苟涓嬭浇OpenHarmonySheet宸ョ▼锛屽皢宸ョ▼瀵煎叆DevEcoStudio杩涜缂栬瘧銆佹瀯寤恒€佽繍琛屽拰璋冭瘯銆傜紪璇戞瀯寤猴紝鐢熸垚HAP搴旂敤瀹夎鍖咃紝鐢熸垚HAP搴旂敤瀹夎鍖呫€傚畨瑁呰繍琛屽悗锛屾偍鍙互鏌ョ湅搴旂敤瀹炰緥鍦ㄨ澶囦笂鐨勮繍琛屾晥鏋滐紝骞惰繘琛岀浉鍏宠皟璇曘€傛劅璋Spreadsheet@MyLiangTencentDoc@AlloyTeam鏈€鍚庢潵鍐欎釜鎬荤粨鍚с€備笉鍠滄璇疯交鍠枫€傛垜鎯崇綉涓婁篃鏈夌被浼肩殑璁ㄨ銆備腑鍥借澶氫箙鎵嶈兘寮€鍙戝嚭绫讳技Excel鐨勬浛浠ｅ搧锛屽苟涓斿姛鑳借鐩朎xcel95%鐨勫姛鑳斤紵杞欢锛燂紝杩欐潯璺緢鍧庡澐锛屼篃寰堣壈闅俱€傚紩鐢ㄤ竴浜涘ぇV鏈€璧炵殑鍥炵瓟锛氬井杞疆瀛愬摜锛氬仛涓嶅嚭鏉ワ紝涓滆タ澶浜嗭紝鍐欓渶姹傛枃妗ｈ濂藉嚑骞淬€傛潵鑷狹icrosoft鐨凚elleve锛氱▼搴忓憳鍙互鍏堝皾璇曞疄鐜皉ecalc锛堟牴鎹叕寮忔洿鏂板崟鍏冩牸鐨勫€硷級锛岄毦搴﹀氨鐭ラ亾浜嗐€傛枃妗ｉ」鐩綔涓哄浗鍐呮渶澶嶆潅鐨凜++椤圭洰锛岀粷涓嶆槸铏氬悕銆傚井杞€墿灏忓紵锛氫綔涓轰竴鍚岴xcel宸ョ▼甯堬紝鎴戣鐪熷洖绛斾竴涓紝涓嶄細锛屽洜涓烘垜浠殧澹佺粍宸茬粡璇曡繃浜嗭紝涓ゅ勾瑕嗙洊浜?0%宸﹀彸銆侷BM鐨凜asparCui锛氬鏋滄槸寮€鍙戝父鐢ㄧ殑Excel鍔熻兘锛學PS宸茬粡鏄緢濂界殑鏇夸唬鍝佷簡銆傝€屼笖寰蒋鍜岄噾灞变篃鏈変氦鍙夋巿鏉冦€傝€孍xcel锛屽彿绉版彁95%鐨勫姛鑳斤紝鍗村凡缁忓仛鍒颁簡杩欑浜嬫儏銆?.鎴戣繕鏄湁鐐逛綆浼颁簡Excel銆傚氨甯姪鏂囨。閲忚€岃█锛學PS杩樺緱涓嬩竴鐣姛澶€備腑鍥界瀛︽妧鏈ぇ瀛︽€濋洩锛氬鏋滃井杞涪澶变簡Excel鐨勬簮浠ｇ爜锛屾槸鏃犳硶鎭㈠鐨勩€傞偅灏辨槸涓栫晫鏈棩锛屾垜浠竴璧锋鍘汇€傚氨绠楀井杞妸Excel鍥㈤槦鐨勫師鐝汉椹甫鍥炴潵锛岀鑱屽啀灏变笟锛屾棭閫濆娲伙紝鍐嶉噸鏂板紑鍙慐xcel銆備粬涔熸病鏈夊姙娉曚繚璇丒xcel鐨勫姛鑳戒細鎭㈠鍒?5%锛屼篃娌℃湁鍔炴硶淇濊瘉95%鐨凟xcel鏂囦欢閮借兘姝ｅ父鎵撳紑銆侭bcallen锛氫笉鍙兘锛屽井杞嚜宸卞仛涓嶅埌銆備笉绠″埆浜烘€庝箞璇达紝杩欐潯璺垜浠竴瀹氳璧帮紝鎴戜滑涔熶竴瀹氳璧板ソ姣忎竴姝ワ紝姣忎竴涓潕锛屾瘡涓€涓潙锛岄兘鍊煎緱鐣欎笅涓€涓腑鍥借冻杩癸紝浠庢妧鏈拰鐩爣鏉ョ湅锛屾垜浠瀹炵幇鐨勶紝涓嶆槸宸茬粡鍥哄寲鐨勬湰鍦颁釜浜烘枃妗ｅ競鍦哄拰鐢ㄦ埛涔犳儻锛屼絾鍦ㄧ嚎鍗忎綔鏂囨。銆傛湰鍦版枃妗ｅ彧闇€瑕佽€冭檻涓汉锛屼笉闇€瑕佽€冭檻澶氫汉銆傚崗鍚屽満鏅紝鍙渶瑕佽€冭檻绂荤嚎锛屼笉闇€瑕佽€冭檻鍦ㄧ嚎鍦烘櫙锛屽彧闇€瑕佽€冭檻瀹㈡埛绔満鏅紝涓嶉渶瑕佽€冭檻鏈嶅姟绔満鏅瓑绛夆€︹€﹀湪绾挎枃妗ｇ殑瀹夸富鐜鏄祻瑙堝櫒锛屽湪鏈湴鏂囨。鐨勮儗鍚庢槸绯荤粺锛屽湪涓浗浠讳綍鍦ㄧ嚎鏂囨。鐨勮儗鍚庨兘娌℃湁鍍忓熀浜嶨oogleChrome鐨凣oogleDocs鐨勬敮鎸侊紝涔熸病鏈夊熀浜嶮icrosoftWindows绯荤粺鐨凪icrosoftOffice鏀寔銆傚叾瀹烇紝鍩轰簬杩欎竴鍒囷紝鎴戜滑涔熷簲璇ユ竻閱掑湴璁よ瘑鍒帮紝瑕佸仛鍒?5%鏄緢闅剧殑銆傝鐭ラ亾璋锋瓕鍗佸嚑骞存潵鍦ㄦ祻瑙堝櫒鐨勭爺鍙戜笂鎶曞叆浜嗘暟涓囦汉銆佹暟鐧句嚎锛屾洿涓嶇敤璇村井杞殑Windows绯荤粺浜嗐€傛垜浠湪涓浗鍙兘娌℃湁杩欐牱鐨勬妧鏈儗鏅紝浣嗘垜浠粛鍦ㄥ姫鍔涚缉灏忓樊璺濓紝椤藉己杩借刀銆傛垨璁告垜浠湭蹇呯敓鍦ㄦ渶濂界殑鍥藉锛屼絾鎴戜滑鍙互鍔姏璁╁畠鎴愪负鏈€濂界殑鍥藉銆傚笇鏈涢缚钂欒兘缁欎綘杩欎竴鍒囷紝鐪熷績甯屾湜浣犺兘鎴愬姛锛佹€绘湁椋庢氮鐮存氮鐨勬椂鍊欙紝鎸備簯鐩磋埅澶ф捣
