从execl中读出的文本到多行文本框，怎么没换行呢

lshfong 2013-12-13 04:52:24

我从execl中读出文本到多行文本框中怎么才能保持换行呢！读的文本在execl中是换了行的

...全文

158 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

wind_cloud2011 2013-12-13

打赏
举报

string str = 一行文本内容 + Environment.NewLine；

jsnjlhb 2013-12-13

打赏
举报

首先要确定你的文本框是否多行模式，用richtextbox试试

wind_cloud2011 2013-12-13

打赏
举报

版主，一楼是做什么的?

风之影子 2013-12-13

打赏
举报

C#读取Excel 几种方法的体会

wind_cloud2011 2013-12-13

打赏
举报

将文本框设置多行方式，Multiline=true;

风之影子 2013-12-13

打赏
举报

读一行后可以强制进行换行。

js导出execl，自动合并单元格，自动增行，增列

各位朋友，你们好。今天和大家分享的是一个很小很的技巧：文字、内容换行。关于文字换行，你们可能已经看过了很多这方面的文章，那些文章中确实已经讲解过不少换行操作的方法。那么我今天讲什么呢？大家看内容目录(是不是介绍得很全面，赶紧收藏起来吧，以后不用再到处查这方面的资料了。而且内容中干货很多，大量的动图演示和操作)：【回车】和【换行】的来历；【回车】和【换行】的区别；Excel中换行的六种方法；Word...

excel数据复制到html表格

<em>中</em></a></div> <a target="_blank" href="https://blog.csdn.net/anqgma0619/article/details/101459588" data-report-click="{"mod":"popu_645","index":"3","dest":"https://blog.csdn.net/anqgma0619/article/details/101459588","strategy":"2~default~OPENSEARCH~Rate","extra":"{\"utm_medium\":\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-3-101459588-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\",\"dist_request_id\":\"1758714698394_09529\"}","spm":"1035.2023.3001.6557"}" data-report-query="spm=1035.2023.3001.6557&utm_medium=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-3-101459588-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew&depth_1-utm_source=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-3-101459588-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew" class="desc" data-v-ca2d15ac>方案一
<em>多行</em><em><em>文本</em>框</em>接收到复制的excel值后，在<em><em>文本</em>框</em>的chage事件<em>中</em>，将excel内容分割到二维数组<em>中</em>，然后填充到html的表格的input或textarea<em>中</em>。
数据格式： 单元格复制后的数据格式为"设备\t缺陷类型\r\n水压堵阀\t母材裂纹"。
注释：单元格之间通过"\t"分隔，行间通过"\r\n"分隔。数据必须粘贴到<textarea>多<em><em>文本</em>框</em><em>中</em>，如果是&l...</a></div><div data-report-view="{"mod":"popu_645","index":"4","dest":"https://blog.csdn.net/huyawenz/article/details/142785734","strategy":"2~default~OPENSEARCH~Rate","extra":"{\"utm_medium\":\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-4-142785734-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\",\"dist_request_id\":\"1758714698394_09529\"}","spm":"1035.2023.3001.6557"}" class="list-item" data-v-ca2d15ac><div class="recommend-title" data-v-ca2d15ac><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAeZJREFUWEdjZGBgYPhQkSn49/v/EAbG/2oM/xn4QWI0A4wMHxn+M95i5mRcI9Ax/T0jyPI/P/7VM/5n4KKZpVgM/s/I8I2Fg6mR8W1+RioDw39TelqOsIvxNOPbgvRumgc7Lt8xMnxkfJufPmtgfA+xddQBeEOAv7opgImHh5PoKPr169fnOdN3/Xn88DOxevA6QLC9L5KRk4uHWMNA6v59+fz50+TeTf9evvhGjD6qOwDsiI8fPnya2LX537t3Pwg5giYOADvi3Zs3nyZ0bfn36dNvfI6gmQNAlv599fLlxwmd2xi+ffuDsyjAVw6QkwbQLfr76MHDj30duwbMAf+/f/vyvrJoOcUO+Pf82dOv2zadIZSoQPLcXn4mTJJS0iA21Rzw+/6de58n9uwlxgG8+SXOrIoqSlR1ADEWY1NDtRBg+PXrx7+PHz4S4xAmfgF+BjY2DqqGwIBHwb/3797+unzhFjEhwKZroMYkKCRM1RAgxmKapoF/r1+9/HHs8GVslrCISfCzWVpjbdZRLRHiSwOsugZivMkZ/jQNAYa/f//8//UTe+3GyMTMyMGBtd1AtRAY8DQwIA7gTcuxZuDkABcoZIPvP358njXlKFmVEdmWkqBxMHRMBrhrNuCdU1B0DWT3HACwkGScZb+cwwAAAABJRU5ErkJggg==" alt data-v-ca2d15ac> <a target="_blank" href="https://blog.csdn.net/huyawenz/article/details/142785734" data-report-click="{"mod":"popu_645","index":"4","dest":"https://blog.csdn.net/huyawenz/article/details/142785734","strategy":"2~default~OPENSEARCH~Rate","extra":"{\"utm_medium\":\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-4-142785734-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\",\"dist_request_id\":\"1758714698394_09529\"}","spm":"1035.2023.3001.6557"}" data-report-query="spm=1035.2023.3001.6557&utm_medium=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-4-142785734-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew&depth_1-utm_source=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-4-142785734-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew" class="title" data-v-ca2d15ac><em>exec</em>l表格批量<em>换行</em>问题</a></div> <a target="_blank" href="https://blog.csdn.net/huyawenz/article/details/142785734" data-report-click="{"mod":"popu_645","index":"4","dest":"https://blog.csdn.net/huyawenz/article/details/142785734","strategy":"2~default~OPENSEARCH~Rate","extra":"{\"utm_medium\":\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-4-142785734-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\",\"dist_request_id\":\"1758714698394_09529\"}","spm":"1035.2023.3001.6557"}" data-report-query="spm=1035.2023.3001.6557&utm_medium=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-4-142785734-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew&depth_1-utm_source=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-4-142785734-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew" class="desc" data-v-ca2d15ac><em>exec</em>l表格批量<em>换行</em>问题</a></div><div data-report-view="{"mod":"popu_645","index":"5","dest":"https://blog.csdn.net/weixin_41928732/article/details/118419295","strategy":"2~default~OPENSEARCH~Rate","extra":"{\"utm_medium\":\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-5-118419295-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\",\"dist_request_id\":\"1758714698394_09529\"}","spm":"1035.2023.3001.6557"}" class="list-item" data-v-ca2d15ac><div class="recommend-title" data-v-ca2d15ac><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAeZJREFUWEdjZGBgYPhQkSn49/v/EAbG/2oM/xn4QWI0A4wMHxn+M95i5mRcI9Ax/T0jyPI/P/7VM/5n4KKZpVgM/s/I8I2Fg6mR8W1+RioDw39TelqOsIvxNOPbgvRumgc7Lt8xMnxkfJufPmtgfA+xddQBeEOAv7opgImHh5PoKPr169fnOdN3/Xn88DOxevA6QLC9L5KRk4uHWMNA6v59+fz50+TeTf9evvhGjD6qOwDsiI8fPnya2LX537t3Pwg5giYOADvi3Zs3nyZ0bfn36dNvfI6gmQNAlv599fLlxwmd2xi+ffuDsyjAVw6QkwbQLfr76MHDj30duwbMAf+/f/vyvrJoOcUO+Pf82dOv2zadIZSoQPLcXn4mTJJS0iA21Rzw+/6de58n9uwlxgG8+SXOrIoqSlR1ADEWY1NDtRBg+PXrx7+PHz4S4xAmfgF+BjY2DqqGwIBHwb/3797+unzhFjEhwKZroMYkKCRM1RAgxmKapoF/r1+9/HHs8GVslrCISfCzWVpjbdZRLRHiSwOsugZivMkZ/jQNAYa/f//8//UTe+3GyMTMyMGBtd1AtRAY8DQwIA7gTcuxZuDkABcoZIPvP358njXlKFmVEdmWkqBxMHRMBrhrNuCdU1B0DWT3HACwkGScZb+cwwAAAABJRU5ErkJggg==" alt data-v-ca2d15ac> <a target="_blank" href="https://blog.csdn.net/weixin_41928732/article/details/118419295" data-report-click="{"mod":"popu_645","index":"5","dest":"https://blog.csdn.net/weixin_41928732/article/details/118419295","strategy":"2~default~OPENSEARCH~Rate","extra":"{\"utm_medium\":\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-5-118419295-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\",\"dist_request_id\":\"1758714698394_09529\"}","spm":"1035.2023.3001.6557"}" data-report-query="spm=1035.2023.3001.6557&utm_medium=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-5-118419295-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew&depth_1-utm_source=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-5-118419295-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew" class="title" data-v-ca2d15ac>Excel拼接后的字符串复制<em>文本</em>到word<em>中</em>出现<em>换行</em>符</a></div> <a target="_blank" href="https://blog.csdn.net/weixin_41928732/article/details/118419295" data-report-click="{"mod":"popu_645","index":"5","dest":"https://blog.csdn.net/weixin_41928732/article/details/118419295","strategy":"2~default~OPENSEARCH~Rate","extra":"{\"utm_medium\":\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-5-118419295-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\",\"dist_request_id\":\"1758714698394_09529\"}","spm":"1035.2023.3001.6557"}" data-report-query="spm=1035.2023.3001.6557&utm_medium=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-5-118419295-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew&depth_1-utm_source=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-5-118419295-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew" class="desc" data-v-ca2d15ac>Excel拼接后的字符串复制<em>文本</em>到word<em>中</em>出现<em>换行</em>符现象描述Excel拼接字符串word<em>中</em>粘贴出现<em>换行</em>解决办法
现象描述
需要将几百个数据需要放入代码<em>中</em>。
将excel<em>中</em>的数据拼接好后，粘贴到word<em>中</em>只保留<em>文本</em>会出现双引号，因为需要的内容也含有双引号，不能使用替换删除多余双引号。
粘贴保留源哥式或者合并格式就会出现自动<em>换行</em>，但在excel<em>中</em><em>没</em>有使用自动<em>换行</em>。
Excel拼接字符串
将<em>多行</em>数据拼接到一个单元格<em>中</em>，拼接内容增加双引号，单元格内容如下。
比如已有单元格

