[SOLVED] Export to Excel, Then View Excel File
Hi,
Is there a recommended way in Lianja to export a cursor or table to Excel? I am currently using a routine called VFP2Excel, written by Cetin Basoz, which uses an ADOdb.RecordSet, via "Provider=VFPOLEDB;Data Source=" + Sys(2023) in my Visual Foxpro system. If I use this in Lianja, it kicks out with an error message about an "expected variable". Before I start debugging this, I thought I would ask, in case the "Lianja Way" is still inscrutable to me <g>.
Related to this, can I use "Lianja.showdocument() to present this Excel file on the screen or form? If so, are there any requirements for this, like utilizing a particular section, or initializing code?
Thanks,
Bill