Re: Customizing spread sheet apps.
Chris McCormick <chris-iVZ5NKC1gi56pz/[email protected]>
| Newsgroups | gmane.comp.audio.csound.tekno |
|---|---|
| Message-ID | <[email protected]> |
On Wed, Oct 15, 2003 at 12:27:36PM -0800, Iain Duncan wrote: > > Perl's got a lot of stuff. Text::CSV provides a batch of manipulation > > routines; > > DBD::CSV lets you treat a CSV file like an SQL database. sxc2csv > > converts Open/Star Office spreadsheets from native format to CSV. Check > > search.cpan.org for more details; just search on "csv". > > > > --- Joe M. > > Thanks Joe. I take it the above applies to using Perl on the csv file after > the spreadsheet app has saved it. If not please correct me. I was thinking > more of adding functions to the spreadsheet app itself so that I can take > advantage of selections areas from the spreadsheet. Ie highlight a block of > numbers and do a transpose on note names and such like. Although I haven't used a microsoft product for months, I do recall that excel has quite flexible scripting capabilities using visual basic. I'm certain that you could do something along these lines with a little research. Another possibility is to use something like python and WxWindows to knock together a spreadsheet-like application (using a spreadsheet widget, but not actually a spreadsheet) which is flexible enough to allow this. I started something once upon a time which you can see here: http://mccormick.cx/screenshots/scotracker.png It'd be cool to make something similar that's almost like a text-editor, but with a spreadsheet interface and helpful utilities to enter scores. Although, perhaps Steven's 'Blue' does this already. :) The sourcecode is messy and disguisting as it was the first python project i ever worked on, but if yr interested you can get it here: http://mccormick.cx/dev/ScoTracker/ Regards, Chris. _________________________________ chris-iVZ5NKC1gi56pz/[email protected] http://www.mccormick.cx http://www.hypercube.com.au http://www.sciencegirlrecords.com _______________________________________________ csoundtekno mailing list [email protected] Subscribe, unsubscribe, change mailing list options: http://plot.bek.no/mailman/listinfo/csoundtekno