FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Problem to download Excel sheet
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Problem to download Excel sheet
Posted: Wed Nov 22, 2017 05:27 PM
I wish import a sheet excel into my dbf ARTICOLI.dbf

this is a image of my sheet excel



the file : https://drive.google.com/open?id=1UMWM7 ... DhzKQH-Uno


My test

Function Import()
Local oRange,lOpened:=.f.
oRange := GetExcelRange("C:\Work\Errori\Importa_e_Export\articoli.xls" , , @lOpened)

USE ARTICOLI ALIAS AR
SELECT AR

FW_ExcelToDBF( oRange, nil, .t. )

xbrowse(oRange)
oRange := NIL

return nil

Not load all fields ... why ?????

I see this :


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
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: Problem to download Excel sheet
Posted: Wed Nov 22, 2017 05:49 PM

Please make sure the datatypes of Excel columns and FieldTypes of the DBF match.

Regards



G. N. Rao.

Hyderabad, India
Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: Problem to download Excel sheet
Posted: Wed Nov 22, 2017 06:08 PM
Resolved!

Someone at school change me the field of column of my sheet ...

Sorry
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

Continue the discussion