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.
No comments:
Post a Comment