Re: [CentOS] excel parser (preferably perl)?

2010-10-20 Thread Alexander Georgiev
Yeah, the inconvenient parts could probably be done in vbscript or something on a windows box, pushing the results into the db through odbc, but I thought this would be a common enough problem that cross-platform tools would be available.  I am using some java stuff on the reporting side -

Re: [CentOS] excel parser (preferably perl)?

2010-10-20 Thread Frank Cox
On Wed, 2010-10-20 at 09:39 +0300, Alexander Georgiev wrote: Yep, there a few java excel libraries like: Interesting. Are you aware of any similar libraries for C? -- MELVILLE THEATRE ~ Melville Sask ~ http://www.melvilletheatre.com ___ CentOS

Re: [CentOS] excel parser (preferably perl)?

2010-10-20 Thread John R Pierce
On 10/18/10 3:13 PM, Les Mikesell wrote: I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum

Re: [CentOS] excel parser (preferably perl)?

2010-10-20 Thread Alexander Georgiev
2010/10/20 Frank Cox thea...@sasktel.net: Yep, there a few java excel libraries like: Interesting.  Are you aware of any similar libraries for C? Nope, but you can always use the COM interface. ___ CentOS mailing list CentOS@centos.org

Re: [CentOS] excel parser (preferably perl)?

2010-10-20 Thread mehdi
how ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

Re: [CentOS] excel parser (preferably perl)?

2010-10-20 Thread John R Pierce
On 10/20/10 1:11 AM, mehdi wrote: how On Windows, Excel is all one big set of ActiveX objects with 100s of methods, you can programmatically dink around with most every aspect of it. but, this whole thread has drifted far far away from CentOS and probably belongs on a completely different

Re: [CentOS] excel parser (preferably perl)?

2010-10-20 Thread Kevin Thorpe
On 19/10/2010 17:48, Toby Bluhm wrote: On 10/19/2010 11:17 AM, Les Mikesell wrote: On 10/19/2010 9:34 AM, Todd Denniston wrote: I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way?

Re: [CentOS] excel parser (preferably perl)?

2010-10-20 Thread Les Mikesell
On 10/20/10 3:11 AM, Alexander Georgiev wrote: 2010/10/20 Frank Coxthea...@sasktel.net: Yep, there a few java excel libraries like: Interesting. Are you aware of any similar libraries for C? Nope, but you can always use the COM interface. But that only works under windows... --- Les

Re: [CentOS] excel parser (preferably perl)?

2010-10-20 Thread Natxo Asenjo
On Tue, Oct 19, 2010 at 12:13 AM, Les Mikesell lesmikes...@gmail.com wrote: I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database.  Is there a better way?  I haven't had much luck with

Re: [CentOS] excel parser (preferably perl)?

2010-10-20 Thread Kahlil Hodgson
On 10/19/2010 09:13 AM, Les Mikesell wrote: ... I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum prefers the .32 version from epel over .57 from rpmforge anyway). Is the current CPAN version better? ... Needs to deal with both xls and xlsx formats, the

Re: [CentOS] excel parser (preferably perl)?

2010-10-20 Thread Les Mikesell
On 10/20/2010 3:49 PM, Kahlil Hodgson wrote: On 10/19/2010 09:13 AM, Les Mikesell wrote: ... I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum prefers the .32 version from epel over .57 from rpmforge anyway). Is the current CPAN version better? ... Needs

Re: [CentOS] excel parser (preferably perl)?

2010-10-20 Thread JohnS
On Wed, 2010-10-20 at 16:46 -0500, Les Mikesell wrote: I just went as far as seeing it wouldn't take .xlsx (2007+ default format). It does look like the rpmforge .57 version will accept the .xls format file, although I think it seems slower than loading excel and doing a 'save as' to

Re: [CentOS] excel parser (preferably perl)?

2010-10-20 Thread Gary Greene
On 20/10/10 2:46 PM, Les Mikesell lesmikes...@gmail.com wrote: On 10/20/2010 3:49 PM, Kahlil Hodgson wrote: On 10/19/2010 09:13 AM, Les Mikesell wrote: ... I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum prefers the .32 version from epel over .57 from

Re: [CentOS] excel parser (preferably perl)?

2010-10-19 Thread Todd Denniston
Les Mikesell wrote, On 10/18/2010 06:13 PM: I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum

Re: [CentOS] excel parser (preferably perl)?

2010-10-19 Thread Les Mikesell
On 10/19/2010 9:34 AM, Todd Denniston wrote: I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum

Re: [CentOS] excel parser (preferably perl)?

2010-10-19 Thread Toby Bluhm
On 10/19/2010 11:17 AM, Les Mikesell wrote: On 10/19/2010 9:34 AM, Todd Denniston wrote: I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with

[CentOS] excel parser (preferably perl)?

2010-10-18 Thread Les Mikesell
I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum prefers the .32 version from epel over .57 from

Re: [CentOS] excel parser (preferably perl)?

2010-10-18 Thread JohnS
On Mon, 2010-10-18 at 17:13 -0500, Les Mikesell wrote: I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it

Re: [CentOS] excel parser (preferably perl)?

2010-10-18 Thread Bill Campbell
On Mon, Oct 18, 2010, Les Mikesell wrote: I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum prefers

Re: [CentOS] excel parser (preferably perl)?

2010-10-18 Thread Les Mikesell
On 10/18/2010 5:31 PM, JohnS wrote: On Mon, 2010-10-18 at 17:13 -0500, Les Mikesell wrote: I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with

Re: [CentOS] excel parser (preferably perl)?

2010-10-18 Thread JohnS
On Mon, 2010-10-18 at 17:54 -0500, Les Mikesell wrote: On 10/18/2010 5:31 PM, JohnS wrote: On Mon, 2010-10-18 at 17:13 -0500, Les Mikesell wrote: I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is

Re: [CentOS] excel parser (preferably perl)?

2010-10-18 Thread Les Mikesell
On 10/18/2010 6:16 PM, JohnS wrote: On Mon, 2010-10-18 at 17:54 -0500, Les Mikesell wrote: On 10/18/2010 5:31 PM, JohnS wrote: On Mon, 2010-10-18 at 17:13 -0500, Les Mikesell wrote: I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the

Re: [CentOS] excel parser (preferably perl)?

2010-10-18 Thread Aleksey Tsalolikhin
On Mon, Oct 18, 2010 at 3:13 PM, Les Mikesell lesmikes...@gmail.com wrote: I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database.  Is there a better way?  I haven't had much luck with perl-Spreadsheet-ParseExcel