Hi, I recently did some coding for Excel -> MARC/MARCXML/MARCMaker/ISIS within a CGI application. MARCXML to MODS crosswalk should be trivial (Vortex [1] provides it), although I never tried my hand in it. I used the following modules for my app:
Spreadsheet::ParseExcel::Simple (for read-only parsing of Excel, platform-independent) MARC::Record MARC::File::USMARC (comes default with MARC::Record) MARC::File::XML MARC::File::MARCMaker MARC::File::ISIS (a customized version of MARC::File::USMARC for ISIS format, modified ISO2709, used mostly by CDS/ISIS) and of course the CGI related modules. I've used Win32::OLE in the past for reading/writing Excel. Though it is much more powerful, it requires Excel installed on the host machine. I would be glad to share the code, mostly object-oriented. Let me know if you are interested. [1] http://www.vtls.com/opensource/vortex Regards, Saiful -- Saiful Amin +91-9343826438 On Thu, Dec 18, 2008 at 8:33 PM, 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 >
