parkerCAD1 发表于 2022-7-7 14:20:12

Excel中的文本属性

大家好,
 
 
我是新来的,如果放错地方,我深表歉意!希望你们都好。
 
 
我是一名使用AutoCAD的电气工程师,有一个问题。
 
 
我们经常做火灾报警设备布局,每个布局上可能有2-300个设备。当我们在一个项目上达到“安装”状态时,所有这些设备都有一个回路号和其他属性。
 
 
是否可以在Excel中接收这些属性,并将其与特定的块/符号相关联?
 
 
如果需要进一步澄清,请告诉我,再次感谢!
 
 

steven-g 发表于 2022-7-7 14:53:02

我想答案是肯定的,但你能举一个例子说明你拥有什么以及你想要实现什么吗?从excel到Autocad或Autocad到excel都可以,但这取决于你的设置方式

parkerCAD1 发表于 2022-7-7 15:05:53

谢谢你的回复,史蒂文。
 
 
典型布局如下:
 
 
https://www.cadtutor.net/forum/image/png;base64,IVBORW0KGGOAAAANSUHEUGAAATYAAADGCAYAAACJREOVAAAAAAAAXnsr0iars4c6qaaarnqu1baacxjwv8yquaaaajcehzcwaadsmaa7dacdvqgqaaabcusurbhhe7d17cbvngfwgkekpaesiakgfdi8n4g8aeigaylkf5qewhhq6swfv2fra8gqs26t1py6a+sowiigyoeoorigdkikvyrcea7kacuerqjlwked6z/d3umizbo7n3nv5+qF/ldnvJMLmdb58+7PBBFxtpkmkytlzpw5i+fOnXP3UJAlJCRIy5Yt5ciRI+4eotpXz/1KRGQNBhsRWYfBRkTWYbARkXUYbERkHQYbEVmHwUZE1mGwEZF1GGxEZB0GGxFZh8FGRNZhsBGRdRhsRGQdBhsRWYfBRkTW4XpskWpoqoOp+rpvm2wmfjz1sresxpxy6gcov9tqyxrdsfdj6kvnggyrgmsqt6k9uluztu0lmxpt6zeyktlzu39g6mtulvzvuz9q6klumuvbjtvzylnsu5orvk/WVl3mepZad+nvpp8zx2oxjn3vlpx5ywctynozu7yv/g8qhambpbav9naokpler7ucnnjvbaf0ffprzi4ceyhzy1vdpqsz+oupkpfdh3f3 Ozkcrp1zoqsexxngbpuayuqxbcynbfksqqtm9trvhb1edexlu0+Z+kW34haDrRbk5eXJkCFDJDU11CS744475K677pJmzZrp9hXQywmNTX1s6k7d+m0/uq0ljsxp8xfrrbqnvq9bw8elaMHDtTtq1xyvyLUngu9jOfWGjDYfHbnnXdqgOEGSr9+/aRDhw5yyy23yNmzZ2XQoEHakV4O4VViCndWPzF1lymiCDRq1EiGDx+ux1taWpp07dpV+vfvly1atjb69erjibej6egoxtf2tks/ULMBg8xnuAiYmJsrmzZtl3bp10qBBA9m1a5ds2rRJvv/+exkwyid7tgn3onjmrtdsiiobjr3v37ljqqcbr1qzrrwi0lvu2yffi6ely0003ue820ef 3L6Ae1y1rmnh8tn79eg23kvomskdonbtlhksdkcsr0yqhmuqvmuknavijjrcpp/xQ8vPzZerUqVK/fn25dOmSJCeH7nCVlpZKRkaGvlZDTP1j6KVNGGw+cxhvq9elfpnz5devXpJTk6OXLgQGiR0+fJlPdDKpZv6d1P/qltevti/f78sxlhqv76a+1Xw/ghciogdrvqzw5b0wtc720cypnz3369jfhw4bpv7tucbch6d+zZ0/ta9u2bZv7TgMn0b+zqrfhxuwgigy6pkaohkn9u9nz2xpping43hio33367vt63b5/7bgPj6B8ytUC3rMFg8xn604qLi/wgrlypw4fo3zmwrdulz999pmetcth/BBulGJQ/t2mCkwRReDixYvan5uZmakttS+++EK+++47vRRFyC1fvtx9p6uR+3wykcvcrxy0rh8vujkhg03dwmnfjva2qyozd24yvwakf2ayqvjeoc3opkjlamxqwur7alktfwcefc+kfz53n2o02kllzzgmvjw4wmqhjyRLQReauetnwnrkfBsutbpsfzrtfawr9gxupkkc44s7pft0iuj6mhcq4thb5g3mretaujsyn6lzc4uoekclt8ptnhxnnm8suxuv+h25Ziat71LJsU4+a+qtu1dxgU/9m6lfdsgaDLVIYspEXehmW/zNl4XpYHgZbLcNvMGZO4SYAfpMxTLJiSwvb2O/t81po+hvyhv7gu/4ddmgwua1isnuo/fxowbjiytqyp5crhmd+4h4aviaap6mjqxlu8jmjmxljmjmxl8 54c7clpkscuxynguwj40odmhw98ang8sxwmjvqpusxrxyvt70ttzyyco6d/NEMVj8y6++lkfdh0p6rrs/H6n/HnZn2X1F6t16tXcuXNl7dq18uSTT+rfsQlabL5VkIZ7jB071lmwYEH59s033+wsWrTI+fjjj53x48frvry8PN1euHChc/fddzu9e/d21q9f73z00UeOORCdPn366PvmzZvntG/FVX72VIC7LE7NWDAAKE0TNRJS0VT7DMZZUVV/66069fP+FAGQN6LC5DUTSNM2AM3JWYGFNZP1O//79neLiYn3/XKT9E+FONXKUE225ZLY5C76ENPV/XVXHOXXRABNM3A6IODGEUDF198UUDD1M3DTS2FNZP3LUEEK1WRN27DTDT1P0AED+zYUR577DEdBW4OMJ32gnl9GEBJdCMw5xjdPd7c4y5dusisWbN0svuSJUvk008/1RU93NZTV2M4EDBG/Lss8/KiRMn9NjDskbmZCoPP/ywzlS45557yueT2oDBFgGM7MakYsBMA1wWvPDCCxpgb731lrzxxhsadO+884688 SORSMHDBHK9ERTOTPCMXGEVEMXOWLFILLBGNWLZK8+dDY43Qj+lNbs/NzdUpVN7iC4D/VLHYQHOVCEXHFSZTTZ8T48AN0684UWKGJC0YBBHCEVP2HRPZWKX9P166DNG6MFSRDCBH2RJSQ0VNXMBQ2DVCDSJP06EVNCBPDB24CYABDX379PVU3BRPZRLMFH/88cf1quD+++3/8UV577TWZPN26HL9OVE Eejksirabile1ptzhwgrtyef72glxpi+FXvoDd1gwX81bTcBmWKEUE97ff/99xtvh2rrepmjs8o5c+zokw0bhkddjphhh31udyh02mixwb07drjfsbtd95tvpfdhw65e+yAS3qeudeyjx9gsjtonfheebzpgxq/bs2apdh2ibbd26vzyuxspt27bhhu9nzpypvxjyrmsnl7eirhsnyhktrpcm9du8lwhscfxhwyqvpjshi0amcmzlpns2tlnvfec8wlggmurbuj1gsxvsccoi65jnubbv27dnvmgdqrvq266nuh87dly5x7y/34s0dvjsk49h84hx6vx5trbzhrthbpjyfinaksxg8fgrnzhsbgrdrghsrgqdbsrwyfbrkybarkxuxu Yberkhqybevmhwuze1mgwezf1ggxezb0ggxfzh8fgrnzhsbgrdrhsrgqdbhswyfbrktwybarkxuyberkhqybevmhwuze1mgwezf1ggxezb0ggxfzh8fgrnzhsbgrdrhsrgqdBHSRWYFBRKTWYBARKXUYBERKHYBEVMHWUZE1MGWEZF1GGXEZB0GGXFZH8FGRNZHSBGRDRHSSRGQDBSRWYFBRKTWYBARKXUYBERKHYBEVMHWUZE1MGWEZF1GGXEZB0GGXFDU2JIOQSNPVZ5S2LWBNM7T7YX2AJONINGJSQ1NRUADGIHBRS2VIL+86fPy+NGJVY3X7GGX7GGXEADE4CWPJZYUNJWCBZWLPKTIMTNN5MSJE3L48GH9WLJSIMVLZE7FIH0MNQKASKYKYKYK SLG2JXBHWQY4EPAP1/PhxDbZLly657zRBUS++oolbhracdw00hbgruvfcdiqw6djshgvfa7e/asndt3zt1rfwybuybudwurrhsrarfadbhtracductmczckegdyIY3KTNFSNBShugmfgzlggtdq8ddyii2e6fizxbcnugmfgzdevsvytabhsbfzyptchirf0ajaw2iksljsxpzajjoo6e4gcwevkkkk9ltnvlqhqyybkaw3bcdjyisgvadmya21wsdjcuaz99ddfa9m/bgw2iguhxyzcyrfgw1n38uxl7tbfhromqt1cia6tev73v/Wjy1/hkangni6782iynd10f342ybh2rtlichnrdhg0d20yvs5js07rpuzl58qs7h2obwmv4v ur87dszdezmmiwvtpo0ufxfhxe9nqnp6uq//Svyfxg/VDwhJ/EL4OXIaZzI8oKK0tJTBVkf8PCaoevhZ4/j2+8oJDQKEZlwEm6mY/VfiTI+12p0mnjyb601tici7bXTNW9W5VH77IC5C7HUJIJ7JSQLJCVSIW3LRACVZS8WG56XEORUQUDONYOTJKYFHBLDHET7PU6XE/wBCjX0+RPaK+T42XDB6DDSAD4BF3R3C2SEE8V0HXTCYM8HTSYNJWD60CJRUARM5GGESAKZEVIOWWMGBD/xr66jh2jch+GQK2XOYSBUDGG2RIQZ1BSQIOALESGE8HOACX0YDRDAZPTGQAN5PYYKI2GZ1SHHGNBRBQC1GYBQ40OUKWMNOUB2ZF2ZF WMNSkyktgyakqecr1smckf9dwangmiq+jiac5djyhienwpzmxmhvr79uxzd09oahtcdixgjugzygqafxjygg5omnwwgjycwkr2wd6ms+nmaikqskwgy4x09lsdE02r9gqI6LqxHSwWQ8N0NGmwu3pxKMb/SSUPGIKZDYOIN1AOMVUPZD1V6K+mqrpfwk+WASZKABPPDDUT2FWVC/DzTH1z6b4yVKA8fCPtkT3azgqf3pNTX1qaowpf5+VSXRXGGZXDPEC0MTUJ6Z6MDQKHUTBXWCLIWPHDGJK0AZIMHTPUX+rdd999up2fn18+3KQEQEVIYP3ES43RR4YUUAY2GJKXLYPKSMYANEIBSME4RQQ 61YSUL2798VI0EODN/PQQI1NFUX1IIWRZLFVRPJ+nRo4fWzp075fDhw+WZKNBV3I0NGZAUDU3AUE82CK2TMTVAT4JIXWCLIUEPHPXFIXDLQ1ATZOLEIFRAASB92XVBBXACOWQCD1DL4NONWY2GJKamipFRUXyySefyPHjx6Vv3746daysrEwSExN1FgZaceW+MvU7UxyvRnQFBlsMwc2BsWPHykMPPaQts+3bt0ubNm1k9OjRehNh69atcuTIEffdRpqp+aYeMlWGHUTkwfmeFY3KNjW+0j5THTp0KH+dlzxldoruycnmzlipvqttkw6r/F9ykzhz19NVX4vixWgYostBv3www/uk9fl04kcajlx4os7pxjvameh4ovzqu9ytrqdhybly1o9nydybx7jrgdygdhy OGNHE8KQTHJ+c+UA+6OPX0ZXK6UAW68FRKKPPQBQGH9OVS1D7EPN039TSAWERKMTMJCTX8ZBPJ1Q+Zom9oseklev2Gwezf1sgjos6gxvjfwdiezm2fqvcnvcytwybtlyhtp1KmTfPvtt7pv+vTpMmHCBB3XhmlW+DsY04ZJ8gcOHNDnQTzzzDOSm5ur38txeJ4iAh33warbMkFkMshxunXrpttDhgxxNm3a5EyaNMkpLi52xo0b54wZM8ZZs2aNM3XqVN2Xn5/vfbuvotnmzhdmzjj71+6dkze/ZsfZ8Jxqv+d1isibvnuujpkmdonvkll8orqijgqcvfsfiwqb588egzphmyjbo1sp566imzp3++WLM3BP1S3LHR55ZIPMNXRL1LX44D+r2Igo7BFmV4cj20bdtWB+LCHG0BJCNRZP06CB79UZRFYWFHBON9957R84DFF7552XJKIX697CSUVZWLV53OQCL+2DzngSPCeLxJCEhQf/dXbp0kY4dO8qhQ4e0xYbXr776qrbmEFhz587VfX/4wx9k5cqVkpGRIZ9//rlOlC8pKRFzSSqbN2/WgMT3o/iC9fewiktycri3xqkqcXdXFE9/x7pkobc8j8edjpbfsfjfjenazz3t1/jshqbhsnu3bp10xu9z2apeuz4tiuq7s3btxg+/dd9+Vl19+WXbt2qXh2L9/f725sGXLFlm4cKF+p4ofzzs312mxx7f3phvp0pva81rzmr 9Swismqeyvfpnx4emp8libiluaea8oekxnrrp02aljfubupyxhuiwneiorzbcdugs7rj6xqxxswoymodxmd4yi0zko6i+EgwHAIBhvFGwQbTtDekJ+k0jldscb8kukd4xfy5elt4dp1xwsw4cyfoeki4wxwhqybxavrBVtl6JJAF0zFu+LUTZI7EYBQY8ZM1EVNGWK1OQDAFt+J3ASX11XURAYCZAE2O2EWYICBPEJXCFDLDQXEYWES01HHR9THCQHCTWVBX8POHRLQ9HTV1RT3Y2FIJCG/D7dqiGmze3U+GGLF4G5VI2QW4CPAWEOGLLH4EG6NT5/W3YCKIVQW4EYC8WCMNALIcWNROA45ZQKASGUMMGQ0WBIALIOEWGQOUXWDDNDH8EEKD4WQYLCFRLXMAJAJ5 8g/mU+NylDcRohRs3g+fwUbkH281EPazRSnYcBnqraNGRP5BsCUlJblbwRWVYEM/QFXLDxFRZNDPhm4eXBUFWVSCDWcUXoYS+c9bzgjhfmr1hmxy7rbfhtr7ucjad09qzzgqzob5khYxOr4h4/ftzdEzmcnbA0+JEjR9w98ctbHRXhXxPoOK6tMYG4rAn6pc214POK5OeD47a0tFTXWvMLfsfS09N9/R2rbZH+HCtLyM7OrtNgw2UofuDoC/alfh4xf1t/nLXFSwFjQ+5pjmy8hmtkiryfshixygdt09wfd2mm4wzxdeow4wowmrpgkrhp5ytw+r3DuffFQ04fvG769fPISaXBg+y9u3b62X6zz//7O65Mbghg8fv+b08uz Jnxawdylnbvevfuru8my9dkzhccwmkte/r9EJWbB3RtOMOG0+r0znR+D86M9xZwbWNL1h9+h2cmnksgeff4ohfr0dhylik7ybgxqr0ddal4aj0etmdis4i0dxunqfhqmnsvgchqp1iukmgabzrbsvBy1XDtT/COS3QYC0KBNSFKGWYZLUB9GCFMMGMEQSSMSTLTTTGM6QVSNLMDGS442D47API2GM1FPT68OOV5MQAN58U1MIS0SW2CYE0DUYHUCWM9TUOCT9FJUHGULS9TPTWQLHUYBBYNQJPX7FRTVQZ+M9T6H8RWQ47NGSHTFT6G/DU/bJbrhZlJubq/N6AYSW4DUHQIS1/2KUPvM1N+Z+SWURD2YDDALEHGLPU9EGOTJKYQYMMGSX5+VNTVN 3L2GDRSMO0ANKQFDH8RW4BHBUAHC66QPOZAAU11MGWX3MHHSLSNAX2Y52CT7CMVIXYTL/vz5UlhYqNPqli9fLh988IEuB9S5c2d9j8KqVtjE5WeF3bZhsAUAWm7nz59nuFnol19+kR07dsGTTZWHAWCO1G3W5GZV27FVYMDNC+/mOqhW9ZisAUE+9ZSHPGK27ZTK7FFFLSXKR0ZZOYULJTOZW0ZGRNLYEWBNZE0EUBMDGCXLSSZCRK0KSYDUKNF/GCH3JGAENZS6EEVLCALWKUV69E0Q9FP1249KUVNLFBWD5UPTM/ADUWYVBFJAINWWSUTL07TMWHMFQ5CG/eEf8Qqf5d69e6V169Y6R3j9+VXAGVOA7J69EORVZ/GODZsTjS1DDtclq0nilM2l0iNIe3atdPVcA8dOuTuqV0446OD2WvBYeYClrnGLwz+hwjdntx5kkudx0ophj2kokcbpgpcgpn2xqkalwppjrppvab2qvbir8z9sdt501h+AfumEYBBpTj2OPS4OQLDObF5Que8IXnJaA/BlOycKDhgSBoyeGAI4tUbMrMM/V7U5gYb9HaCQw2KocAQx8cwg0hh7A7fPgwgy3WIJjC/Uiq+nt/NDU+9niwdda6jrtceakag9jmycw1pgpxtvkrf+hwmcmcmvbca+thhT131sFJmo9LH9vSmEWzi/urje9pgpcinayohfwwmthjdyisvuk2c/hmarfrnrhrgqdbhsrwybrktwarkxuyberkhqybevmhwuze1mgwezf1ggxezb0gg1geupj5ldldjjjjjjgzbj GGP84VZTGCK5OFMGS3ACPhttpJMKXNP6UI5TYERYLGGZXJS8VT1SBDLBWYEVM1J49E/RPAN5GSMUYBLT8WEOEU3FV5RP1MYZ9BEQREPV0AXHP8IEVMHWUZE1MgZFGXEZB0GGxFZRuT/AWuUj+vXNCsPAAAAAElFTkSuQmCC
 
 
每个设备都需要有一个单独的书面参考,即LOOP1、2、3等。
 
 
这些细节是以承包商的excel表格的形式发给我们的,所以我可以从电子表格中为每个设备分配一个单独的参考,而不是单独键入吗?

steven-g 发表于 2022-7-7 15:28:16

您的图像没有显示,您可以重试或发布dwg吗。这听起来是可行的,我使用Excel将块插入到图形中,如果您有一些可行的示例,我可能会向您展示一种尝试的方法
页: [1]
查看完整版本: Excel中的文本属性