A
B

20210702</a></div></div></div></div> <div class="public_pc_right_footer2020" style="display:none;" data-v-4a5a7f56></div></div> <div id="right-floor-user-content_562" data-editor="{"type":"floor","pageId":143,"floorId":562}" class="user-right-floor right-box main-box detail-user-right" data-v-229a00b0><div class="__vuescroll" style="height:100%;width:100%;padding:0;position:relative;overflow:hidden;"><div class="__panel __hidebar" style="position:relative;box-sizing:border-box;height:100%;overflow-y:hidden;overflow-x:hidden;transform-origin:;transform:;"><div class="__view" style="position:relative;box-sizing:border-box;min-width:100%;min-height:100%;"><div comp-data="[object Object]" baseInfo="[object Object]" community="[object Object]" class="introduce" data-v-4722a3ae><div class="introduce-title" data-v-4722a3ae><div class="img-info" data-v-4722a3ae><a href="https://bbs.csdn.net/forums/CSharp" class="community-img" data-v-4722a3ae><img src="https://img-community.csdnimg.cn/avatar/a7b2a15d77ba47b6968a126366232f4f.png?x-oss-process=image/resize,m_fixed,h_88,w_88" alt data-v-4722a3ae> <div title="C#" class="community-name" data-v-4722a3ae>
          C#
        </div></a></div></div> <div class="content" data-v-4722a3ae><div class="detail" data-v-4722a3ae><div title="111112" class="item" data-v-4722a3ae><p class="num" data-v-4722a3ae>
          111,112
          </p> <p class="desc" data-v-4722a3ae>
          社区成员
        </p></div> <div title="642554" class="item" data-v-4722a3ae><a href="https://bbs.csdn.net/forums/CSharp" target="_blank" data-v-4722a3ae><p class="num" data-v-4722a3ae>
            642,554 
            </p> <p class="desc" data-v-4722a3ae>
            社区内容
          </p></a></div></div> <div class="detail-btns" data-v-4722a3ae><div class="community-ctrl-btns_wrapper" data-v-0ebf603c data-v-4722a3ae><div class="community-ctrl-btns" data-v-0ebf603c><div class="community-ctrl-btns_item" data-v-0ebf603c><div data-v-160be461 data-v-0ebf603c><div data-report-click="{"spm":"3001.5975"}" data-v-160be461><img src="https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png" alt="" class="img sendTopic" data-v-160be461 data-v-0ebf603c> <span data-v-160be461 data-v-0ebf603c>发帖</span></div>  </div></div><div class="community-ctrl-btns_item" data-v-0ebf603c><div data-v-0ebf603c><img src="https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png" alt="" class="img me" data-v-0ebf603c> <span data-v-0ebf603c>与我相关</span></div></div><div class="community-ctrl-btns_item" data-v-0ebf603c><div data-v-0ebf603c><img src="https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png" alt="" class="img task" data-v-0ebf603c> <span data-v-0ebf603c>我的任务</span></div></div><div class="community-ctrl-btns_item" data-v-0ebf603c><div class="community-share" data-v-4ca34db9 data-v-0ebf603c><div class="handle-item share" data-v-ca030a68 data-v-4ca34db9><span height="384" data-v-ca030a68><div role="tooltip" id="el-popover-4471" aria-hidden="true" class="el-popover el-popper popo share-popover" style="width:265px;display:none;"><div id="tool-QRcode" class="QRcode" data-v-ca030a68><img src="https://csdnimg.cn/release/cmsfe/public/img/shareBg4.515d57f6.png" alt="" class="share-bg" data-v-ca030a68> <div class="share-bg-box" data-v-ca030a68><div class="share-content" data-v-ca030a68><img src="https://img-community.csdnimg.cn/avatar/a7b2a15d77ba47b6968a126366232f4f.png?x-oss-process=image/resize,m_fixed,h_88,w_88" alt="" class="share-avatar" data-v-ca030a68> <div class="share-tit" data-v-ca030a68>C#</div> <div class="share-dec" data-v-ca030a68>.NET技术 C#</div> <span class="copy-share-url" data-v-ca030a68>复制链接</span> <div class="shareText" data-v-ca030a68>
            
          </div></div> <div class="share-code" data-v-ca030a68><div class="qrcode" data-v-ca030a68></div> <div class="share-code-text" data-v-ca030a68>扫一扫</div></div></div></div> </div><span class="el-popover__reference-wrapper"><div data-v-0ebf603c><img src="https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png" alt="" class="img share" data-v-0ebf603c> <span data-v-0ebf603c>分享</span></div></span></span></div> </div></div></div>  <div data-v-4fb59baf data-v-0ebf603c><div class="el-dialog__wrapper ccloud-pop-outer2" style="display:none;" data-v-4fb59baf><div role="dialog" aria-modal="true" aria-label="dialog" class="el-dialog el-dialog--center" style="margin-top:15vh;width:70%;"><div class="el-dialog__header"><span class="el-dialog__title"></span></div><div class="el-dialog__footer"><span class="dialog-footer clearfix" data-v-4fb59baf><div class="confirm-btm fr" data-v-4fb59baf>确定</div></span></div></div></div></div></div></div></div> <div style="display:none;" data-v-4722a3ae data-v-4722a3ae> <div class="introduce-desc" data-v-4722a3ae><div class="introduce-desc-title" data-v-4722a3ae>社区描述</div> <span data-v-4722a3ae> .NET技术 C# </span></div></div> <div class="introduce-text" data-v-4722a3ae><div class="label-box" data-v-4722a3ae>  </div></div>  <div class="manage" data-v-4722a3ae><div class="manage-inner" data-v-4722a3ae><span data-v-4722a3ae>社区管理员</span> <ul data-v-4722a3ae><li data-v-4722a3ae><a href="https://blog.csdn.net/community_109" target="_blank" class="start-img" data-v-4722a3ae><img src="https://profile-avatar.csdnimg.cn/default.jpg!1" alt="C#" class="el-tooltip item" data-v-4722a3ae data-v-4722a3ae></a></li><li data-v-4722a3ae><a href="https://blog.csdn.net/sunhui" target="_blank" class="start-img" data-v-4722a3ae><img src="https://profile-avatar.csdnimg.cn/4da5553c0cca498aa6129165b431f71b_sunhui.jpg!1" alt="AIGC Browser" class="el-tooltip item" data-v-4722a3ae data-v-4722a3ae></a></li><li data-v-4722a3ae><a href="https://blog.csdn.net/diaodiaop" target="_blank" class="start-img" data-v-4722a3ae><img src="https://profile-avatar.csdnimg.cn/1bbdb34c745a495686ef96bd81e655c3_diaodiaop.jpg!1" alt="by_封爱" class="el-tooltip item" data-v-4722a3ae data-v-4722a3ae></a></li></ul></div></div> <div class="actions" data-v-4722a3ae> <div style="flex:1;" data-v-4722a3ae><div class="join-btn" data-v-4722a3ae>
        加入社区
      </div></div>  </div> <div class="el-dialog__wrapper" style="display:none;" data-v-38c57799 data-v-4722a3ae><div role="dialog" aria-modal="true" aria-label="获取链接或二维码" class="el-dialog join-qrcode-dialog" style="margin-top:15vh;width:600px;"><div class="el-dialog__header"><span class="el-dialog__title">获取链接或二维码</span><button type="button" aria-label="Close" class="el-dialog__headerbtn"><i class="el-dialog__close el-icon el-icon-close"></i></button></div><div class="el-dialog__footer"><span class="dialog-footer" data-v-38c57799></span></div></div></div> <div class="collapse-btn" data-v-4722a3ae><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFAAAAAgCAYAAACFM/9sAAAAAXNSR0IArs4c6QAAAi1JREFUaEPtl01u01AUhc+N8wMSO4AxzJAqwQpKQsdtbMOICmKnwCKQ2ACDIgotrYKiduIiVZ10B0CBAjtAbICfooomJr3IcUoTiVLb15GNuG/67nm65/M5AxP0iAiQSK1iKEBhCBSgAhQSEMo1gQpQSEAo1wQqQCEBoVwT+K8CnLnWvER8cOHMaf95q9Xaj+vDtp3LPeD83u6p9a2t+U5cfVrzmSTQNOfOgg4+ATDAeNHp/Jza3Fz5HtWUZbl3GXjYn2e+53lL96Nq057LBOD0dOOcUSx8BFAcGHpZLlWmVlfnd08yaJrubRAe/Z77HwEG5kdS1E8StgFc9bzFb8dBrNtukxgLwOAXNEF6T/pAce8zSeDhknXbuUNMQRUHe/BrMNX+BNGyHIdBT45m6VVn36/FqX5cOFHmMwUYJrE5x+CgkuEujLe+361ubLS+HhowzeYtEC8NzWyXy5ValMpHgSCZyRxgsLxpui4Ij4/ShZ1S0aiurS18sSznJoOeDt29AaP6t6pLgMTV5gJgsHTddhvEWBwC9Y6AZww8AFA4Lp1xDac9nxuAYZ37aQuqGgIbPTt+t3tluNppw0jyXq4AhnV2ZkG0PAKR8b5UMiaDSicxOU5N7gCGSXRvMLAygPgB3Jv0vOXP4wSR9O1cAgzMzFxvXDR6hYlK5cd6u93eS2pw3LrcAhy38bTeV4BCkgpQAQoJCOWaQAUoJCCUawIVoJCAUK4JVIBCAkL5L1yapyGdIBwvAAAAAElFTkSuQmCC" alt data-v-4722a3ae></div></div><div comp-data="[object Object]" baseInfo="[object Object]" typePage="detail" community="[object Object]" class="floor-user-right-rank" data-v-3d3affee><div class="el-tabs el-tabs--top" data-v-3d3affee><div class="el-tabs__header is-top"><div class="el-tabs__nav-wrap is-top"><div class="el-tabs__nav-scroll"><div role="tablist" class="el-tabs__nav is-top" style="transform:translateX(-0px);"><div class="el-tabs__active-bar is-top" style="width:0px;transform:translateX(0px);ms-transform:translateX(0px);webkit-transform:translateX(0px);"></div></div></div></div></div><div class="el-tabs__content"><div role="tabpanel" id="pane-integral" aria-labelledby="tab-integral" class="el-tab-pane" data-v-3d3affee></div><div role="tabpanel" aria-hidden="true" id="pane-3" aria-labelledby="tab-3" class="el-tab-pane" style="display:none;" data-v-3d3affee></div><div role="tabpanel" aria-hidden="true" id="pane-5" aria-labelledby="tab-5" class="el-tab-pane" style="display:none;" data-v-3d3affee></div><div role="tabpanel" aria-hidden="true" id="pane-6" aria-labelledby="tab-6" class="el-tab-pane" style="display:none;" data-v-3d3affee></div></div></div> <div class="floor-user-right-rank-score" data-v-608528ce data-v-3d3affee><div class="floor-user-right-rank-score-tabs" data-v-608528ce><ul data-v-608528ce><li data-v-608528ce>
        近7日
      </li><li data-v-608528ce>
        近30日
      </li><li class="active" data-v-608528ce>
        至今
      </li></ul></div> <div class="floor-user-right-rank-common" data-v-46cf600d data-v-608528ce><div class="rank-list" data-v-46cf600d> <div class="no-data loading" data-v-46cf600d><i class="el-icon-loading" data-v-46cf600d></i> <p data-v-46cf600d>加载中</p></div>  <a href="https:///CSharp/rank/list/total" target="_blank" class="show-more" data-v-46cf600d>
      查看更多榜单
    </a></div></div></div></div><div comp-data="[object Object]" baseInfo="[object Object]" typePage="detail" community="[object Object]" class="floor comunity-rule" data-v-3cfa4dbd><div class="title" data-v-3cfa4dbd>
    社区公告
  </div> <div class="contain" data-v-3cfa4dbd><div class="inner-content" data-v-3cfa4dbd><p>让您成为最强悍的C#开发者</p>
