使用C#将文本添加到Excel工作表中

问题描述

我正在尝试使用C#将很长的文本添加到Excel工作表中.我使用以下代码:

I'm trying to add a pretty long text into the Excel sheet by using C#. I use this code:

worksheet.Cells[1, 1] = textString;

结果在这里:

我想要的是:

建议?

推荐答案

要获得此效果，您必须将文本复制到剪贴板，然后将其粘贴到相关的单元格中.看到这个例子

To get this effect you have to copy the text to clipboard and then paste it to the relevant cell. See this example

注意:将textString设置为非常长的字符串.

Note: Set textString to your very long string.

尝试并测试

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //~~> Change Your String here
            String textString = "I'm trying to add a pretty long text into the Excel sheet by using sheet. I use this code:" + Environment.NewLine +
                               "worksheet.Cells[1, 1] = textString;" + Environment.NewLine +
                               "The result is here:";

            Clipboard.SetText(textString);

            Microsoft.Office.Interop.Excel.Application xlexcel;
            Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
            Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;

            object misValue = System.Reflection.Missing.Value;
            xlexcel = new Excel.Application();
            xlexcel.Visible = true;

            //~~> Add a new a workbook
            xlWorkBook = xlexcel.Workbooks.Add(misValue);

            //~~> Set Sheet 1 as the sheet you want to work with
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

            //~~> Set your range
            Excel.Range CR = (Excel.Range)xlWorkSheet.Cells[1, 1];

            CR.Select();

            xlWorkSheet.Paste(CR, false);

            // xlWorkBook.Close(true, misValue, misValue);
            //  xlexcel.Quit();

            // releaseObject(xlWorkSheet);
            // releaseObject(xlWorkBook);
            // releaseObject(xlexcel);
        }

        //private void releaseObject(object obj)
        //{
        //    try
        //    {
        //        System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
        //        obj = null;
        //    }
        //    catch (Exception ex)
        //    {
        //        obj = null;
        //        MessageBox.Show("Unable to release the Object " + ex.ToString());
        //    }
        //    finally
        //    {
        //        GC.Collect();
        //    }
        //}
    }
}

快照

这篇关于使用C#将文本添加到Excel工作表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！