Subject Re: IMPORT DATA FROM EXCEL SPREADSHEET
From Ken Mayer <dbase@nospam.goldenstag.net>
Date Wed, 24 May 2017 13:29:23 -0700
Newsgroups dbase.getting-started

On 5/24/2017 11:04 AM, Mustansir Ghor wrote:
> Dear Ken Sir
>
> I ran :dUFLP:ImportData.wfm and is accept xls format for excel sheet. For xlsx files how can we use this program for imports.

Probably make a change in the source to include xlsx as a valid
extension type?

Starting at line 2256:

             case form.SType == "Excel"
                  if __version__ < 2.2
                     form.SourceFilenameEntry.value := ;
                          GetFile( "*.xls, *.xlsx", "Excel Spreadsheet",
true )
                  else
                     form.SourceFilenameEntry.value := ;
                          GetFile( "*.xls, *.xlsx", "Excel Spreadsheet",
true, "XLS" )
                  endif



--
*Ken Mayer*
Ken's dBASE Page: http://www.goldenstag.net/dbase
The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm