Problem to download Excel sheet

Problem to download Excel sheet

Postby Silvio.Falconi » Wed Nov 22, 2017 5:27 pm

I wish import a sheet excel into my dbf ARTICOLI.dbf

this is a image of my sheet excel

Image

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 :


Image
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 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
User avatar
Silvio.Falconi
 
Posts: 6755
Joined: Thu Oct 18, 2012 7:17 pm

Re: Problem to download Excel sheet

Postby nageswaragunupudi » Wed Nov 22, 2017 5:49 pm

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

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10242
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Problem to download Excel sheet

Postby Silvio.Falconi » Wed Nov 22, 2017 6: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 November 2023 - January 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
User avatar
Silvio.Falconi
 
Posts: 6755
Joined: Thu Oct 18, 2012 7:17 pm


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 14 guests