Just saw a .NET email that had this:
http://www.codeproject.com/Articles/1118991/Work-with-Excel-Documents-on-the...
They handle it 3 ways, tow of which can be done from VFP I believe.
On Thu, Aug 18, 2016 at 1:17 PM, Kevin J Cully kjcully@cherokeega.com wrote:
Thank you for the help with that class Christof. I've converted it to be used in Xojo as well.
Is there a way to do calculations into a cell in the export? Example: To put the formula "=SUM(D2:D10)" into a cell so Excel evaluates the expression?
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Wollenhaupt, Christof Sent: Thursday, August 18, 2016 2:00 PM To: profox@leafe.com Subject: Re: Flat file to Excel....but it's got more than 255 columns!
I think Christof had a posting a couple of years ago with a VFP class that would allow for some formatting (Bolds, colors, etc.) of the XML so it looks "nicer" when opened. I think you can even put formulas in the XML and have Excel honor it.
Indeed. The white paper is still on our web site:
http://foxpert.com/docs/excel.en.htm
A sample program is at the bottom
-- Christof
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]