I don't know of anything pre-written, but there's a couple of Perl modules for reading Excel files. I've know I've used the OLE libraries (inherited code) but my memory is rusty. I thought there was another one but couldn't find it. Of course, depending on the format of the data within the excel file, you might just be able to save it as text as you mentioned.
Of course, then there's the question of which type of excel files are you using? The older excel format or the new xml format? The XML format might open up some more possibilities. (You could just write one xsl script after all). To me though it sounds like we might need a little bit more information. After all, excel has no semantic structure. I mean, do you have two columns doing a key/value type thing, columns for each data type, small individual tables, etc? Jon Gorman On Thu, Dec 18, 2008 at 9:03 AM, Jacobs, Jane W <jane.w.jac...@queenslibrary.org> wrote: > Hi Folks, > > > > My New Year's resolution includes trying to wrap my mind around METS > and/or MODS. We recently discussed converting Excel/CSV to MARC, which > I've done. I know there's a schema that will take you from MARC to MODS > and/or MADS (http://www.loc.gov/standards/mods/v3/mods-3-3.xsd) although > I'm fuzzy as to the specifics of implementation. However, that would > mean Excel -> CSV -> MARC -> MODS, YUCK! > > > > Has anyone done any Excel to METS or MODS? If yes, would you be willing > to share some code? > > > > Thanks. > > JJ > > > > > > **Views expressed by the author do not necessarily represent those of > the Queens Library.** > > Jane Jacobs > Asst. Coord., Catalog Division > Queens Borough Public Library > 89-11 Merrick Blvd. > Jamaica, NY 11432 > tel.: (718) 990-0804 > e-mail: jane.w.jac...@queenslibrary.org > FAX. (718) 990-8566 > > > > > > The information contained in this message may be privileged and confidential > and protected from disclosure. If the reader of this message is not the > intended recipient, or an employee or agent responsible for delivering this > message to the intended recipient, you are hereby notified that any > dissemination, distribution or copying of this communication is strictly > prohibited. If you have received this communication in error, please notify > us immediately by replying to the message and deleting it from your computer.
