GetExcelRange ERROR

[Silvio.Falconi]

Making this sample test I can show any datas, where is the error ?

Code: Select all  Expand view

#include "FiveWin.ch"

Function test()
local cFileXls:="orario.xlsx"
Local oRange,lOpened:=.f.

oRange := GetExcelRange(cFileXls , , @lOpened)

xbrowser oRange

return nil

I check the file with Google Excel and I see there datas as you can see here

[nageswaragunupudi]

GetExcelRange() can not open xls file, if it is already opened by any application other than Microsoft Excel.
Close Google Sheets and try.
Also give full path.

[Silvio.Falconi]

GetExcelRange() can not open xls file, if it is already opened by any application other than Microsoft Excel.
Close Google Sheets and try.
Also give full path.

please I not open the xls file with another app
please do you see my test sample ?
the file orario.xlsx is on the root of exe

[Marc Venken]

Your sample is working here. Just a local file from myself in de exe folder. rest is the same

[Marc Venken]

Silvio, keep in mind that the sample is not killing the object, so exel is still in the taskbar. See into it...

Maybe that is a issue at your site..

[Silvio.Falconi]

Silvio, keep in mind that the sample is not killing the object, so exel is still in the taskbar. See into it...

Maybe that is a issue at your site..

Can I send you a small test ? my mail is silvio_dot_falconi_at_gmail_dot_com

[nageswaragunupudi]

1) Is Microsoft Excel installed on this computer?
Check:
if ExcelObj() == nil
? "Not installed"
else
? "Installed"
endif

2) Also check if file exists with
? File( cFileXls )

[Silvio.Falconi]

1) Is Microsoft Excel installed on this computer?
Check:
if ExcelObj() == nil
? "Not installed"
else
? "Installed"
endif

2) Also check if file exists with
? File( cFileXls )

Sorry Nages,

one question: maybe the problem is that there is no Excel on that computer?

No there is no Excel, discovered the mystery ....

and I was convinced that it could work even without excel

Is there no remote possibility of extracting data from an excel spreadsheet without having Microsoft Excel installed?

[anserkk]

Is there no remote possibility of extracting data from an excel spreadsheet without having Microsoft Excel installed?

You can use ADO to read the Excel data without having Excel installed on your PC

[nageswaragunupudi]

Yes, Thanks Mr. Anser
FWH has function for reading Excel with ADO

Code: Select all  Expand view

oRs := FW_OpenADOExcelSheet( cFile, [cSheet], [cRange], [lHeaders] )
XBROWSER oRs
 

[Silvio.Falconi]

Yes, Thanks Mr. Anser
FWH has function for reading Excel with ADO

Code: Select all  Expand view

oRs := FW_OpenADOExcelSheet( cFile, [cSheet], [cRange], [lHeaders] )
XBROWSER oRs
 

thanks Mr Nages,
I tried with

Code: Select all  Expand view

oRange := FW_OpenADOExcelSheet(cFileXls)
xbrowser oRange

Give me first this Message "ADO ERROR UKNOWN"
and then "fail to open "C:\work\errori\getexelrange\orario.xls"

I think I must install Microsoft.ACE.OLEDB from https://www.microsoft.com/it-it/download/details.aspx?id=13255

another question
I mustuse it on Tables with windows 10 Pro, I would have preferred not to install a lot of software to make the system more free Office would be a bit heavy
If I would install OpenOffice which is free, what function can I use?