Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

C# Excel interop, put a line break in the text of a cell in a Excel

Tags:

c#

excel

com-interop

I am writing an Excel sheet using interop. In the sheet I need to put a set of sentences in to a cell. The text should be in a line break manner. How can I achieve this?

Thanks in advance.

like image 774
Thanushka Avatar asked Dec 23 '11 08:12

Thanushka

People also ask

What C is used for?

C programming language is a machine-independent programming language that is mainly used to create many types of applications and operating systems such as Windows, and other complicated programs such as the Oracle database, Git, Python interpreter, and games and is considered a programming foundation in the process of ...

Is C language easy?

C is a general-purpose language that most programmers learn before moving on to more complex languages. From Unix and Windows to Tic Tac Toe and Photoshop, several of the most commonly used applications today have been built on C. It is easy to learn because: A simple syntax with only 32 keywords.

What is C full form?

Full form of C is “COMPILE”.

Why is C named so?

Because a and b and c , so it's name is C. C came out of Ken Thompson's Unix project at AT&T. He originally wrote Unix in assembly language. He wrote a language in assembly called B that ran on Unix, and was a subset of an existing language called BCPL.

1 Answers

New line within an Excel cell is the LF character, which is "\n" in C#. And do not forget to set the WrapText property of the cell to TRUE.

like image 131
Paras Chaudhary Avatar answered Oct 04 '22 02:10

Paras Chaudhary
Sign in to Comment

Related questions

Select a value from drop down using Selenium WebDriver C# [duplicate]
How to implement MyMethod() with Format("blah {0}", someValue) signature like string.format
initialised string seems to contain string.Empty [duplicate]
Why List<> implements IList [duplicate]
Does Thread.Sleep hinder other threads?
how to ignore the seconds ToShortTimeString
Use reflection to get the value of a property by name in a class instance
C# async methods still hang UI
Delete cookie on clicking sign out
How do I use Html.EditorFor to render radio buttons in MVC3?
c#: Why isn't this ambiguous enum reference resolved using the method signature?
How to change the DataTable Column Value without looping?
What type of collision resolution is chosen for HashTable/Dictionary implementation in .net?
how to compare month-year with DateParse
Refresh listview so that it shows the selectedindex?
Performing search in Asp.net MVC
Single instance of a class per HTTP request
How to use xliff or po l10n file formats in .net (C#/ASP.Net) development
DataGridView CellSelect and FullRowSelect
Passing model to Html.Action

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!