topic-39738

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

error to import from excel
Posted: Fri Dec 11, 2020 11:32 AM

in 2016 this example worked fine now it doesn't import any records from excel sheet

Function Import()
   Local oRange,lOpened:=.f.


 * oRange   := GetExcelRange( ExePath() + "CLIENTI.xls" )
    oRange   := GetExcelRange( ExePath() + "CLIENTI.xls"  , , @lOpened)


 USE CLIENTI ALIAS CL
 SELECT CL


    FW_ExcelToDBF( oRange, nil, .t. )

    xbrowse()

     oRange   := NIL

return nil

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

FiveTech Support Forums

Continue the discussion