>>>>>>Is there any possibility to print information from Excel sheet?
>>>>>>Without running Excel application?
>>>>>>From report?
>>>>>>
>>>>>>Giedrius
>>>>>
>>>>>You can IMPORT excel data to VFP cursor and use it as report source.
>>>>How it can be done programatically.
>>>
>>>

>>>import from testbook.xls type xl5 sheet cSheetName
>>>* Currently excel97 is not recognized - save as Excel 5.0
>>>*VFP creates a table with field names A,B,C and so on. Tablename is
>>>* same as xls by default
>>>*If a column includes a non-numeric value then a char field is created
>>>

>>>Cetin
>>
>>Hi, But the Date field has changed in show!! Export then Import again!
>>from VFP data ['mm/dd/yy'] Export to Excel [27-Feb-1998]Example!!
>>How about if import from the same file again?? fail in regonize the date field!
>>
>>2nd, if really want to print the Excel graph in Excel Worksheet?!
>>Quite Impossible to do..... ~_~"
>Justok,
>Really I thought someone would tell about dates regarding to my last sentence getting it "should be numeric or char". I meant mixed types.
>Normally Excel date type doesn't have a problem with import or "append from".
>When you use "export" or "copy to" you're creating and Excel file with row 1 having the fieldnames. So when you import all you got is char data with fieldnames in first record, no more datefield to recognize. Instead after export or copy to, try "append from". This would get the data back - just you would have an extra record at the beginning.
>

>use imextest    && Mixed type fields
>export to imextest.xls type xl5
>nDelRec = reccount()+1
>append from imextest.xls type xl5
>delete for recno() = nDelRec


Hi Cetin.. I checked those examples, but they do not say anything about printing an Excel Chart.  The examples use MSGraph.  How can I get an Excel Chart/Graph into a general field?
>

>2nd - It's quite possible to print, create, get to a gen field, change etc an Excel chart via OLE automation. Check the KB\FAQ and solutions.app.
>Cetin