Re: [BLACKBOX] Excel

From: Douglas G. Danforth <"Douglas>
Date: Sun, 31 Jan 2010 23:23:02 -0800

----boundary-LibPST-iamunique-916169357_-_- Content-type: text/plain I just took a look at the Exel file in data mode using BB and see it is not just a text file so ignore my previous comment. Darn, I really didn't want to get into the Active X domain but see it may be necessary. This is all simply to determine whether I should bid on the project. It looks as though I probably should not. I simply need to get the data so I can cluster it for the buyer. -Doug Douglas G. Danforth wrote: 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 Gunnar Bernhardt wrote: Doug, what do you need to do with the MS-Excel file? If you want to access it like a data base (e.g. one row at a time, 1st line indicating Column names), you could try using ADO. This method has it's quirks as well: For instance the Excel file is open exclusively by your application. If you try to access a file, which has already been opened by Excel, you get an error... If you only need to output data, you could simply write a text file separating columns by a tab. Such files will look fine when you open them with Excel. regards gunnar ---- To unsubscribe, send a message with body "SIGNOFF BLACKBOX" to LISTSERV{([at]})nowhere.xy ----boundary-LibPST-iamunique-916169357_-_- Content-type: application/rtf Content-transfer-encoding: base64 Content-Disposition: attachment; filename="rtf-body.rtf" e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbWh0bWwxIFxkZWZmMHtcZm9udHRibA0Ke1xmMFxm c3dpc3NcZmNoYXJzZXQwIEFyaWFsO30NCntcZjFcZm1vZGVybiBDb3VyaWVyIE5ldzt9DQp7XGYy XGZuaWxcZmNoYXJzZXQyIFN5bWJvbDt9DQp7XGYzXGZtb2Rlcm5cZmNoYXJzZXQwIENvdXJpZXIg TmV3O319DQp7XGNvbG9ydGJsXHJlZDBcZ3JlZW4wXGJsdWUwO1xyZWQwXGdyZWVuMFxibHVlMjU1 O30NClx1YzFccGFyZFxwbGFpblxkZWZ0YWIzNjAgXGYwXGZzMjQgDQp7XCpcaHRtbHRhZzI0MyA8 IURPQ1RZUEUgaHRtbCBQVUJMSUMgIi0vL1czQy8vRFREIEhUTUwgNC4wMSBUcmFuc2l0aW9uYWwv L0VOIj59DQp7XCpcaHRtbHRhZzMgXHBhciB9DQp7XCpcaHRtbHRhZzE5IDxodG1sPn0NCntcKlxo dG1sdGFnMiBccGFyIH0NCntcKlxodG1sdGFnMzQgPGhlYWQ+fQ0Ke1wqXGh0bWx0YWcxIFxwYXIg fQ0Ke1wqXGh0bWx0YWcyNDEgICB9DQp7XCpcaHRtbHRhZzEgXHBhciB9DQp7XCpcaHRtbHRhZzQx IDwvaGVhZD59DQp7XCpcaHRtbHRhZzIgXHBhciB9DQp7XCpcaHRtbHRhZzUwIDxib2R5IGJnY29s b3I9IiNmZmZmZmYiIHRleHQ9IiMwMDAwMDAiPn1caHRtbHJ0ZiBcdmlld2tpbmQ1DQp7XCpcYmFj a2dyb3VuZCB7XHNocHtcKlxzaHBpbnN0e1xzcHtcc24gZmlsbENvbG9yfXtcc3YgMTY3NzcyMTV9 fXtcc3B7XHNuIGZGaWxsZWR9e1xzdiAxfX19fX1caHRtbHJ0ZjAgDQp7XCpcaHRtbHRhZzAgXHBh ciB9e1wqXGh0bWx0YWc2NH1caHRtbHJ0ZiB7XGh0bWxydGYwIEkganVzdCB0b29rIGEgbG9vayBh dCB0aGUgRXhlbCBmaWxlIGluIGRhdGEgbW9kZSB1c2luZyBCQiBhbmQgc2VlIGl0IGlzDQp7XCpc aHRtbHRhZzQgXHBhciB9XGh0bWxydGYgIFxodG1scnRmMCBub3QNCntcKlxodG1sdGFnMTE2IDxi cj59XGh0bWxydGYgXGxpbmUNClxodG1scnRmMCANCntcKlxodG1sdGFnNCBccGFyIH1qdXN0IGEg dGV4dCBmaWxlIHNvIGlnbm9yZSBteSBwcmV2aW91cyBjb21tZW50Lg0Ke1wqXGh0bWx0YWc4NCAm bmJzcDt9XGh0bWxydGYgXCdhMFxodG1scnRmMCAgRGFybiwNCntcKlxodG1sdGFnODQgJm5ic3A7 fVxodG1scnRmIFwnYTBcaHRtbHJ0ZjAgIEkgcmVhbGx5IGRpZG4ndA0Ke1wqXGh0bWx0YWc0IFxw YXIgfVxodG1scnRmICBcaHRtbHJ0ZjAgd2FudA0Ke1wqXGh0bWx0YWcxMTYgPGJyPn1caHRtbHJ0 ZiBcbGluZQ0KXGh0bWxydGYwIA0Ke1wqXGh0bWx0YWc0IFxwYXIgfXRvIGdldCBpbnRvIHRoZSBB Y3RpdmUgWCBkb21haW4gYnV0IHNlZSBpdCBtYXkgYmUgbmVjZXNzYXJ5Lg0Ke1wqXGh0bWx0YWcx MTYgPGJyPn1caHRtbHJ0ZiBcbGluZQ0KXGh0bWxydGYwIA0Ke1wqXGh0bWx0YWc0IFxwYXIgfVRo aXMgaXMgYWxsIHNpbXBseSB0byBkZXRlcm1pbmUgd2hldGhlciBJIHNob3VsZCBiaWQgb24gdGhl IHByb2plY3QuDQp7XCpcaHRtbHRhZzExNiA8YnI+fVxodG1scnRmIFxsaW5lDQpcaHRtbHJ0ZjAg DQp7XCpcaHRtbHRhZzQgXHBhciB9SXQgbG9va3MgYXMgdGhvdWdoIEkgcHJvYmFibHkgc2hvdWxk IG5vdC4NCntcKlxodG1sdGFnMTE2IDxicj59XGh0bWxydGYgXGxpbmUNClxodG1scnRmMCANCntc KlxodG1sdGFnNCBccGFyIH0NCntcKlxodG1sdGFnMTE2IDxicj59XGh0bWxydGYgXGxpbmUNClxo dG1scnRmMCANCntcKlxodG1sdGFnNCBccGFyIH1JIHNpbXBseSBuZWVkIHRvIGdldCB0aGUgZGF0 YSBzbyBJIGNhbiBjbHVzdGVyIGl0IGZvciB0aGUgYnV5ZXIuDQp7XCpcaHRtbHRhZzExNiA8YnI+ fVxodG1scnRmIFxsaW5lDQpcaHRtbHJ0ZjAgDQp7XCpcaHRtbHRhZzQgXHBhciB9DQp7XCpcaHRt bHRhZzExNiA8YnI+fVxodG1scnRmIFxsaW5lDQpcaHRtbHJ0ZjAgDQp7XCpcaHRtbHRhZzQgXHBh ciB9LURvdWcNCntcKlxodG1sdGFnMTE2IDxicj59XGh0bWxydGYgXGxpbmUNClxodG1scnRmMCAN CntcKlxodG1sdGFnNCBccGFyIH0NCntcKlxodG1sdGFnMTE2IDxicj59XGh0bWxydGYgXGxpbmUN ClxodG1scnRmMCANCntcKlxodG1sdGFnNCBccGFyIH0NCntcKlxodG1sdGFnMTE2IDxicj59XGh0 bWxydGYgXGxpbmUNClxodG1scnRmMCANCntcKlxodG1sdGFnNCBccGFyIH1Eb3VnbGFzIEcuIERh bmZvcnRoIHdyb3RlOg0Ke1wqXGh0bWx0YWc0IFxwYXIgfVxodG1scnRmICBcaHRtbHJ0ZjAge1wq XGh0bWx0YWc3Mn1caHRtbHJ0ZlxwYXJ9XGh0bWxydGYwDQoNCntcKlxodG1sdGFnOTYgPGJsb2Nr cXVvdGUgY2l0ZT0ibWlkOjRCNjY3RDVDLjgwMDAxMDhAZ3JlZW53b29kZmFybS5jb20iIHR5cGU9 ImNpdGUiPn1caHRtbHJ0ZiBccGFyDQp7XGh0bWxydGYwIA0Ke1wqXGh0bWx0YWcwIFxwYXIgfQ0K e1wqXGh0bWx0YWcyNDAgICB9DQp7XCpcaHRtbHRhZzE2MCA8bWV0YSBjb250ZW50PSJ0ZXh0L2h0 bWw7Y2hhcnNldD1JU08tODg1OS0xIiBodHRwLWVxdWl2PSJDb250ZW50LVR5cGUiPn0NCntcKlxo dG1sdGFnMCBccGFyIH17XCpcaHRtbHRhZzY0fVxodG1scnRmIHtcaHRtbHJ0ZjAgXGxpMzYwIEd1 bm5hciwNCntcKlxodG1sdGFnMTE2IDxicj59XGh0bWxydGYgXGxpbmUNClxodG1scnRmMCANCntc KlxodG1sdGFnNCBccGFyIH1JZiB0aGF0IGlzIHRoZSBleHRlbnQgb2YgdGhlIGNvbXBsZXhpdHkg b2YgYW4gRXhjZWwgZmlsZSB0aGFuIHRoYXQgaXMNCntcKlxodG1sdGFnNCBccGFyIH1caHRtbHJ0 ZiAgXGh0bWxydGYwIGVhc3kuDQp7XCpcaHRtbHRhZzExNiA8YnI+fVxodG1scnRmIFxsaW5lDQpc aHRtbHJ0ZjAgDQp7XCpcaHRtbHRhZzQgXHBhciB9SSBhbSBhIG5vdmljZSB0byBFeGNlbC4NCntc KlxodG1sdGFnODQgJm5ic3A7fVxodG1scnRmIFwnYTBcaHRtbHJ0ZjAgIFNvIHRoZSBmaWVsZHMg b2YgdGhlIGZpbGUgYXJlIHNpbXBseSAnLCcNCntcKlxodG1sdGFnNCBccGFyIH1caHRtbHJ0ZiAg XGh0bWxydGYwIHNlcGFyYXRlZCBhbmQNCntcKlxodG1sdGFnMTE2IDxicj59XGh0bWxydGYgXGxp bmUNClxodG1scnRmMCANCntcKlxodG1sdGFnNCBccGFyIH10aGUgZW5kIG9mIGEgcm93IGlzIGp1 c3QgYW4gZW9sPw0Ke1wqXGh0bWx0YWcxMTYgPGJyPn1caHRtbHJ0ZiBcbGluZQ0KXGh0bWxydGYw IA0Ke1wqXGh0bWx0YWc0IFxwYXIgfQ0Ke1wqXGh0bWx0YWc4NCAgIH0NCntcKlxodG1sdGFnMTE2 IDxicj59XGh0bWxydGYgXGxpbmUNClxodG1scnRmMCANCntcKlxodG1sdGFnNCBccGFyIH1XaGF0 IGlzIEFETz8gDQp7XCpcaHRtbHRhZzExNiA8YnI+fVxodG1scnRmIFxsaW5lDQpcaHRtbHJ0ZjAg DQp7XCpcaHRtbHRhZzQgXHBhciB9DQp7XCpcaHRtbHRhZzg0ICAgfXtcKlxodG1sdGFnNzJ9XGh0 bWxydGZccGFyfVxodG1scnRmMA0KDQp7XCpcaHRtbHRhZzY0IDxoMSBpZD0iZmlyc3RIZWFkaW5n IiBjbGFzcz0iZmlyc3RIZWFkaW5nIj59XGh0bWxydGYge1xmczQ4IFxwYXJcYiBcaHRtbHJ0ZjAg XGh0bWxydGYge1xodG1scnRmMCBcbGkzNjAgXGh0bWxydGYge1xmczQ4IFxodG1scnRmMCANCntc KlxodG1sdGFnMTQ4IDxzbWFsbD59XGh0bWxydGYge1xmczM2IFxodG1scnRmMCANCntcKlxodG1s dGFnMTQ4IDxzbWFsbD59XGh0bWxydGYge1xmczI4IFxodG1scnRmMCANCntcKlxodG1sdGFnMTQ4 IDxzbWFsbD59XGh0bWxydGYge1xmczI0IFxodG1scnRmMCBBY3RpdmVYDQp7XCpcaHRtbHRhZzQg XHBhciB9XGh0bWxydGYgIFxodG1scnRmMCBEYXRhIE9iamVjdHM/DQp7XCpcaHRtbHRhZzE1NiA8 L3NtYWxsPn1caHRtbHJ0ZiB9XGh0bWxydGYwIA0Ke1wqXGh0bWx0YWcxNTYgPC9zbWFsbD59XGh0 bWxydGYgfVxodG1scnRmMCANCntcKlxodG1sdGFnMTU2IDwvc21hbGw+fVxodG1scnRmIH1caHRt bHJ0ZjAgXGh0bWxydGYgfVxodG1scnRmMCBcaHRtbHJ0ZlxwYXJ9XGh0bWxydGYwDQpcaHRtbHJ0 ZiBccGFyIH1caHRtbHJ0ZjAgDQp7XCpcaHRtbHRhZzcyIDwvaDE+fQ0Ke1wqXGh0bWx0YWcwIFxw YXIgfXtcKlxodG1sdGFnNjR9XGh0bWxydGYge1xodG1scnRmMCBcbGkzNjAgSXMgdGhhdCByZWFs bHkgbmVjZXNzYXJ5Pw0Ke1wqXGh0bWx0YWcxMTYgPGJyPn1caHRtbHJ0ZiBcbGluZQ0KXGh0bWxy dGYwIA0Ke1wqXGh0bWx0YWc0IFxwYXIgfS1Eb3VnDQp7XCpcaHRtbHRhZzExNiA8YnI+fVxodG1s cnRmIFxsaW5lDQpcaHRtbHJ0ZjAgDQp7XCpcaHRtbHRhZzQgXHBhciB9DQp7XCpcaHRtbHRhZzg0 ICAgfQ0Ke1wqXGh0bWx0YWcxMTYgPGJyPn1caHRtbHJ0ZiBcbGluZQ0KXGh0bWxydGYwIA0Ke1wq XGh0bWx0YWc0IFxwYXIgfQ0Ke1wqXGh0bWx0YWc4NCAgIH0NCntcKlxodG1sdGFnMTE2IDxicj59 XGh0bWxydGYgXGxpbmUNClxodG1scnRmMCANCntcKlxodG1sdGFnNCBccGFyIH1HdW5uYXIgQmVy bmhhcmR0IHdyb3RlOg0Ke1wqXGh0bWx0YWc0IFxwYXIgfVxodG1scnRmICBcaHRtbHJ0ZjAgDQp7 XCpcaHRtbHRhZzg0ICAgfXtcKlxodG1sdGFnNzJ9XGh0bWxydGZccGFyfVxodG1scnRmMA0KDQp7 XCpcaHRtbHRhZzk2IDxibG9ja3F1b3RlIGNpdGU9Im1pZDo0QjY2NzgwQy41MDMwNDA0QHZkaS5k ZSIgdHlwZT0iY2l0ZSI+fVxodG1scnRmIFxwYXINCntcaHRtbHJ0ZjAgDQp7XCpcaHRtbHRhZzAg XHBhciB9DQp7XCpcaHRtbHRhZzI0MCAgICAgfQ0Ke1wqXGh0bWx0YWcxNjAgPG1ldGEgY29udGVu dD0idGV4dC9odG1sO2NoYXJzZXQ9SVNPLTg4NTktMSJccGFyICBodHRwLWVxdWl2PSJDb250ZW50 LVR5cGUiPn0NCntcKlxodG1sdGFnMCBccGFyIH0NCntcKlxodG1sdGFnMjQwICAgICB9DQp7XCpc aHRtbHRhZzE3NiA8dGl0bGU+fQ0Ke1wqXGh0bWx0YWcyNDAgfQ0Ke1wqXGh0bWx0YWcxODQgPC90 aXRsZT59DQp7XCpcaHRtbHRhZzAgXHBhciB9e1wqXGh0bWx0YWc2NH1caHRtbHJ0ZiB7XGh0bWxy dGYwIFxsaTcyMCBEb3VnLA0Ke1wqXGh0bWx0YWcxMTYgPGJyPn1caHRtbHJ0ZiBcbGluZQ0KXGh0 bWxydGYwIA0Ke1wqXGh0bWx0YWc0IFxwYXIgfQ0Ke1wqXGh0bWx0YWc4NCAgICAgfQ0Ke1wqXGh0 bWx0YWcxMTYgPGJyPn1caHRtbHJ0ZiBcbGluZQ0KXGh0bWxydGYwIA0Ke1wqXGh0bWx0YWc0IFxw YXIgfXdoYXQgZG8geW91IG5lZWQgdG8gZG8gd2l0aCB0aGUgTVMtRXhjZWwgZmlsZT8gSWYgeW91 IHdhbnQgdG8gYWNjZXNzIGl0DQp7XCpcaHRtbHRhZzQgXHBhciB9XGh0bWxydGYgIFxodG1scnRm MCBsaWtlIGEgZGF0YSBiYXNlIChlLmcuIG9uZSByb3cgYXQgYSB0aW1lLCAxc3QgbGluZSBpbmRp Y2F0aW5nIENvbHVtbg0Ke1wqXGh0bWx0YWc0IFxwYXIgfVxodG1scnRmICBcaHRtbHJ0ZjAgbmFt ZXMpLCB5b3UgY291bGQgdHJ5IHVzaW5nIEFETy4NCntcKlxodG1sdGFnMTE2IDxicj59XGh0bWxy dGYgXGxpbmUNClxodG1scnRmMCANCntcKlxodG1sdGFnNCBccGFyIH1UaGlzIG1ldGhvZCBoYXMg aXQncyBxdWlya3MgYXMgd2VsbDogRm9yIGluc3RhbmNlIHRoZSBFeGNlbCBmaWxlIGlzDQp7XCpc aHRtbHRhZzQgXHBhciB9XGh0bWxydGYgIFxodG1scnRmMCBvcGVuIGV4Y2x1c2l2ZWx5IGJ5IHlv dXIgYXBwbGljYXRpb24uDQp7XCpcaHRtbHRhZzQgXHBhciB9XGh0bWxydGYgIFxodG1scnRmMCBJ ZiB5b3UgdHJ5IHRvIGFjY2VzcyBhIGZpbGUsIHdoaWNoIGhhcyBhbHJlYWR5IGJlZW4gb3BlbmVk IGJ5IEV4Y2VsLA0Ke1wqXGh0bWx0YWc0IFxwYXIgfVxodG1scnRmICBcaHRtbHJ0ZjAgeW91IGdl dCBhbiBlcnJvci4uLg0Ke1wqXGh0bWx0YWcxMTYgPGJyPn1caHRtbHJ0ZiBcbGluZQ0KXGh0bWxy dGYwIA0Ke1wqXGh0bWx0YWc0IFxwYXIgfQ0Ke1wqXGh0bWx0YWc4NCAgICAgfQ0Ke1wqXGh0bWx0 YWcxMTYgPGJyPn1caHRtbHJ0ZiBcbGluZQ0KXGh0bWxydGYwIA0Ke1wqXGh0bWx0YWc0IFxwYXIg fUlmIHlvdSBvbmx5IG5lZWQgdG8gb3V0cHV0IGRhdGEsIHlvdSBjb3VsZCBzaW1wbHkgd3JpdGUg YSB0ZXh0IGZpbGUNCntcKlxodG1sdGFnNCBccGFyIH1caHRtbHJ0ZiAgXGh0bWxydGYwIHNlcGFy YXRpbmcgY29sdW1ucyBieSBhIHRhYi4gU3VjaCBmaWxlcyB3aWxsIGxvb2sgZmluZSB3aGVuIHlv dSBvcGVuDQp7XCpcaHRtbHRhZzQgXHBhciB9XGh0bWxydGYgIFxodG1scnRmMCB0aGVtIHdpdGgg RXhjZWwuDQp7XCpcaHRtbHRhZzExNiA8YnI+fVxodG1scnRmIFxsaW5lDQpcaHRtbHJ0ZjAgDQp7 XCpcaHRtbHRhZzQgXHBhciB9DQp7XCpcaHRtbHRhZzg0ICAgICB9DQp7XCpcaHRtbHRhZzExNiA8 YnI+fVxodG1scnRmIFxsaW5lDQpcaHRtbHJ0ZjAgDQp7XCpcaHRtbHRhZzQgXHBhciB9cmVnYXJk cw0Ke1wqXGh0bWx0YWcxMTYgPGJyPn1caHRtbHJ0ZiBcbGluZQ0KXGh0bWxydGYwIA0Ke1wqXGh0 bWx0YWc0IFxwYXIgfWd1bm5hcg0Ke1wqXGh0bWx0YWcxMTYgPGJyPn1caHRtbHJ0ZiBcbGluZQ0K XGh0bWxydGYwIA0Ke1wqXGh0bWx0YWc0IFxwYXIgfQ0Ke1wqXGh0bWx0YWc4NCAgICAgfQ0Ke1wq XGh0bWx0YWcxMTYgPGJyPn1caHRtbHJ0ZiBcbGluZQ0KXGh0bWxydGYwIA0Ke1wqXGh0bWx0YWc0 IFxwYXIgfQ0Ke1wqXGh0bWx0YWc4NCAgIH17XCpcaHRtbHRhZzcyfVxodG1scnRmXHBhcn1caHRt bHJ0ZjANCg0Ke1wqXGh0bWx0YWcxMDQgPC9ibG9ja3F1b3RlPn1caHRtbHJ0ZiB9XHBhcg0KXGh0 bWxydGYwIA0Ke1wqXGh0bWx0YWcwIFxwYXIgfQ0Ke1wqXGh0bWx0YWcxMDQgPC9ibG9ja3F1b3Rl Pn1caHRtbHJ0ZiB9XGh0bWxydGYwIA0Ke1wqXGh0bWx0YWcwIFxwYXIgfQ0Ke1wqXGh0bWx0YWc1 OCA8L2JvZHk+fQ0Ke1wqXGh0bWx0YWcyIFxwYXIgfQ0Ke1wqXGh0bWx0YWcyNyA8L2h0bWw+fQ0K e1wqXGh0bWx0YWczIFxwYXIgfQ0Ke1wqXGh0bWx0YWc2NCA8cD59XGh0bWxydGYge1xodG1scnRm MCANCntcKlxodG1sdGFnNCBccGFyIH0tLS0tDQp7XCpcaHRtbHRhZzQgXHBhciB9XGh0bWxydGYg IFxodG1scnRmMCBUbyB1bnN1YnNjcmliZSwgc2VuZCBhIG1lc3NhZ2Ugd2l0aCBib2R5ICJTSUdO T0ZGIEJMQUNLQk9YIiB0byBMSVNUU0VSVkBMSVNUUy5PQkVST04uQ0gNCntcKlxodG1sdGFnNCBc cGFyIH1caHRtbHJ0ZiAgXGh0bWxydGYwIFxodG1scnRmXHB9fQBSaFp6UWdYSEJoY2k= ----boundary-LibPST-iamunique-916169357_-_--- Received on Mon Feb 01 2010 - 08:23:02 UTC