EasyXLS
http://forum.easyxls.com/

New line
http://forum.easyxls.com/viewtopic.php?f=5&t=27
Page 1 of 1

Author:  Spencer [ Mon Aug 28, 2006 8:27 am ]
Post subject:  New line

How can I enter a new line in an Excel cell? I know in Excel there is "Alt + Enter" combination, but can I do it in code?

Author:  exari [ Mon Aug 28, 2006 9:25 am ]
Post subject:  Re:New line

You can enter a new line in a cell by using the character that has the 0x0A=10 code to separate the words. You also have to set the wrap property for the cell format.

ExcelStyle styleWrap = new ExcelStyle();
styleWrap.setWrap(true);
xlsWorksheet.easy_getExcelTable().easy_getCell("A1").setStyle(styleWrap);

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/