>I need to generate some spreadsheets for a client on a regular basis. I know I can use SAVE AS XLS to get my cursor into spreadsheet format, but it looks very bad in the spreadsheet, and the column headers are uncontrollable. I could pretty it up in Excel or Quattro, but I'd have to do that every time I generated new data.
>
>I guess I could create a good looking spreadsheet and link values from my ugly spreadsheet, but that makes things too complex for the spreadsheet recipients.
>
>So, what would be the most straightforward way of generating good looking spreadsheets from FoxPro data?
>
Use Excel's automation object to place and format the data, rather than just doing a SAVE AS ... TYPE XLS.