FiveTech Software tech support forums

Hi Mr. Rao Unresolved external _HB_FUN_FW_GetExcelRange Unresolved external _HB_FUN_xlValue I use FWH 23.07, Thanks Very sorry, I corrected the mistakes. Please see my edited posting again. the functions are: GetExcelRange .. not FW_GetExcelRange ...

Hi Mr. Rao

Unresolved external _HB_FUN_FW_GetExcelRange
Unresolved external _HB_FUN_xlValue

I use FWH 23.07, Thanks

hi, thx for all those Information the *.XLSx was about 17000 x 11 if GetExcelRange() is based on EXCEL than i can´t use it i want to build a Tool which can "read/write" *.XLSx without EXCEL but i must install ADO "Pack" ( Microsoft.ACE.OLEDB.12.0 ...

i wonder "how" GetExcelRange() will work as it "only" Return oRange, not Recorsd-Set :?: GetExcelRange() returns oRange object of oExcel This does not use ADO, but uses Excel OLE. Similar to Word OLE and PowerPoint ...

... to open "same" *.XLSx i was not able to change a CELL in *.XLSx even when "display" in XBROWSE --- i wonder "how" GetExcelRange() will work as it "only" Return oRange, not Recorsd-Set :?: what is   :nEditTypes := { 1,1,1 } i "normal" ...

... folder. It is our oversight and we regret the inconvenience. This is the reason for the crash. This program demonstrates the function oRange   := GetExcelRange( cBook, [cSheet], [cRange] ) cSheet defaults to ActiveSheet and cRange to UsedRange. Please try with any other ...

FWH has built-in functions GetExcelRange() and FW_ExcelToDBF() for this purpose. But your data is huge, better to use a custom approach for this case. 1) Save Excel sheet as CSV and then copy to DBF. OR 2) Reading row by row is ok. Instead, ...

Yes, Thanks Mr. Anser FWH has function for reading Excel with ADO oRs := FW_OpenADOExcelSheet( cFile, [cSheet], [cRange], [lHeaders] )XBROWSER oRs  thanks Mr Nages, I tried with oRange := FW_OpenADOExcelSheet(cFileXls)xbrowser oRange Give me first this Messag...

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 wrote: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

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 E...

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 )

Marc Venken wrote: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

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..

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