excel - Load Data From Both TXT and XLS Files in powerbulider -

excel - Load Data From Both TXT and XLS Files in powerbulider -

this question has reply here:

load excel file powerbuilder 1 reply

i trying load info both text , excel files when click on browse button in datawindow. able load info text file not excel,xls file.

here code

long ll_return if dwo.name = "b_browse_meters" // browse button clicked ll_return = getfileopenname ( "select meter file", is_fullname, is_filename, " xls", & " excel files (*.xls), *.xls" ) if ll_return < 1 //messagebox("error", "error selecting meter file...!!!", stopsign!) gnv_msg.f_mensaje("ex28", "", "", ok!) homecoming end if dw_datos_ingreso.object.meters_batch_dir[1] = is_fullname end if // browse button clicked

i don't think can utilize multiple values extension. have "txt, xls". seek passing "" instead.

you don't show actual line of code info import. datawindow not back upwards importing excel files. tab delimited text, csv (comma separated values text) , xml formatted text.

also, please specify version of powerbuilder using.

excel xls ole powerbuilder