Sweet. Thanks Tracy.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Tracy Pearson Sent: Thursday, August 18, 2016 3:26 PM To: profox@leafe.com Subject: RE: Flat file to Excel....but it's got more than 255 columns!
<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
This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication.
Thank you.