OK, getting closer.
Created the following program:

01000 LET X_OBJ=NEW("*obj/excel")
01020 LET PATH$="c:\qc_updates\test.xlsx"
01040 LET RETVAL=X_OBJ'CREATEWORKBOOK(PATH$,1)
01060 LET RETVAL=X_OBJ'SETRANGE("A1:E1")
01080 LET NEW_RANGE$="one"+SEP+"two"+SEP+"three"+SEP+"*four"+SEP+"five"+SEP
01100 LET RETVAL=X_OBJ'WRITE(NEW_RANGE$)
01120 LET RETVAL=X_OBJ'SAVEWORKBOOK()
01140 LET RETVAL=X_OBJ'CLOSEWORKBOOK()
01160 DROP OBJECT X_OBJ

It completes successfully but the data in the cells A1 - E1 is the number 32003 in each cell.

Suggestions?

Tom

If you are using PxPlus 2017 or newer - you can use the PxPlus Excel Object.

 ! demo program for Pxlus Excel Object
 ! retval can be checked after each command to ensure there were no errors
 !
  x_obj=NEW("*obj/excel") ! instantiate the object
 !
  path$="c:\spreadsheets\workbook_name.xlsx"
  retval=x_obj'CreateWorkbook(path$,1) ! 2nd parameter overwrites workbook_name.xlsx if it exits
  retval=x_obj'SetWorksheet(1) ! set active worksheet to 1 (not really neede - should already be 1 after creating the workbook
 !
  retVal=x_obj'write("value for cell C2","C2") ! ! Write a value to cell C2 in active worksheet
 !
  retval=x_obj'SetRange("A3:E3") ! set range to 5 cells in row 3
  new_range$="one"+SEP+"two"+SEP+"three"+SEP+"*four"+SEP+"five"+SEP
  retVal=x_obj'write(new_range$) ! write data to current range
 !
  retVal=x_obj'SaveWorkbook()
  retVal=x_obj'CloseWorkbook()
  DROP OBJECT x_obj
  END

I'm updating a panel that has single-line multi_lines and multiple-line multi_lines. The fonts are different sizes: the multiple-line entries' fonts are 1/6 larger than the single-line entries (see attached snip). All of the font info and attributes are the same.

As a test, I shrank a multiple-line entry to 1 line and the font became the smaller size.

Anyone have any ideas?

Thanks, all!

0010 DEF OBJECT EXCEL,"[WDX]EXCEL.APPLICATION"
0020 EXCEL'VISIBLE=1
0030 JUNK=EXCEL'WORKBOOKS'ADD()
0040 SHEET=EXCEL'ACTIVEWORKBOOK'WORKSHEETS(1)
0050 EXCEL'ACTIVEWORKBOOK'SHEETS(1)'NAME$="My Worksheet"
0060 ROW=1,COLUMN=1; SHEET'CELLS(ROW,COLUMN)'VALUE$="MY DATA"

I am attempting to create and update an Excel workbook from within PxPlus. I have read through the documentation and cannot not get it to work. I keep getting error 20's so obviously I do not understand how to format the code correctly.

All I want to do is create a new workbook or overwrite an existing one if it exists. Then I need to add data to the first worksheet within the workbook.

Could someone assist with some simple code to accomplish this.

Much thanks!

Tom Anderson