Re: [BLACKBOX] Excel

From: [at]} <Chris>
Date: Mon, 1 Feb 2010 17:46:53 +1030

----boundary-LibPST-iamunique-1263657705_-_-
Content-type: text/plain

Doug,

It depends on what the Excel file contains. If each cell just contains
simple data like a number or a string then the file can be saved as a simple
CSV or TSV text file. Similarly CSV and TSV files can be opened in Excel.
However, it is not that easy if the file contains multiple worksheets,
formulae, functions, cross-references etc. etc.

Regards,
Chris

Chris Burrows
CFB Software
http://www.cfbsoftware.com
 
________________________________

        From: BlackBox [mailto:BLACKBOX{([at]})nowhere.xy
Douglas G. Danforth
        Sent: Monday, 1 February 2010 5:36 PM
        To: BLACKBOX{([at]})nowhere.xy
        Subject: Re: [BLACKBOX] Excel
        
        
        Gunnar,
        If that is the extent of the complexity of an Excel file than that
is easy.
        I am a novice to Excel. So the fields of the file are simply ','
separated and
        the end of a row is just an eol?
        
        What is ADO?
        

        ActiveX Data Objects?

        Is that really necessary?
        -Doug
        

----
To unsubscribe, send a message with body "SIGNOFF BLACKBOX" to LISTSERV{([at]})nowhere.xy----boundary-LibPST-iamunique-1263657705_-_-
Content-type: application/rtf
Content-transfer-encoding: base64
Content-Disposition: attachment; filename="rtf-body.rtf"
e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYwXGZz
d2lzcyBBcmlhbDt9DQp7XGYxXGZtb2Rlcm4gQ291cmllciBOZXc7fQ0Ke1xmMlxmbmlsXGZjaGFy
c2V0MiBTeW1ib2w7fQ0Ke1xmM1xmbW9kZXJuXGZjaGFyc2V0MCBDb3VyaWVyIE5ldzt9fQ0Ke1xj
b2xvcnRibFxyZWQwXGdyZWVuMFxibHVlMDtccmVkMFxncmVlbjBcYmx1ZTI1NTt9DQpcdWMxXHBh
cmRccGxhaW5cZGVmdGFiMzYwIFxmMFxmczIwIERvdWcsXHBhcg0KXHBhcg0KSXQgZGVwZW5kcyBv
biB3aGF0IHRoZSBFeGNlbCBmaWxlIGNvbnRhaW5zLiBJZiBlYWNoIGNlbGwganVzdCBjb250YWlu
c1xwYXINCnNpbXBsZSBkYXRhIGxpa2UgYSBudW1iZXIgb3IgYSBzdHJpbmcgdGhlbiB0aGUgZmls
ZSBjYW4gYmUgc2F2ZWQgYXMgYSBzaW1wbGVccGFyDQpDU1Ygb3IgVFNWIHRleHQgZmlsZS4gU2lt
aWxhcmx5IENTViBhbmQgVFNWIGZpbGVzIGNhbiBiZSBvcGVuZWQgaW4gRXhjZWwuXHBhcg0KSG93
ZXZlciwgaXQgaXMgbm90IHRoYXQgZWFzeSBpZiB0aGUgZmlsZSBjb250YWlucyBtdWx0aXBsZSB3
b3Jrc2hlZXRzLFxwYXINCmZvcm11bGFlLCBmdW5jdGlvbnMsIGNyb3NzLXJlZmVyZW5jZXMgZXRj
LiBldGMuXHBhcg0KXHBhcg0KUmVnYXJkcyxccGFyDQpDaHJpc1xwYXINClxwYXINCkNocmlzIEJ1
cnJvd3NccGFyDQpDRkIgU29mdHdhcmVccGFyDQpodHRwOi8vd3d3LmNmYnNvZnR3YXJlLmNvbVxw
YXINCiBccGFyDQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX1xwYXINClxwYXINClx0
YWIgRnJvbTogQmxhY2tCb3ggW21haWx0bzpCTEFDS0JPWEBMSVNUUy5PQkVST04uQ0hdIE9uIEJl
aGFsZiBPZlxwYXINCkRvdWdsYXMgRy4gRGFuZm9ydGhccGFyDQpcdGFiIFNlbnQ6IE1vbmRheSwg
MSBGZWJydWFyeSAyMDEwIDU6MzYgUE1ccGFyDQpcdGFiIFRvOiBCTEFDS0JPWEBMSVNUUy5PQkVS
T04uQ0hccGFyDQpcdGFiIFN1YmplY3Q6IFJlOiBbQkxBQ0tCT1hdIEV4Y2VsXHBhcg0KXHRhYiBc
cGFyDQpcdGFiIFxwYXINClx0YWIgR3VubmFyLFxwYXINClx0YWIgSWYgdGhhdCBpcyB0aGUgZXh0
ZW50IG9mIHRoZSBjb21wbGV4aXR5IG9mIGFuIEV4Y2VsIGZpbGUgdGhhbiB0aGF0XHBhcg0KaXMg
ZWFzeS5ccGFyDQpcdGFiIEkgYW0gYSBub3ZpY2UgdG8gRXhjZWwuICBTbyB0aGUgZmllbGRzIG9m
IHRoZSBmaWxlIGFyZSBzaW1wbHkgJywnXHBhcg0Kc2VwYXJhdGVkIGFuZFxwYXINClx0YWIgdGhl
IGVuZCBvZiBhIHJvdyBpcyBqdXN0IGFuIGVvbD9ccGFyDQpcdGFiIFxwYXINClx0YWIgV2hhdCBp
cyBBRE8/IFxwYXINClx0YWIgXHBhcg0KXHBhcg0KXHRhYiBBY3RpdmVYIERhdGEgT2JqZWN0cz9c
cGFyDQpccGFyDQpcdGFiIElzIHRoYXQgcmVhbGx5IG5lY2Vzc2FyeT9ccGFyDQpcdGFiIC1Eb3Vn
XHBhcg0KXHRhYiBccGFyDQpccGFyDQpccGFyDQotLS0tXHBhcg0KVG8gdW5zdWJzY3JpYmUsIHNl
bmQgYSBtZXNzYWdlIHdpdGggYm9keSAiU0lHTk9GRiBCTEFDS0JPWCIgdG8gTElTVFNFUlZATElT
VFMuT0JFUk9OLkNIXH19AAAaAA==
----boundary-LibPST-iamunique-1263657705_-_---

Received on Mon Feb 01 2010 - 08:16:53 UTC