FiveTech Software tech support forums

hi Enrico, this is:

Please try with the FILE() function:

Code: Select all  Expand view

? FILE( cPath+alltrim(aFile[nZ]) )

EMG

hi Enrico,

Code: Select all  Expand view

msginfo(cPath+alltrim(aFile[nZ]))
oRange  := GetExcelRange(cPath+alltrim(aFile[nZ]), , , @lOpened )

this is msginfo:
S:\PREVENTIVI\ANNO_2018\dado_08 04 2018.xls

and this is GetExcelRange:

Try this:

Code: Select all  Expand view

? FILE( cPath+cFile )

EMG

hi, I try to use GetExcelRange function and works with file excel on my pc but not work in lan. this works: cPath = "c:\myfolder\"cFile = "myfile.xls"GetExcelRange(cPath+cFile, , , @lOpened ) I have a folder in ...

Thank Rao ,
works perfectly

Maurizio
www.nipeservice.com

Mr Silvio You stored the values in Excel in text format. So the same text values are read from the range and you do not see any difference. But storing Dates, DateTime values and Time valeus as Text in Excel is not the best practice because these values cannot be used for computations. Mr. Maurizio ...

I tried and run ok

do you tried to converte in text format ?

Hello Rao ,

I use GetExcelRange to import from Excel .
When in Excel I have a column format time ex : 08:50:00
GetExcelRange returns 0.33

Thanks in anticipations

yes of course

Sylvio

Did you try with this code?

Code: Select all  Expand view

XBROWSER oRange SETUP ( oBrw:prezzonetto:cEditPicture := "9.999999" )
 

... the file : https://drive.google.com/open?id=1UMWM7qbkvNAhFkkaWoQX0zDhzKQH-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. ...

here I have this : on sheet excel https://s17.postimg.org/whspdbxvz/prezzi.png When run the test https://s17.postimg.org/8o9g8hoxb/test_maurizio.jpg there is something of wrong ... why change the value ? look price articles... the price is changed why it rounds to the...

Thanks Enrico and RAO
works with both
Maurizio