It seems that an empty cell in an Excel spreadsheet returns different values, depending on whether it's being read from VFP7 or VFP6.
I created a c:\test.xls with nothing in cell A1.
Could someone please try the following .PRG in VFP7 & VFP6:
LOCAL XLApp, x, lcFileName
lcfilename = 'c:\test.xls'
XLApp = CreateObject('Excel.application')
XLApp.WorkBooks.Open(lcFileName)
x = xlapp.workbooks(1).sheets(1).cells(1, 1).value
=messagebox(vartype(x))
XLApp.quit()
I get "C" in VFP6, and "X" (.NULL.) in VFP7.
Anyone else seeing this? Our clients are getting erroneous results because I'm checking if the cell in a spreadsheet is empty. When it's .NULL., the EMPTY( ) check comes up False.
- George