</div></div></div><div comp-data="[object Object]" baseInfo="[object Object]" typePage="detail" community="[object Object]" class="user-right-adimg empty-arr" data-v-15c6aa4f><div class="adImgs" data-v-2a6389b9 data-v-15c6aa4f> <div data-v-2a6389b9><div data-v-2a6389b9></div></div></div></div><div comp-data="[object Object]" baseInfo="[object Object]" typePage="detail" community="[object Object]" class="ai-entrance" data-v-eb1c454c><p data-v-eb1c454c>试试用AI创作助手写篇文章吧</p> <div class="entrance-btn-line" data-v-eb1c454c><a href="https://mp.csdn.net/edit?guide=1" target="_blank" data-report-click="{"spm":"3001.9712"}" data-report-query="spm=3001.9712" class="entrance-btn" data-v-eb1c454c>+ 用AI写文章</a></div></div></div></div></div></div></div></div></div></div> </div></div></div> <div>
        <script type="text/javascript" src="https://g.csdnimg.cn/common/csdn-footer/csdn-footer.js" data-isfootertrack="false" defer></script>
      </div></div></div><script> window.__INITIAL_STATE__= {"csrf":"e4vKW24u-XT8bluwJ3mHRbOcbmSdEZQYmxsk","origin":"http:\u002F\u002Fbbs.csdn.net","isMobile":false,"cookie":"uuid_tt_dd=10_36287181780-1758714602070-702319; csrfToken=vB-uHIaQeMEDyJzvWhUTW4Vr; dc_sid=666da91da4934d09bc268213be6d1ea1; uuid_tt_dd=10_36287181780-1758714602070-702319; dc_session_id=10_1758714602070.709539","ip":"216.73.216.98","pageData":{"page":{"pageId":143,"title":"社区详情","keywords":"社区详情","description":"社区详情","ext":{"isMd":"true","armsfe1":"{pid:\"dyiaei5ihw@1a348e4d05c2c78\",appType:\"web\",imgUrl:\"https:\u002F\u002Farms-retcode.aliyuncs.com\u002Fr.png?\",sendResource:true,enableLinkTrace:true,behavior:true}","redPacketCfg":"{\"presetTitle\":[\"成就一亿技术人!\",\"大吉大利\",\"节日快乐\",\"Bug Free\",\"Hello World\",\"Be Greater Than Average!!\"],\"defaultTitle\":\"成就一亿技术人!\",\"preOpenSty\":{},\"redCardSty\":{}}","blogStar":"[{\"year\":\"2021\",\"enable\":true,\"communityIds\":[3859],\"url\":\"https:\u002F\u002Fbbs.csdn.net\u002Fsummary2021\"},{\"year\":\"2022\",\"enable\":true,\"communityIds\":[3860],\"url\":\"https:\u002F\u002Fbbs.csdn.net\u002Fsummary2022\"}]","mdVersion":"https:\u002F\u002Fcsdnimg.cn\u002Frelease\u002Fmarkdown-editor\u002F1.1.0\u002Fmarkdown-editor.js","componentSortCfg":"{   \"right\":[\"ratesInfo\",\"cty-profile\",\"pub-comp\",\"user-right-introduce\",\"post-event\",\"my-mission\", \"user-right-rank\",\"user-right-rule\",\"user-right-adimg\"] }","showCknowDetail":"{\"show\":true,\"reportView\":true,\"url\":\"https:\u002F\u002Fai.csdn.net\u002Fhomework?utm_source=cknow_bbs_detail\",\"spm\":\"1035.2022.3001.10801\"}","show_1024":"{\"enable\":false,\"useWhitelist\":false,\"whitelist\":[76215],\"home\":\"https:\u002F\u002F1111.csdn.net\u002F\",\"logo\":\"https:\u002F\u002Fimg-home.csdnimg.cn\u002Fimages\u002F20221104102741.png\",\"hideLive\":true}","iframes":"[\"3859\"]","pageCfg":"{\"disableDownloadPDF\": false,\"hideSponsor\":false}"}},"template":{"templateId":71,"templateComponentName":"ccloud-detail","title":"ccloud-detail","floorList":[{"floorId":562,"floorComponentName":"floor-user-content","title":"社区详情页","description":"社区详情页","indexOrder":3,"componentList":[{"componentName":"baseInfo","componentDataId":"cloud-detail1","componentConfigData":{},"relationType":3},{"componentName":"user-right-introduce","componentDataId":"","componentConfigData":{},"relationType":2},{"componentName":"user-recommend","componentDataId":"","componentConfigData":{},"relationType":2},{"componentName":"user-right-rank","componentDataId":"","componentConfigData":{},"relationType":2},{"componentName":"user-right-rule","componentDataId":"","componentConfigData":{},"relationType":2},{"componentName":"user-right-adimg","componentDataId":"","componentConfigData":{},"relationType":2},{"componentName":"default2014LiveRoom","componentDataId":"20221024DefaultLiveRoom","componentConfigData":{},"relationType":3}]}]},"data":{"baseInfo":{"customDomain":"","uriName":"CSharp","communityHomePage":"https:\u002F\u002Fbbs.csdn.net\u002Fforums\u002FCSharp","owner":{"userName":"community_109","nickName":"C#","avatarUrl":"https:\u002F\u002Fprofile-avatar.csdnimg.cn\u002Fdefault.jpg!1","position":"","companyName":""},"user":{"userRole":3,"userName":null,"nickName":null,"avatarUrl":null,"rank":null,"follow":2,"communityBase":null,"joinCollege":null,"isVIP":null},"community":{"name":"C#","description":".NET技术 C#","avatarUrl":"https:\u002F\u002Fimg-community.csdnimg.cn\u002Favatar\u002Fa7b2a15d77ba47b6968a126366232f4f.png?x-oss-process=image\u002Fresize,m_fixed,h_88,w_88","qrCode":"","createTime":"2007-09-28","communityAvatarUrl":"https:\u002F\u002Fprofile-avatar.csdnimg.cn\u002Fdefault.jpg!1","communityNotice":null,"userCount":111112,"contentCount":642554,"followersCount":87125,"communityRule":"\u003Cp\u003E让您成为最强悍的C#开发者\u003C\u002Fp\u003E\n","communityId":227,"bgImage":"","hashId":"den17ynj","domain":"","uriName":"CSharp","externalDisplay":1,"adBanner":{"img":"","url":"","adType":0,"adCon":null},"rightBanner":{"img":"","url":"","adType":0,"adCon":null},"tagId":null,"tagName":null,"communityType":1,"communityApplyUrl":"https:\u002F\u002Fmarketing.csdn.net\u002Fquestions\u002FQ2106040308026533763","joinType":0,"visibleType":0,"collapse":0,"topicMoveAble":0,"allowActions":{},"communityOwner":"community_109","tagNameInfo":{"provinceTag":null,"areaTag":null,"technologyTags":null,"customTags":null}},"tabList":[{"tabId":1386,"tabName":"全部","tabUrl":"","tabSwitch":1,"tabType":4,"tabContribute":0,"cardType":0,"indexOrder":-1,"url":"https:\u002F\u002Fbbs.csdn.net\u002Fforums\u002FCSharp?typeId=1386","iframe":false,"sortType":1},{"tabId":860,"tabName":"问答","tabUrl":"https:\u002F\u002Fask.csdn.net\u002Flist\u002F12\u002Ftag\u002F288","tabSwitch":1,"tabType":0,"tabContribute":0,"indexOrder":0,"iframe":true,"sortType":1},{"tabId":1184,"tabName":"C#综合技术","tabUrl":"","tabSwitch":1,"tabType":1,"tabContribute":1,"cardType":0,"indexOrder":1,"url":"https:\u002F\u002Fbbs.csdn.net\u002Fforums\u002FCSharp?typeId=1184","iframe":false,"sortType":1},{"tabId":1183,"tabName":"C#互联网桌面应用","tabUrl":"","tabSwitch":1,"tabType":1,"tabContribute":1,"cardType":0,"indexOrder":2,"url":"https:\u002F\u002Fbbs.csdn.net\u002Fforums\u002FCSharp?typeId=1183","iframe":false,"sortType":1},{"tabId":1185,"tabName":"AppLauncher","tabUrl":"","tabSwitch":1,"tabType":1,"tabContribute":1,"cardType":0,"indexOrder":3,"url":"https:\u002F\u002Fbbs.csdn.net\u002Fforums\u002FCSharp?typeId=1185","iframe":false,"sortType":1},{"tabId":1180,"tabName":"WinForm&WPF","tabUrl":"","tabSwitch":1,"tabType":1,"tabContribute":1,"cardType":0,"indexOrder":4,"url":"https:\u002F\u002Fbbs.csdn.net\u002Fforums\u002FCSharp?typeId=1180","iframe":false,"sortType":1},{"tabId":1181,"tabName":"C#开发新技术","tabUrl":"","tabSwitch":1,"tabType":1,"tabContribute":1,"cardType":0,"indexOrder":5,"url":"https:\u002F\u002Fbbs.csdn.net\u002Fforums\u002FCSharp?typeId=1181","iframe":false,"sortType":1},{"tabId":4055669,"tabName":"博文收录","tabUrl":"","tabSwitch":1,"tabType":2,"tabContribute":0,"cardType":0,"indexOrder":19,"url":"https:\u002F\u002Fbbs.csdn.net\u002Fforums\u002FCSharp?typeId=4055669","iframe":false,"sortType":1},{"tabId":1637785,"tabName":"Ada助手","tabUrl":"","tabSwitch":1,"tabType":2,"tabContribute":0,"cardType":0,"indexOrder":20,"url":"https:\u002F\u002Fbbs.csdn.net\u002Fforums\u002FCSharp?typeId=1637785","iframe":false,"sortType":1}],"dataResource":{"mediaType":"c_cloud","subResourceType":"8_c_cloud_long_text","showType":"long_text","tabId":0,"communityName":"C#","communityHomePageUrl":"https:\u002F\u002Fbbs.csdn.net\u002Fforums\u002FCSharp","communityType":1,"content":{"id":"390668696","contentId":390668696,"cateId":0,"cateName":null,"url":"https:\u002F\u002Fbbs.csdn.net\u002Ftopics\u002F390668696","shareUrl":"https:\u002F\u002Fbbs.csdn.net\u002Ftopics\u002F390668696","createTime":"2013-12-13 04:52:24","updateTime":"2021-05-28 19:01:56","resourceUsername":"lshfong","best":0,"top":0,"text":null,"publishDate":"2013-12-13","lastReplyDate":"2013-12-13","type":"13","nickname":"lshfong","avatar":"https:\u002F\u002Fprofile-avatar.csdnimg.cn\u002Fcf8bc11ccba6493ab1fd0a487b11d7e5_lshfong.jpg!1","username":"lshfong","commentCount":7,"diggNum":0,"digg":false,"viewCount":158,"hit":false,"resourceSource":6,"status":10,"taskStatus":null,"expired":false,"taskCate":0,"taskAward":0,"taskExpired":null,"checkRedPacket":null,"avgScore":0,"totalScore":0,"topicTitle":"从execl中读出的文本到多行文本框，怎么没换行呢","insertFirst":false,"likeInfo":null,"description":"我从execl中读出文本到多行文本框中怎么才能保持换行呢！读的文本在execl中是换了行的","coverImg":"https:\u002F\u002Fimg-home.csdnimg.cn\u002Fimages\u002F20221110040243.png","content":"我从execl中读出文本到多行文本框中怎么才能保持换行呢！读的文本在execl中是换了行的","mdContent":null,"pictures":null,"videoInfo":null,"linkInfo":null,"student":{"isCertification":false,"org":"","bala":""},"employee":{"isCertification":false,"org":"","bala":""},"userCertification":[],"dependId":"0","dependSubType":null,"videoUrl":null,"favoriteCount":0,"favoriteStatus":false,"taskType":null,"defaultScore":null,"syncAsk":false,"videoPlayLength":null},"communityUser":{"userName":"lshfong","roleId":232,"roleType":0,"roleStatus":1,"honoraryId":0,"roleName":"","honoraryName":null,"communityNickname":"","communitySignature":""},"allowPost":false,"submitHistory":[{"user":{"registerurl":"https:\u002F\u002Fg.csdnimg.cn\u002Fstatic\u002Fuser-reg-year\u002F1x\u002F19.png","avatarurl":"https:\u002F\u002Fprofile-avatar.csdnimg.cn\u002Fcf8bc11ccba6493ab1fd0a487b11d7e5_lshfong.jpg!1","nickname":"lshfong","selfdesc":"","createdate":"2006-08-07 16:04:00","days":"6989","years":"19","username":"lshfong","school":null,"company":null,"job":null},"userName":"lshfong","event":"创建了帖子","body":"2013-12-13 04:52","editId":null}],"resourceExt":{}},"contentReply":{"pageNo":1,"pageSize":20,"totalPages":1,"totalCount":6,"total":0,"list":[{"hit":null,"hitMsg":null,"content":"string str = 一行文本内容 + Environment.NewLine；","topicTitle":null,"description":"string str = 一行文本内容 + Environment.NewLine；","id":396333838,"contentResourceId":390668696,"bindContentResourceId":0,"communityId":227,"username":"wind_cloud2011","userNickName":"wind_cloud2011","userAvatar":"https:\u002F\u002Fprofile-avatar.csdnimg.cn\u002F002c19b8c410412e81bd8541a53f4281_wind_cloud2011.jpg!1","mdContent":null,"parentId":0,"replyName":"","replyNickName":"","bizNo":"bbs","ip":3549189422,"status":10,"childCount":0,"topStatus":0,"recommendStatus":0,"userLike":false,"diggCount":0,"childIds":"","createTime":"2013-12-13 05:00:40","updateTime":"2013-12-13 05:29:59","formatTime":"2013-12-13","userRoleHonorary":{"userName":"wind_cloud2011","roleId":232,"roleType":0,"roleStatus":1,"honoraryId":0,"roleName":"","honoraryName":null,"communityNickname":"","communitySignature":""},"child":null,"communityNickname":null,"communityReplyNickname":null,"rewardInfo":null,"checkRedPacketVO":null,"noDiggCount":null},{"hit":null,"hitMsg":null,"content":"首先要确定你的文本框是否多行模式，用richtextbox试试","topicTitle":null,"description":"首先要确定你的文本框是否多行模式，用richtextbox试试","id":396333804,"contentResourceId":390668696,"bindContentResourceId":0,"communityId":227,"username":"jsnjlhb","userNickName":"jsnjlhb","userAvatar":"https:\u002F\u002Fprofile-avatar.csdnimg.cn\u002Fdefault.jpg!1","mdContent":null,"parentId":0,"replyName":"","replyNickName":"","bizNo":"bbs","ip":3730610739,"status":10,"childCount":0,"topStatus":0,"recommendStatus":0,"userLike":false,"diggCount":0,"childIds":"","createTime":"2013-12-13 04:58:29","updateTime":"2013-12-13 05:15:34","formatTime":"2013-12-13","userRoleHonorary":{"userName":"jsnjlhb","roleId":232,"roleType":0,"roleStatus":1,"honoraryId":0,"roleName":"","honoraryName":null,"communityNickname":"","communitySignature":""},"child":null,"communityNickname":null,"communityReplyNickname":null,"rewardInfo":null,"checkRedPacketVO":null,"noDiggCount":null},{"hit":null,"hitMsg":null,"content":"版主，一楼是做什么的?\u003Cimg src=\"https:\u002F\u002Fforum.csdn.net\u002FPointForum\u002Fui\u002Fscripts\u002Fcsdn\u002FPlugin\u002F001\u002Fface\u002F31.gif\" alt=\"\" \u002F\u003E","topicTitle":null,"description":"版主，一楼是做什么的?","id":396333776,"contentResourceId":390668696,"bindContentResourceId":0,"communityId":227,"username":"wind_cloud2011","userNickName":"wind_cloud2011","userAvatar":"https:\u002F\u002Fprofile-avatar.csdnimg.cn\u002F002c19b8c410412e81bd8541a53f4281_wind_cloud2011.jpg!1","mdContent":null,"parentId":0,"replyName":"","replyNickName":"","bizNo":"bbs","ip":3549189422,"status":10,"childCount":0,"topStatus":0,"recommendStatus":0,"userLike":false,"diggCount":0,"childIds":"","createTime":"2013-12-13 04:57:25","updateTime":"2013-12-13 05:15:34","formatTime":"2013-12-13","userRoleHonorary":{"userName":"wind_cloud2011","roleId":232,"roleType":0,"roleStatus":1,"honoraryId":0,"roleName":"","honoraryName":null,"communityNickname":"","communitySignature":""},"child":null,"communityNickname":null,"communityReplyNickname":null,"rewardInfo":null,"checkRedPacketVO":null,"noDiggCount":null},{"hit":null,"hitMsg":null,"content":"\u003Ca href=\"http:\u002F\u002Fwww.cnblogs.com\u002FTsong\u002Farchive\u002F2013\u002F02\u002F21\u002F2920941.html\" target=\"_blank\" \u003EC#读取Excel 几种方法的体会\u003C\u002Fa\u003E\n\n","topicTitle":null,"description":"C#读取Excel 几种方法的体会 ","id":396333760,"contentResourceId":390668696,"bindContentResourceId":0,"communityId":227,"username":"libinguest","userNickName":"风之影子","userAvatar":"https:\u002F\u002Fprofile-avatar.csdnimg.cn\u002F96611b2252a54187ab511b92be9d2137_libinguest.jpg!1","mdContent":null,"parentId":0,"replyName":"","replyNickName":"","bizNo":"bbs","ip":2075016814,"status":10,"childCount":0,"topStatus":0,"recommendStatus":0,"userLike":false,"diggCount":0,"childIds":"","createTime":"2013-12-13 04:56:29","updateTime":"2013-12-13 05:15:34","formatTime":"2013-12-13","userRoleHonorary":{"userName":null,"roleId":null,"roleType":null,"roleStatus":null,"honoraryId":null,"roleName":null,"honoraryName":null,"communityNickname":null,"communitySignature":null},"child":null,"communityNickname":null,"communityReplyNickname":null,"rewardInfo":null,"checkRedPacketVO":null,"noDiggCount":null},{"hit":null,"hitMsg":null,"content":"将文本框设置多行方式，Multiline=true;","topicTitle":null,"description":"将文本框设置多行方式，Multiline=true;","id":396333748,"contentResourceId":390668696,"bindContentResourceId":0,"communityId":227,"username":"wind_cloud2011","userNickName":"wind_cloud2011","userAvatar":"https:\u002F\u002Fprofile-avatar.csdnimg.cn\u002F002c19b8c410412e81bd8541a53f4281_wind_cloud2011.jpg!1","mdContent":null,"parentId":0,"replyName":"","replyNickName":"","bizNo":"bbs","ip":3549189422,"status":10,"childCount":0,"topStatus":0,"recommendStatus":0,"userLike":false,"diggCount":0,"childIds":"","createTime":"2013-12-13 04:55:50","updateTime":"2013-12-13 05:15:34","formatTime":"2013-12-13","userRoleHonorary":{"userName":"wind_cloud2011","roleId":232,"roleType":0,"roleStatus":1,"honoraryId":0,"roleName":"","honoraryName":null,"communityNickname":"","communitySignature":""},"child":null,"communityNickname":null,"communityReplyNickname":null,"rewardInfo":null,"checkRedPacketVO":null,"noDiggCount":null},{"hit":null,"hitMsg":null,"content":"读一行后可以强制进行换行。\n\n\n\n","topicTitle":null,"description":"读一行后可以强制进行换行。 ","id":396333733,"contentResourceId":390668696,"bindContentResourceId":0,"communityId":227,"username":"libinguest","userNickName":"风之影子","userAvatar":"https:\u002F\u002Fprofile-avatar.csdnimg.cn\u002F96611b2252a54187ab511b92be9d2137_libinguest.jpg!1","mdContent":null,"parentId":0,"replyName":"","replyNickName":"","bizNo":"bbs","ip":2075016814,"status":10,"childCount":0,"topStatus":0,"recommendStatus":0,"userLike":false,"diggCount":0,"childIds":"","createTime":"2013-12-13 04:55:14","updateTime":"2014-01-03 09:09:23","formatTime":"2013-12-13","userRoleHonorary":{"userName":null,"roleId":null,"roleType":null,"roleStatus":null,"honoraryId":null,"roleName":null,"honoraryName":null,"communityNickname":null,"communitySignature":null},"child":null,"communityNickname":null,"communityReplyNickname":null,"rewardInfo":null,"checkRedPacketVO":null,"noDiggCount":null}],"maxPageSize":3000},"defaultActiveTab":1386,"recommends":[{"url":"https:\u002F\u002Fdownload.csdn.net\u002Fdownload\u002Fzhaoxiaofei0929\u002F2495573","title":"Javascript导出Excel，自动合并单元格、自动列宽、有进度条","desc":"js导出\u003Cem\u003Eexec\u003C\u002Fem\u003El，自动合并单元格，自动增行，增列","createTime":"2010-06-28 16:07:14","dataReportQuery":"spm=1035.2023.3001.6557&utm_medium=distribute.pc_relevant_bbs_down_v2.none-task-download-2~default~OPENSEARCH~Paid-1-2495573-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew&depth_1-utm_source=distribute.pc_relevant_bbs_down_v2.none-task-download-2~default~OPENSEARCH~Paid-1-2495573-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew","dataReportClick":"{\"mod\":\"popu_645\",\"index\":\"1\",\"dest\":\"https:\u002F\u002Fdownload.csdn.net\u002Fdownload\u002Fzhaoxiaofei0929\u002F2495573\",\"strategy\":\"2~default~OPENSEARCH~Paid\",\"extra\":\"{\\\"utm_medium\\\":\\\"distribute.pc_relevant_bbs_down_v2.none-task-download-2~default~OPENSEARCH~Paid-1-2495573-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\\\",\\\"dist_request_id\\\":\\\"1758714698394_09529\\\"}\",\"spm\":\"1035.2023.3001.6557\"}","dataReportView":"{\"mod\":\"popu_645\",\"index\":\"1\",\"dest\":\"https:\u002F\u002Fdownload.csdn.net\u002Fdownload\u002Fzhaoxiaofei0929\u002F2495573\",\"strategy\":\"2~default~OPENSEARCH~Paid\",\"extra\":\"{\\\"utm_medium\\\":\\\"distribute.pc_relevant_bbs_down_v2.none-task-download-2~default~OPENSEARCH~Paid-1-2495573-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\\\",\\\"dist_request_id\\\":\\\"1758714698394_09529\\\"}\",\"spm\":\"1035.2023.3001.6557\"}","type":"download"},{"url":"https:\u002F\u002Fblog.csdn.net\u002Fweixin_39610422\u002Farticle\u002Fdetails\u002F109887345","title":"axure原型怎么让文字自动\u003Cem\u003E换行\u003C\u002Fem\u003E_理解「回车」和「\u003Cem\u003E换行\u003C\u002Fem\u003E」，纠正数据输入过程\u003Cem\u003E中\u003C\u002Fem\u003E的坏习惯...","desc":"各位朋友，你们好。今天和大家分享的是一个很小很的技巧：文字、内容\u003Cem\u003E换行\u003C\u002Fem\u003E。关于文字\u003Cem\u003E换行\u003C\u002Fem\u003E，你们可能已经看过了很多这方面的文章，那些文章\u003Cem\u003E中\u003C\u002Fem\u003E确实已经讲解过不少\u003Cem\u003E换行\u003C\u002Fem\u003E操作的方法。那么我今天讲什么呢？大家看内容目录(是不是介绍得很全面，赶紧收藏起来吧，以后不用再到处查这方面的资料了。而且内容\u003Cem\u003E中\u003C\u002Fem\u003E干货很多，大量的动图演示和操作)：【回车】和【\u003Cem\u003E换行\u003C\u002Fem\u003E】的来历；【回车】和【\u003Cem\u003E换行\u003C\u002Fem\u003E】的区别；Excel\u003Cem\u003E中\u003C\u002Fem\u003E\u003Cem\u003E换行\u003C\u002Fem\u003E的六种方法；Word...","createTime":"2020-11-18 11:58:24","dataReportQuery":"spm=1035.2023.3001.6557&utm_medium=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-2-109887345-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew&depth_1-utm_source=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-2-109887345-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew","dataReportClick":"{\"mod\":\"popu_645\",\"index\":\"2\",\"dest\":\"https:\u002F\u002Fblog.csdn.net\u002Fweixin_39610422\u002Farticle\u002Fdetails\u002F109887345\",\"strategy\":\"2~default~OPENSEARCH~Rate\",\"extra\":\"{\\\"utm_medium\\\":\\\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-2-109887345-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\\\",\\\"dist_request_id\\\":\\\"1758714698394_09529\\\"}\",\"spm\":\"1035.2023.3001.6557\"}","dataReportView":"{\"mod\":\"popu_645\",\"index\":\"2\",\"dest\":\"https:\u002F\u002Fblog.csdn.net\u002Fweixin_39610422\u002Farticle\u002Fdetails\u002F109887345\",\"strategy\":\"2~default~OPENSEARCH~Rate\",\"extra\":\"{\\\"utm_medium\\\":\\\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-2-109887345-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\\\",\\\"dist_request_id\\\":\\\"1758714698394_09529\\\"}\",\"spm\":\"1035.2023.3001.6557\"}","type":"blog"},{"url":"https:\u002F\u002Fblog.csdn.net\u002Fanqgma0619\u002Farticle\u002Fdetails\u002F101459588","title":"excel数据复制到html表格\u003Ctextarea\u003E\u003Cem\u003E中\u003C\u002Fem\u003E","desc":"方案一\r\n\u003Cem\u003E多行\u003C\u002Fem\u003E\u003Cem\u003E\u003Cem\u003E文本\u003C\u002Fem\u003E框\u003C\u002Fem\u003E接收到复制的excel值后，在\u003Cem\u003E\u003Cem\u003E文本\u003C\u002Fem\u003E框\u003C\u002Fem\u003E的chage事件\u003Cem\u003E中\u003C\u002Fem\u003E，将excel内容分割到二维数组\u003Cem\u003E中\u003C\u002Fem\u003E，然后填充到html的表格的input或textarea\u003Cem\u003E中\u003C\u002Fem\u003E。\r\n数据格式： 单元格复制后的数据格式为\"设备\\t缺陷类型\\r\\n水压堵阀\\t母材裂纹\"。\r\n注释：单元格之间通过\"\\t\"分隔，行间通过\"\\r\\n\"分隔。数据必须粘贴到<textarea>多\u003Cem\u003E\u003Cem\u003E文本\u003C\u002Fem\u003E框\u003C\u002Fem\u003E\u003Cem\u003E中\u003C\u002Fem\u003E，如果是&l...","createTime":"2019-09-26 18:12:40","dataReportQuery":"spm=1035.2023.3001.6557&utm_medium=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-3-101459588-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew&depth_1-utm_source=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-3-101459588-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew","dataReportClick":"{\"mod\":\"popu_645\",\"index\":\"3\",\"dest\":\"https:\u002F\u002Fblog.csdn.net\u002Fanqgma0619\u002Farticle\u002Fdetails\u002F101459588\",\"strategy\":\"2~default~OPENSEARCH~Rate\",\"extra\":\"{\\\"utm_medium\\\":\\\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-3-101459588-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\\\",\\\"dist_request_id\\\":\\\"1758714698394_09529\\\"}\",\"spm\":\"1035.2023.3001.6557\"}","dataReportView":"{\"mod\":\"popu_645\",\"index\":\"3\",\"dest\":\"https:\u002F\u002Fblog.csdn.net\u002Fanqgma0619\u002Farticle\u002Fdetails\u002F101459588\",\"strategy\":\"2~default~OPENSEARCH~Rate\",\"extra\":\"{\\\"utm_medium\\\":\\\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-3-101459588-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\\\",\\\"dist_request_id\\\":\\\"1758714698394_09529\\\"}\",\"spm\":\"1035.2023.3001.6557\"}","type":"blog"},{"url":"https:\u002F\u002Fblog.csdn.net\u002Fhuyawenz\u002Farticle\u002Fdetails\u002F142785734","title":"\u003Cem\u003Eexec\u003C\u002Fem\u003El表格批量\u003Cem\u003E换行\u003C\u002Fem\u003E问题","desc":"\u003Cem\u003Eexec\u003C\u002Fem\u003El表格批量\u003Cem\u003E换行\u003C\u002Fem\u003E问题","createTime":"2024-10-09 14:21:11","dataReportQuery":"spm=1035.2023.3001.6557&utm_medium=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-4-142785734-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew&depth_1-utm_source=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-4-142785734-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew","dataReportClick":"{\"mod\":\"popu_645\",\"index\":\"4\",\"dest\":\"https:\u002F\u002Fblog.csdn.net\u002Fhuyawenz\u002Farticle\u002Fdetails\u002F142785734\",\"strategy\":\"2~default~OPENSEARCH~Rate\",\"extra\":\"{\\\"utm_medium\\\":\\\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-4-142785734-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\\\",\\\"dist_request_id\\\":\\\"1758714698394_09529\\\"}\",\"spm\":\"1035.2023.3001.6557\"}","dataReportView":"{\"mod\":\"popu_645\",\"index\":\"4\",\"dest\":\"https:\u002F\u002Fblog.csdn.net\u002Fhuyawenz\u002Farticle\u002Fdetails\u002F142785734\",\"strategy\":\"2~default~OPENSEARCH~Rate\",\"extra\":\"{\\\"utm_medium\\\":\\\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-4-142785734-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\\\",\\\"dist_request_id\\\":\\\"1758714698394_09529\\\"}\",\"spm\":\"1035.2023.3001.6557\"}","type":"blog"},{"url":"https:\u002F\u002Fblog.csdn.net\u002Fweixin_41928732\u002Farticle\u002Fdetails\u002F118419295","title":"Excel拼接后的字符串复制\u003Cem\u003E文本\u003C\u002Fem\u003E到word\u003Cem\u003E中\u003C\u002Fem\u003E出现\u003Cem\u003E换行\u003C\u002Fem\u003E符","desc":"Excel拼接后的字符串复制\u003Cem\u003E文本\u003C\u002Fem\u003E到word\u003Cem\u003E中\u003C\u002Fem\u003E出现\u003Cem\u003E换行\u003C\u002Fem\u003E符现象描述Excel拼接字符串word\u003Cem\u003E中\u003C\u002Fem\u003E粘贴出现\u003Cem\u003E换行\u003C\u002Fem\u003E解决办法\n现象描述\n需要将几百个数据需要放入代码\u003Cem\u003E中\u003C\u002Fem\u003E。\n将excel\u003Cem\u003E中\u003C\u002Fem\u003E的数据拼接好后，粘贴到word\u003Cem\u003E中\u003C\u002Fem\u003E只保留\u003Cem\u003E文本\u003C\u002Fem\u003E会出现双引号，因为需要的内容也含有双引号，不能使用替换删除多余双引号。\n粘贴保留源哥式或者合并格式就会出现自动\u003Cem\u003E换行\u003C\u002Fem\u003E，但在excel\u003Cem\u003E中\u003C\u002Fem\u003E\u003Cem\u003E没\u003C\u002Fem\u003E有使用自动\u003Cem\u003E换行\u003C\u002Fem\u003E。\nExcel拼接字符串\n将\u003Cem\u003E多行\u003C\u002Fem\u003E数据拼接到一个单元格\u003Cem\u003E中\u003C\u002Fem\u003E，拼接内容增加双引号，单元格内容如下。\n比如已有单元格\n\n\n\n\nA\nB\n\n\n\n\n20210702","createTime":"2021-07-02 16:51:24","dataReportQuery":"spm=1035.2023.3001.6557&utm_medium=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-5-118419295-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew&depth_1-utm_source=distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-5-118419295-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew","dataReportClick":"{\"mod\":\"popu_645\",\"index\":\"5\",\"dest\":\"https:\u002F\u002Fblog.csdn.net\u002Fweixin_41928732\u002Farticle\u002Fdetails\u002F118419295\",\"strategy\":\"2~default~OPENSEARCH~Rate\",\"extra\":\"{\\\"utm_medium\\\":\\\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-5-118419295-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\\\",\\\"dist_request_id\\\":\\\"1758714698394_09529\\\"}\",\"spm\":\"1035.2023.3001.6557\"}","dataReportView":"{\"mod\":\"popu_645\",\"index\":\"5\",\"dest\":\"https:\u002F\u002Fblog.csdn.net\u002Fweixin_41928732\u002Farticle\u002Fdetails\u002F118419295\",\"strategy\":\"2~default~OPENSEARCH~Rate\",\"extra\":\"{\\\"utm_medium\\\":\\\"distribute.pc_relevant_bbs_down_v2.none-task-blog-2~default~OPENSEARCH~Rate-5-118419295-bbs-390668696.264^v3^pc_relevant_bbs_down_v2_opensearchbbsnew\\\",\\\"dist_request_id\\\":\\\"1758714698394_09529\\\"}\",\"spm\":\"1035.2023.3001.6557\"}","type":"blog"}],"staffDOList":[{"id":null,"communityId":227,"username":"community_109","userNickname":"C#","roleCode":1,"status":1,"createUsername":"","updateUsername":"","avatarUrl":"https:\u002F\u002Fprofile-avatar.csdnimg.cn\u002Fdefault.jpg!1","createTime":"2021-05-12 18:07:21","updateTime":"2021-05-12 18:07:21","lastLoginTime":"2021-05-12 18:07:21"},{"id":null,"communityId":227,"username":"sunhui","userNickname":"AIGC Browser","roleCode":2,"status":1,"createUsername":"bbs_assistant","updateUsername":"","avatarUrl":"https:\u002F\u002Fprofile-avatar.csdnimg.cn\u002F4da5553c0cca498aa6129165b431f71b_sunhui.jpg!1","createTime":"2021-07-29 12:01:41","updateTime":"2021-07-29 12:01:41","lastLoginTime":"2021-07-29 12:01:41"},{"id":null,"communityId":227,"username":"diaodiaop","userNickname":"by_封爱","roleCode":2,"status":1,"createUsername":"bbs_assistant","updateUsername":"","avatarUrl":"https:\u002F\u002Fprofile-avatar.csdnimg.cn\u002F1bbdb34c745a495686ef96bd81e655c3_diaodiaop.jpg!1","createTime":"2021-07-13 16:47:41","updateTime":"2021-07-13 16:47:41","lastLoginTime":"2021-07-13 16:47:41"}],"communityConfig":{"scoreType":0,"scoreItems":{"0":"给本帖投票","1":"锋芒小试，眼前一亮","2":"潜力巨大，未来可期","3":"持续贡献，值得关注","4":"成绩优异，大力学习","5":"贡献巨大，全力支持"}},"shouldApply":false,"subscribeAble":false,"operatorAble":false,"commentNeedJoinCommunity":false},"default2014LiveRoom":[{"itemType":"","description":"高峰论坛","title":"2022 技术英雄会","url":"https:\u002F\u002Flive.csdn.net\u002Froom\u002Fiframe\u002Fcsdnnews\u002FfsNR5NWp?chat=1&title=1&footer=1","images":["https:\u002F\u002Fimg-home.csdnimg.cn\u002Fimages\u002F20221016050009.png"],"ext":{"time":"9:00","liveRoomUrl":"https:\u002F\u002Flive.csdn.net\u002Froom\u002Fcsdnnews\u002FfsNR5NWp"}}]},"isGooglebot":false,"canonical":"https:\u002F\u002Fwww.csdn.net\u002Ftopics\u002F390668696","openUrl":"","isApp":false,"localUrl":"https:\u002F\u002Fbbs.csdn.net\u002Ftopics\u002F390668696","typeId":"index","hasIndex":false},"CFG":{"ALIPLAYER_VERSION":"v4","ALIPLAYER_H5_VERSION":"mobile_v1","ENV":"prod","ROOT_URL":"https:\u002F\u002Fcms-mall.csdn.net\u002F","VUE_APP_API_URL_SERVER":"http:\u002F\u002Fcms-community-api.internal.csdn.net\u002F","VUE_APP_API_URL":"https:\u002F\u002Fcms-api.csdn.net\u002F","LOGIN_URL":"https:\u002F\u002Fpassport.csdn.net\u002Faccount\u002Flogin","VUE_APP_DOMAIN_SKILL":"https:\u002F\u002Fedu.csdn.net\u002F","VUE_APP_DOMAIN_PATH":"https:\u002F\u002Fedu.csdn.net\u002F","VUE_APP_COMMUNITY_API_URL":"https:\u002F\u002Fcommunity-api.csdn.net\u002F","VUE_APP_CCLOUD_API_URL":"https:\u002F\u002Fbizapi.csdn.net\u002Fcommunity-cloud\u002Fv1\u002F","VUE_APP_SKILL_API_URL":"https:\u002F\u002Fbizapi.csdn.net\u002Fskilltree\u002Fapi\u002F","VUE_APP_SEARCH_PLUGIN_API_URL":"https:\u002F\u002Fbizapi.csdn.net\u002Fsearchplugin\u002F","VUE_APP_COMMUNITY_ASK_API_URL":"https:\u002F\u002Fmp-ask.csdn.net\u002F","VUE_APP_ME_URL":"https:\u002F\u002Fme.csdn.net\u002F","VUE_APP_CCLOUD_RESUME":"https:\u002F\u002Fbizapi.csdn.net\u002Fjob-api\u002F","VUE_APP_CCLOUD_MAIN":"https:\u002F\u002Fwww.csdn.net\u002F","VUE_APP_CCLOUD_UC":"https:\u002F\u002Fwww.csdn.net\u002F","VUE_APP_CCLOUD_BZP_API_URL":"https:\u002F\u002Fbizapi.csdn.net\u002F","VUE_APP_CCLOUD_START_API_URL":"https:\u002F\u002Fmp-action.csdn.net\u002F","VUE_APP_PRACTIVE":"https:\u002F\u002Fbizapi.csdn.net\u002Fdaily-practice\u002F","VUE_APP_CCLOUD_HOSTPATH":"https:\u002F\u002Fbbs.csdn.net\u002F"},"queries":{"pageId":[],"domain":["ccloud.csdn.net\u002Fccloud\u002Fdetail1"],"id":["390668696"],"deviceType":"pc","isSpider":"","hostname":["bbs.csdn.net"]},"basePath":"bbs.csdn.net\u002Fccloud\u002Ftopics\u002F390668696","hrefUrl":"https:\u002F\u002Fbbs.csdn.net\u002Ftopics\u002F390668696","active":0,"navBarFixed":false,"title":"从execl中读出的文本到多行文本框，怎么没换行呢","isLive":false,"contentType":{"text":"text","picture":"picture","link":"link","video":"video","vote":"vote","live":"live","blog":"blog","long_text":"long_text","task_text":"task_text"},"liveUrl":"https:\u002F\u002Flive.csdn.net\u002Froom\u002Fiframe\u002F","spmExtra":{"id":227,"topicId":390668696},"keywords":"","description":"以下内容是CSDN社区关于从execl中读出的文本到多行文本框，怎么没换行呢相关内容，如果想了解更多关于C#社区其他内容，请访问CSDN社区。","mounted":false,"infoNoticeData":{"src":"","href":"","spm":"","delay":5},"showDialogInfoNotice":false};</script><script type="text/javascript" src="https://csdnimg.cn/release/cmsfe/public/js/runtime.2c8d4172.js"></script><script type="text/javascript" src="https://csdnimg.cn/release/cmsfe/public/js/chunk/common.9ac324e8.js"></script><script type="text/javascript" src="https://csdnimg.cn/release/cmsfe/public/js/chunk/tpl/ccloud-detail/index.93a5f007.js"></script></body>  
      <script>
        window.csdn.sideToolbar = {
        options: {
          qr: {
              isShow: true,
             data: [
              {
                imgSrc: 'https://csdnimg.cn/release/cmsfe/public/img/ewm.9010d6e5.png',
                desc: "关注公众号"
              },
            ]

},
          help: {
            isShow: false,
          },
          contentEl: document.getElementsByClassName("cloud-maintainer")[0]
        },
      };
      </script>
      <script src="https://g.csdnimg.cn/side-toolbar/2.9/side-toolbar.js" ></script>
          
        <script src="https://csdnimg.cn/release/blog_editor_html/release1.7.5/ckeditor/plugins/codesnippet/lib/highlight/highlight.pack.js"></script>
        <script src="https://g.csdnimg.cn/lib/editor-page-detail/v2.2.0/js/runDetail.min.js"></script>
             
        <script src="https://g.csdnimg.cn/collection-box/2.1.0/collection-box.js"></script>
           
        <script src="https://g.csdnimg.cn/common/csdn-cert/csdn-cert.js"></script>
       </html>