 |
 |
What about using a vba macro? I have one that you could modify very easily. It will run through the excel data and output a file at the end. Let me know if you'd like to take a look at it. Heather Heather Klish Systems Librarian University Library Technology Services Tufts University [log in to unmask] "Edward M. Corrado" <[log in to unmask]> wrote: Hi Mike, Yes, by Dublin Core, I mean OAI Dublin Core XML. Edward On Tue, Mar 1, 2011 at 3:34 PM, Michael J. Giarlo <[log in to unmask]> wrote: > Edward, > > Because I already have some code lying around that does more or less > the same thing, I'd probably sling some Python using the xlrd library > (N.B. works on xls files but not xlsx files). It'd look similar to > this method, perhaps a little simpler, though this method doesn't > write out a DC file: > > https://github.com/MaxFisher/caps/blob/master/pilot/views.py#L87 > > By "Dublin Core," I assume you mean OAI Dublin Core XML? > > -Mike > > > On Tue, Mar 1, 2011 at 14:53, Edward M. Corrado <[log in to unmask]> wrote: >> Hello all, >> >> I have an excel file that I need to map to Dublin Core. I can think of >> a number of ways to do this, but was wondering if anyone else who has >> done it has a suggestion before I dust off my old sed/awk skills or >> otherwise reinvent the wheel. I looked at Terry Reese's MarcEdit and I >> probably can use that, but it looks like I'd have to intermediately >> convert it to MARC. Either a windows-based program or *nix tool is >> fine. >> >> Edward >> >