Mukati
Zuva rechina remarathon 30 Excel inoshanda mumazuva makumi matatu takawana ruzivo rwakadzama nezvenzvimbo yekushanda tichishandisa basa racho INFO (INFORM), senge Excel vhezheni uye recalculation modhi.
Zuva regumi nerimwe remarathon tichazvipira pakudzidza kwebasa racho CHEMA (CELL), iyo inoshuma ruzivo nezve mafomati esero, zvirimo uye nzvimbo. Inoshanda zvakafanana nebasa INFO (INFORM), kureva kuti ine runyorwa rwemhando dzinogona kupinzwa muchiitiko, asi isina imwe chete, asi mbiri nharo.
Saka ngatitarisei ruzivo uye mienzaniso nebasa CHEMA (SERO). Kana iwe uine chimwe chinhu chekuwedzera kune yedu mienzaniso uye ruzivo, ndapota igovera iyo mune zvakataurwa.
Basa rechi11: SERO
basa CHEMA (CELL) inoratidza ruzivo nezve mafomati, zvirimo, uye nzvimbo yesero pane yakapihwa link.
Basa reCELL rinogona kushandiswa sei?
basa CHEMA (CELL) inogona kuzivisa inotevera ruzivo nezve sero:
- Numeric cell format.
- Sheet name.
- Kurongeka kana upamhi hwembiru.
CELL Syntax
basa CHEMA (CELL) ine chirevo chinotevera:
CELL(info_type,reference)
ЯЧЕЙКА(тип_сведений;ссылка)
info_type (info_type) ndeimwe yenharo sarudzo:
- adhiresi (kero) - kureva sero rekutanga mukupokana bhuku (link) mumutauro wemavara.
- ne (column) - nhamba yekoramu yesero munharo bhuku (link).
- сcolor (ruvara) - inodzosa 1 kana iyo sero fomati inopa shanduko yeruvara kune zvakaipa; mune zvimwe zviitiko zvese, 0 (zero) inodzoserwa.
- zviri mukati (zviri mukati) - Kukosha kwesero repamusoro kuruboshwe mune chinongedzo.
- filename (filename) - filename uye yakazara nzira.
- urongwa (format) - nhamba fomati yesero.
- zvikwata (mabhuraketi) - inodzosa 1 kana sero rakaumbwa kuratidza zvakanaka kana nhamba dzese mumaparentheses; mune zvimwe zvese zvinodzosa 0 (zero).
- chivakashure (prefix) - kukosha kwemavara kunoenderana nesero label prefix (inoratidza rudzi rwekugadzirisa).
- chengetedza (kudzivirira) - 0 = sero harina kuvharwa, 1 = rakakiiwa.
- mutsara (string) ndiyo nhamba yemutsara yesero.
- mhando (rudzi) - rudzi rwe data muchitokisi (isina chinhu, zvinyorwa, zvimwe).
- upamhi (hupamhi) - hupamhi hwesero column.
Pitfalls of the CELL function
Pane zvinhu zvishoma zvekutarisa kana uchishandisa basa CHEMA (SERO):
- Kana nharo bhuku (reference) yasiiwa, mhedzisiro inodzoserwa sero yekupedzisira yakagadziridzwa. Kuti uve nechokwadi chekuti mhedzisiro ndiyo chaiyo yaunoda, zvinokurudzirwa kugara uchiratidza chinongedzo. Unogona kureva sero rine basa racho pacharo CHEMA (SERO).
- Paunenge uchishanda nebasa CHEMA (CELL), dzimwe nguva zvinodikanwa kuverengerazve pepa kuti uvandudze mhedzisiro iyo basa rinodzoka.
- Kana senharo info_type (detail_type) kukosha kwakasarudzwa filename (filename) uye Excel workbook haisati yachengetwa, mhedzisiro itambo isina chinhu.
Muenzaniso 1: Fomati Yenhamba Yesero
Nezvinoreva urongwa (format) Unogona kushandisa basa CHEMA (CELL) kuratidza nhamba yefomati yesero. Semuenzaniso, kana cell B7 ine fomati General (General), ipapo mhedzisiro yefomula ichave G:
=CELL("format",C2)
=ЯЧЕЙКА("формат";C2)
Muenzaniso 2: Musoro Wepepa
Nezvinoreva filename ( filename ) basa CHEMA (CELL) icharatidza nzira yefaira, zita refaira uye zita repepa.
=CELL("filename",B2)
=ЯЧЕЙКА("имяфайла";B2)
Iwe unogona kubvisa zita repepa kubva mumhedzisiro yakawanikwa uchishandisa mamwe mabasa. Mune fomula iri pazasi, uchishandisa mabasa MID (PSTR) uye ZIVA (TSVAGA), tsvaga masikweya mabhuraketi uye udzorere mavara makumi matatu nemaviri anoatevera (kureba kwezita reshizha kunogumira kune makumi matatu nerimwe mavara).
=MID(CELL("filename",C3),FIND("]",CELL("filename",C3))+1,32)
=ПСТР(ЯЧЕЙКА("имяфайла";C3);НАЙТИ("]";ЯЧЕЙКА("имяфайла";C3))+1;32)
Muenzaniso 3: Kutsiva iyo info_type nharo (info_type) kubva pane yakaderera pasi
Panzvimbo pekupinda munharo kukosha info_type (detail_type) kuita basa CHEMA (CELL) setambo yemavara, unogona kureva sero rine hunhu hunoshanda. Mumuenzaniso uyu, sero B4 rine rondedzero yekudonhedza pasi, uye pachinzvimbo chekupokana info_type (detail_type) irevo kune iyi cell. Nharo bhuku (link) inoreva sero B2.
Kana kukosha kwasarudzwa chengetedza (chengetedza): Mhedzisiro ndeye 1 kana sero rakakiiwa, kana 0 (zero) kana isina.
=CELL(B4,B2)
=ЯЧЕЙКА(B4;B2)
Kana kukosha kwasarudzwa upamhi (hupamhi), mhedzisiro inoratidza hupamhi hwekoramu mune yakazara fomati. Chiyero chechiyero munyaya iyi hupamhi hwemavara mamwe pahukuru hwefonti.
