is there any cell property like 'wrap text' in excel for a table.?

[RENN]

is there any cell property like 'wrap text' in excel for a table.?


i need to display  2 words in two lines --in a single cell. please help me

[MikeS81]

Hi Renn,

why do you start another thread for the same question? If you want to write something to real excel, then you should use activeX. If you have the report generation toolkit, then you can use it.

[edit] maybe it´s possible to chage the excel settings, i´m not sure if you can change the delimeter settings in excel. [/edit]

Mike

Message Edited by MikeS81 on 08-08-2008 12:49 PM

[PhillipBrooks]

I think your problem may be that you are confusing presentation (the table control on the LV front panel) with data (the string array that is in the wire).

If you press Ctrl+Enter inside the LV table control to DISPLAY two lines in one cell on the VI front panel, a new line character (\n or ascii char 0x0A) will be stored inside that array element. When the DATA in the wire is written to a file using the block diagram functions, the \n is part of the data written.

The simple solution is to loop though the array elements and replace any instances of the newline character with something that Excel will recognize; or just use a space. The PRESENTATION of the data in Excel will depend upon how you configure the cells IN EXCEL.