Just saw a .NET email that had this: http://www.codeproject.com/Articles/1118991/Work-with-Excel-Documents-on-the-Server
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 <[email protected]> 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:[email protected]] On Behalf Of Wollenhaupt, > Christof > Sent: Thursday, August 18, 2016 2:00 PM > To: [email protected] > 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] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyjubmy-s37vzqqdbzxzqxv6abuveg9g94+5qfkf3hv...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
