Insert carriage returns in Excel via OleDb c#

Question

I am inserting text into a Memo field in a Excel cell via a insert statement using OleDb command object.

When I try to insert a carriage return, char 10, what is displayed is a black square (MS Sans Serif). When I look at the top edit cell (don't know the offical name) the text is formatted correctly including carriage returns.

I am trying to duplicate what happens when a user presses Alt+Enter in a cell.

I have tried \n, \r, \r\n and char.ConvertFromUtf32(10).

Nothing seems to change the text of the cell.

ChickSentMeHighE · Accepted Answer · 2010-09-02 23:03:25Z

2

I'm assuming you meant \n and \r\n?

Also have you tried Environment.Newline?

answered Sep 2, 2010 at 23:03

ChickSentMeHighE

1,7066 gold badges21 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mike Over a year ago

Thanks for the edit. Tried Environment.NewLine that put in the \r\n which came out as two black boxes. And in the edit window a box with a question mark in it and a newline.

Chris Charabaruk · Accepted Answer · 2015-02-02 18:11:08Z

1

Got it to work as well via:

Insert the newline character \n inside the string
Set the column to autofit. The EntireColumn property can also be used to set the width of the column or to force the column to Autofit.

public void AutoFitColumn(Worksheet ws, int col) {
    ((Range)ws.Cells[1, col]).EntireColumn.AutoFit();
}

See this link if more info desired.

edited Feb 2, 2015 at 18:11

Chris Charabaruk

4,4272 gold badges35 silver badges59 bronze badges

answered May 12, 2011 at 22:10

Brian Wells

1,5821 gold badge14 silver badges12 bronze badges

Comments

Lisa · Accepted Answer · 2010-12-28 13:46:37Z

1

Try expanding the height of the row in excel. I was beating my head against the wall over this as well, and finally got it to work using \n. But then one day it stopped working for no reason other than the cell was too smal to display all lines of data.

answered Dec 28, 2010 at 13:46

Lisa

111 bronze badge

Comments

Erik · Accepted Answer · 2011-05-03 15:05:28Z

0

I had the same same blank squares hou had. I managed to make it work by inserting a \n character and by activating the option "Wrap text" in the format of the Excel cell.

answered May 3, 2011 at 15:05

Erik

91 bronze badge

Collectives™ on Stack Overflow

Insert carriage returns in Excel via OleDb c#

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related