Import only the result from the excelfile

[FILIPM]

hey guys,

i have a problem with complicated formula's.
the only way they exist now is in an excel file.
is it possible that i make a dbf file with
for example : formulazone = excel sheet
and formularesul = excel sheet.cell

Can i import only the result from the excelfile.
Otherways said can i in a easy way import only one cell from a excel sheet without importing the whole sheet in a dbf file.

thanks,

 

[mkrausnick]

do a keyword search on "update exe" (without the quotes). Several threads come up and one of them might be useful to you.

Hint: Use the "Keyword search" tab button next to the "Forum" tab button.

Mike Krausnick

 

[AirCon]

Hi FILIPM

Try this:

oXLA = CreateObject('Excel.Application')
oXLA.Workbooks.Open('A.XLS')
oXLS = oXLA.Sheets(1)

** Get value from cell A15
nValue = oXLS.Cells(1,15).Value

** Get formula from cell A15
cFormula = oXLS.Cells(1,15).Formula

oXLA.DisplayAlerts = .F.
oXLA.Workbooks.Close()
oXLA.Quit


-- AirCon --