Sweet. Thanks Tracy.
-----Original Message-----
From: ProFox [mailto:[email protected]] On Behalf Of Tracy Pearson
Sent: Thursday, August 18, 2016 3:26 PM
To: [email protected]
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.
_______________________________________________
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/f82db4de49440845a14b540f6c2df6a91be...@blufitspmbs01.cherokeega.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.
