Mr Rao : help for FW_ExcelToDbf

Mr Rao : help for FW_ExcelToDbf

Postby Silvio.Falconi » Tue Nov 17, 2015 10:45 am

Mr Rao,

How I can use this functions FW_ExcelToDbf and FW_DbfToExel ?

I not understood How ... IS THERE A SAMPLE TEST ON .\SAMPLES ?


Can I have a test sample to try ?

Image

I have :

Articoli.xls

some fields to try CODICE,DESCRIZIONE,TIPOLOGIA,CATEGORIA,SOTTOCATEG,UDM.IVA,LISTINO1,LISTINO2,LISTINO3

the first row are Headers of dbf




I made
#include "fivewin.ch"


Function test()
Local oRange,lOpened:=.f.
oRange := GetExcelRange("articoli.xls", , , @lOpened )

USE ARTICOLI ALIAS AR
select AR
FW_ExcelToDBF( oRange, nil, .t. )


return nil


it is compiled but then not save into dbf
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: 6848
Joined: Thu Oct 18, 2012 7:17 pm

Re: Mr Rao : help for FW_ExcelToDbf

Postby Silvio.Falconi » Tue Nov 17, 2015 11:15 am

SORRY

NOW RUN OK ...GOOOOOODDDDDD

only

How can you do to keep the existing values on Dbf when importing empty cells?
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: 6848
Joined: Thu Oct 18, 2012 7:17 pm


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Antonio Linares, Horizon and 48 guests

cron