Hello dear members of the Community !

My issue is the following :

I need to be able to save the content of a DW in a .xlsx format. We are using Excel 2013 and Excel 2016. I’m working with a version 12.1 of PowerBuilder and migrating it to PowerBuilder 2017.

The deadline we are facing is the “new” version of Microsoft Office suite.

Do I have to import/install a specific .dll for doing this (I red something about PBDWExcel12Interop115.dll for example) ? Where to find this library, where to install it and how ?

Here is the code that is working today (but with .xls).

What do you suggest to change/adapt ?

long                                    ll_rc

edi_w_planification_pip     lw_parent

PARENT.of_getparentwindow(lw_parent)

// REPERTOIRE TEMP

//----------------

// selon variable d'environnement

string                                                     ls_repertoire

ContextKeyword                                lcx_key

string                                                     ls_values[]

n_ds                                                       lds_details_bpc, lds_param_base

lds_details_bpc = CREATE n_ds

lds_details_bpc.DataObject = "d_edi_planif_pip_charge_bpc_det_exp_srv"

lds_details_bpc.of_settransObject(SQLCA)

lds_details_bpc.Retrieve( il_selected_organisme , lw_parent.of_getanpannee())

ll_rc = THIS.GetContextService("ContextKeyword", lcx_key)

ll_rc = lcx_key.GetContextKeyWords("TEMP", ls_values)

ls_repertoire = ls_values[1]

// NOM COMPLET DU FICHIER

//-----------------------

string                                      ls_filename, ls_datetime, ls_cellule, ls_plage

datetime                               ld_datetime

n_cst_string                           lnv_string

ld_datetime = DateTime(Today(), Now())

ls_datetime = string(ld_datetime)

ls_datetime = lnv_string.of_GlobalReplace(ls_datetime, ".", "-")

ls_datetime = lnv_string.of_GlobalReplace(ls_datetime, ":", "-")

ls_filename = ls_repertoire + &

                                                 "\e-DICS-" + &

                                                 ls_datetime + &

                                                 ".xls"

// EXTRACTION

ll_rc = lds_details_bpc.saveas(ls_filename, Excel8!, TRUE)

…