From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.7 required=5.0 tests=AXB_XMAILER_MIMEOLE_OL_024C2, BAYES_00,MAILING_LIST_MULTI autolearn=no autolearn_force=no version=3.4.4 X-Google-Thread: 103376,b424ec4b490c1d84 X-Google-Attributes: gid103376,public X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news1.google.com!news2.google.com!proxad.net!freenix!enst.fr!melchior!cuivre.fr.eu.org!melchior.frmug.org!not-for-mail From: "Andrew" Newsgroups: comp.lang.ada Subject: excel files Date: Wed, 6 Oct 2004 03:52:14 -0600 Organization: Cuivre, Argent, Or Message-ID: References: <20041005193515.6C38A4C409F@lovelace.ada-france.org> NNTP-Posting-Host: lovelace.ada-france.org Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Trace: melchior.cuivre.fr.eu.org 1097055130 94707 212.85.156.195 (6 Oct 2004 09:32:10 GMT) X-Complaints-To: usenet@melchior.cuivre.fr.eu.org NNTP-Posting-Date: Wed, 6 Oct 2004 09:32:10 +0000 (UTC) To: Return-Path: X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at ada-france.org X-BeenThere: comp.lang.ada@ada-france.org X-Mailman-Version: 2.1.4 Precedence: list List-Id: "Gateway to the comp.lang.ada Usenet newsgroup" List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Xref: g2news1.google.com comp.lang.ada:4784 Date: 2004-10-06T03:52:14-06:00 > ------------------------------ > Message: 6 > Date: Tue, 05 Oct 2004 21:00:28 +0200 > From: Alexandre Devaure > Subject: Re: excel files > tmoran@acm.org wrote: > >>Depending on what you have in your Excel file, but you can use it as a DB and > >>use ODBC to access data. > > > > Can you access formulas and formatting via ODBC, or just values in cells? > > What I want is just to read values in cells. > ------------------------------ Then ODBC should work great! I think formulas are returned as the contents of the cell. I speculate that formatting is stored in some hidden property object of the sheet or even worksheet. If you knew which property object then most likely you could create a recordset of the contents of the property object and navigate to alter a cell's formatting. I do know that named regions in a sheet can be accessed via ODBC as a table where the name corresponds to the table name that is specified in the SQL statement. I wonder if there is a way to create a binding to the libraries in Visual Basic. In Visual Basic, and please excuse my "vocabulary" here, you specify which libraries are associated with the project. There is a list and you put little check marks next to the ones you want. Then you can use the object browser to view what features that library adds. Ahhhh, I can't remember all the menu's and menu labels and stuff, darn it. I think I have early onset "old timers" disease. Anyway... Those libraries are dll files (correct me if I am wrong). Isn't there a way to import those into an Ada specification? If you could do that then you could use the object browser in VB as your guide and write in Ada! This way, you could "import" the Excel libraries and use them with the same "robustness" as VB does instead of ODBC. I think someone mentioned something similar to importing dll files with A#. Now if I could just remember who that was... Andrew Carroll Carroll-Tech 720-273-6814 andrew@carroll-tech.net