Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VF-EXCEL
- Thread starter Prusso
- Start date
Mike Gagnon
Programmer
VFP has an import function
File - > Import (Microsoft Excel 5.0 and 97)
File - > Import (Microsoft Excel 5.0 and 97)
If you want to read a specific cell from an Excel file, OLE is a solution.
oExcel=CreateObject("excel.application"
WITH oExcel
.Workbooks.Open("C:\SALARY.xls"
.Sheets(1).Select
.Range("C11".Select
nSalary = VAL(.ActiveCell.FormulaR1C1)
.ActiveWorkbook.Close(.F.)
ENDIF
.....
oExcel=CreateObject("excel.application"
WITH oExcel
.Workbooks.Open("C:\SALARY.xls"
.Sheets(1).Select
.Range("C11"
.SelectnSalary = VAL(.ActiveCell.FormulaR1C1)
.ActiveWorkbook.Close(.F.)
ENDIF
.....
- Status
Similar threads
