OnDemand User Group

Support Forums => MP Server => Topic started by: kbsiva on April 26, 2012, 01:10:17 PM

Title: Excel indexer?
Post by: kbsiva on April 26, 2012, 01:10:17 PM

Hello Folks,
   Just like the PDF indexer do we have an indexer for Excel in CMOD? I know we can  use Generic indexing for Excel spread sheets which does not give me burst options. But outside of IBM is there a plugin that allows us to burst and index based on excel data? Do you know if monarch or any of these companies offer stuff like that?

Thanks
kbs

Title: Re: Excel indexer?
Post by: Alessandro Perucchi on April 27, 2012, 06:35:15 AM

Well, I don't know such indexer, but surely something like that could be easily be programmed in Perl, python, ruby, java, ... (for example
!) :-) according that there are not too many macros :-D especially if it needs to index a field that is generated with a macro!

sincerely yours,
Alessandro

Title: Re: Excel indexer?
Post by: Justin Derrick on April 28, 2012, 03:10:02 PM

Perl has modules for reading Excel spreadsheets directly.  I'd highly recommend using them.