Kevin J Cully wrote on 2016-08-18:
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
Kevin,
I liked the idea of creating an xml file that Excel could open. So I tested and found a way to use a formula. (I saved a worksheet with a formula to the XML format.)
<Cell ss:Formula="=COUNT(RC[-1]:R[9]C[-1])"> <Data ss:Type="Number">0</Data> </Cell>
You can also use a formula in a single-mapped cell, if the cell is mapped to an XML element with an XML Schema Definition (XSD) data type that Excel interprets as a number, date, or time. Pulled from here: https://support.office.com/en-us/article/Overview-of-XML-in-Excel-f11faa7e-6 3ae-4166-b3ac-c9e9752a7d80
Tracy Pearson PowerChurch Software