Engl old and gold

 EnglishClub.com

EnglishPage.com

Successful add value in xls template

 Data path_to_file like rlgrap-filename value ...

Create object my_application 'Excel.Application'.

Set property of my_application 'Visible' = 0.

Get property of my_application 'Workbooks' = my_books.

Call method of my_books 'Open' = my_book exporting #1 = path_to_file.

Get property of my_book 'ActiveSheet' = my_sheet.

Clear my_cell. Set fields of my_cell like row, col, format, value, align, font_name, font_size, WrapText.

Perforn fill_cell using my_cell. 

Call method of my_book 'Save'.

Set property of my_application 'Visible' = 1.

Free object my_sheet.

Free object my_book.

Free object my_books.

Free object my_application.

Перенос тексту в клітинці в Excel2003

 1. Дозволити для клітинки перенос по словам Через Формат (WrapText = 1).

2. Формула:

="first line"&СИМВОЛ(10)&"second line" так бачимо в EXCEL2003

="first line"&CHAR(10)&"second line" так формуємо з ABAP + OLE2