How to insert programmatically a new line in an Excel cell in C

Question

I m using the Aspose library to create an Excel document  Somewhere in some cell I need to insert a new line between two parts of the text   I tried   r n  but it doesn t work  just displays two square symbols in cell  I can however press Alt Enter to create a new line in that same cell   How do I insert a new line programmatically

User · Answer

cell Text    your firstline lt br style   mso-data-placement same-cell    gt your secondline     If you are getting the text from DB then   cell Text   textfromDB Replace   n     lt br style   mso-data-placement same-cell    gt

User · Answer

SpreadsheetGear for  NET does it this way           IWorkbook workbook   Factory GetWorkbook            IRange a1   workbook Worksheets 0  Cells  A1            a1 Value    Hello r nWorld            a1 WrapText   true          workbook SaveAs   c  HelloWorld xlsx   FileFormat OpenXMLWorkbook     Note the  WrapText   true  - Excel will not wrap the text without this  I would assume that Aspose has similar APIs   Disclaimer  I own SpreadsheetGear LLC

User · Answer

Have you tried   n  I guess  it should work

User · Answer

E Run runForBreak   new E Run     E Text textForBreak   new E Text     Space   SpaceProcessingModeValues Preserve    textForBreak Text     n   runForBreak Append textForBreak   sharedStringItem Append runForBreak

User · Answer

Internally Excel uses U 000D U 000A  CR LF   r n  for a line break  at least in its XML representation  I also couldn t find the value directly in a cell  It was migrated to another XML file containing shared strings  Maybe cells that contain line breaks are handled differently by the file format and your library doesn t know about this

User · Answer

Using PEAR  Spreadsheet Excel Writer  and  OLE    Only way I could get   n  to work was making the cell  format- gt setTextWrap     and then using   n  would work

User · Answer

n  works fine  If the input is coming from a multi-line textbox  the new line characters will be   r n   if this is replaced with   n   it will work

User · Answer

Actually  it is really simple   You may edit an xml version of excel  Edit a cell to give it new line between your text  then save it  Later you may open the file in editor  then you will see a new line is represented by   amp  10   Have a try

User · Answer

If anyone is interested in the Infragistics solution  here it is   Use Environment NewLine  Make sure your cell is wrapped dataSheet Rows i  Cells j  CellFormat WrapText   ExcelDefaultableBoolean True

User · Answer

You need to insert the character code that Excel uses  which IIRC is 10  ten    EDIT  OK  here s some code  Note that I was able to confirm that the character-code used is indeed 10  by creating a cell containing   A B     and then selecting it and executing this in the VBA immediate window   Asc Mid Activecell Value 2 1    So  the code you need to insert that value into another cell in VBA would be  ActiveCell Value    quot A quot   amp  vbLf  amp   quot B quot    since vbLf is character code 10   I know you re using C  but I find it s much easier to figure out what to do if you first do it in VBA  since you can try it out  quot interactively quot  without having to compile anything  Whatever you do in C  is just replicating what you do in VBA so there s rarely any difference   Remember that the C  interop stuff is just using the same underlying COM libraries as VBA   Anyway  the C  for this would be  oCell Value    quot A nB quot    Spot the difference  -   EDIT 2  Aaaargh  I just re-read the post and saw that you re using the Aspose library  Sorry  in that case I ve no idea

User · Answer

What worked for me   worksheet Cells 0  0  Style WrapText   true  worksheet Cells 0  0  Value   yourStringValue Replace    r  n     r n      My issue was that the  r n came escaped

User · Answer

From the Aspose Cells forums  How to use new line char with in a cell    After you supply text you should set the cell s IsTextWrapped style to true  worksheet Cells 0  0  Style WrapText   true

User · Answer

You can use Chr 13    Then just wrap the whole thing in Chr 34    Chr 34  is double quotes    VB Net Example  TheContactInfo       TheContactInfo   Trim TheEmail   amp  chr 13  TheContactInfo   TheContactInfo  amp  Trim ThePhone   amp  chr 13  TheContactInfo   Chr 34   amp  TheContactInfo  amp  Chr 34

[c#] How to insert programmatically a new line in an Excel cell in C#?

Examples related to c#

Examples related to .net

Examples related to excel

Examples related to aspose