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.
University Library Technology Services
[log in to unmask]
"Edward M. Corrado" <[log in to unmask]> wrote:
Yes, by Dublin Core, I mean OAI Dublin Core XML.
On Tue, Mar 1, 2011 at 3:34 PM, Michael J. Giarlo
<[log in to unmask]> wrote:
> 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:
> By "Dublin Core," I assume you mean OAI Dublin Core XML?
> 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