Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Index of Spreadsheet FAQs

by davies (Vicar)
on Jun 05, 2005 at 14:42 UTC ( #463721=perlmeditation: print w/ replies, xml ) Need Help??

In a discussion here, I, perhaps rashly, offered to do something about categorising spreadsheet Q&As. Although there was little response either way, I have been doing some work on this for my own purposes. The table that follows is far from complete, and is intended at present to serve only as an example of what I think could usefully be done.

My thinking has been driven by my need to find information. Therefore, some references appear in several sections. I think this is the best way of dealing with items that refer to more than one category, but I would appreciate feedback. I'd also like advice on how to format this for maximum usability. I don't speak HTML, so inevitably this looks a little odd. In fact, I would appreciate any sort of feedback, including downvotes if I'm wasting people's time. So, here it is.

Regards,

John Davies

Node/URLTitleComments
External links
ExternalThe Perl Journal #10 - Win32::OLEOther MessWare covered too.
ExternalHow To Automate Excel Using Perl for Win32Useful, but no strict
ExternalCultured Perl: Reading and writing Excel files with PerlWriteExcel, ParseExcel
Tutorials
InternalUsing Win32::OLE and Excel - Tips and TricksGeneral Excel Intro. Lots of questions in follow-ups.
Comparisons
InternalSpreadsheet::ParseExcel incompatible with Openoffice?Open Office, Excel, ParseExcel
Specific programmes
Excel
ExternalThe Perl Journal #10 - Win32::OLEOther MessWare covered too.
ExternalHow To Automate Excel Using Perl for Win32Useful, but no strict
InternalUsing Win32::OLE and Excel - Tips and TricksGeneral Excel Intro. Lots of questions in follow-ups.
Internal
InternalExcel Spreadsheet Data SetWeb site development
Internalmysql dump in excel formatMySQL
Internalmerging cells in excelOLE, merge cells
InternalProblems with Win32::OLE and different Office versionsOLE, path delimiter, version differences
Internal
InternalModifying an existing Excel fileOLE, ParseExcel, WriteExcel
InternalReading & Writing Excel SpreadsheetsOLE, ParseExcel, WriteExcel
InternalBest way to read excel files?OLE, ParseExcel, WriteExcel
Internalhow to consolidate xls/csv/text into one report?ParseExcel, TieExcel
InternalExcel changes?Formats, SimpleExcel, Template, WriteExcel
Internal
InternalWaiting ...CSV, ParseExcel, OLE
InternalSpreadsheet::ParseExcel MaxRow giving funky resultsValue syntax
Internalparsing an excel spreadsheet into a SQL insert statementSolution uses ParseExcel
InternalSpreadsheet::WriteExcel to Browser ProblemCGI server issue
Internalcan Spreadsheet::WriteExcel restrict entries with a drop-down boxValidation
InternalUsing Spreadsheet::WriteExcel with mod_perl and Content-Disposition?File handler
InternalSpreadsheet::WriteExcelMultiple books, format, destroy, close
InternalHandy wrapper for Spreadsheet::WriteExcelPopulates a spreadsheet & cascades formats
InternalExcel LimitationsWriteExcel size limit
InternalSpreadsheet::ParseExcel incompatible with Openoffice?Open Office, Excel, ParseExcel
Open / Star Office
InternalSpreadsheet::ParseExcel incompatible with Openoffice?Open Office, Excel, ParseExcel
InternalParse Star Office?Open Office
InternalOpenOffice Quickstarter (Linux) in PerlStartup speed
Quattro
And all is silence, as someone once said...
Lotus
Lots of references to Notes & Domino, but no spreadsheets...
Gnumeric
Gnothing of real interest...
KSpread
For ($K = 0)...
Other
Modules
Win32::OLE
ExternalThe Perl Journal #10 - Win32::OLEOther MessWare covered too.
ExternalHow To Automate Excel Using Perl for Win32Useful, but no strict
InternalUsing Win32::OLE and Excel - Tips and TricksGeneral Excel Intro. Lots of questions in follow-ups.
InternalWaiting ...CSV, ParseExcel, OLE
InternalModifying an existing Excel fileOLE, ParseExcel, WriteExcel
InternalReading & Writing Excel SpreadsheetsOLE, ParseExcel, WriteExcel
InternalBest way to read excel files?OLE, ParseExcel, WriteExcel
InternalExcel changes?Formats, SimpleExcel, Template, WriteExcel
InternalProblems with Win32::OLE and different Office versionsOLE, path delimiter, version differences
Spreadsheet::BasicRead
InternalXtabberSplit a file, BasicRead, WriteExcel
Spreadsheet::ParseExcel
ExternalCultured Perl: Reading and writing Excel files with PerlWriteExcel, ParseExcel
InternalExcel Spreadsheet Data SetWeb site development
InternalSpreadsheet::ParseExcel MaxRow giving funky resultsValue syntax
Internalparsing an excel spreadsheet into a SQL insert statementSolution uses ParseExcel
InternalWaiting ...CSV, ParseExcel, OLE
InternalSpreadsheet::ParseExcel incompatible with Openoffice?Open Office, Excel, ParseExcel
InternalModifying an existing Excel fileOLE, ParseExcel, WriteExcel
InternalReading & Writing Excel SpreadsheetsOLE, ParseExcel, WriteExcel
Internalhow to consolidate xls/csv/text into one report?ParseExcel, TieExcel
InternalBest way to read excel files?OLE, ParseExcel, WriteExcel
Spreadsheet::SimpleExcel
InternalExcel changes?Formats, SimpleExcel, Template, WriteExcel
Spreadsheet::WriteExcel
ExternalCultured Perl: Reading and writing Excel files with PerlWriteExcel, ParseExcel
InternalSpreadsheet::WriteExcel to Browser ProblemCGI server issue
Internalcan Spreadsheet::WriteExcel restrict entries with a drop-down boxValidation
InternalUsing Spreadsheet::WriteExcel with mod_perl and Content-Disposition?File handler
InternalSpreadsheet::WriteExcelMultiple books, format, destroy, close
InternalHandy wrapper for Spreadsheet::WriteExcelPopulates a spreadsheet & cascades formats
InternalModifying an existing Excel fileOLE, ParseExcel, WriteExcel
InternalReading & Writing Excel SpreadsheetsOLE, ParseExcel, WriteExcel
InternalBest way to read excel files?OLE, ParseExcel, WriteExcel
InternalExcel LimitationsWriteExcel size limit
InternalExcel changes?Formats, SimpleExcel, Template, WriteExcel
InternalXtabberSplit a file, BasicRead, WriteExcel
Spreadsheet::TieExcel
Internalhow to consolidate xls/csv/text into one report?ParseExcel, TieExcel
Internalnmake install problem for tieExcelMake
Excel::Template
InternalExcel changes?Formats, SimpleExcel, Template, WriteExcel

jdporter added readmore; fixed link formatting glitch

2006-01-18 Retitled by g0n, as per Monastery guidelines
Original title: 'Spreadsheets'

Comment on Index of Spreadsheet FAQs
Re: Index of Spreadsheet FAQs
by planetscape (Canon) on Jun 05, 2005 at 21:39 UTC
      Thanks. I've included them in my copy, but I didn't realise when I posted the original that I wouldn't be able to post updates to CQ&A because CQ&A questions "belong" to the CQ&A team. I'm sure there's a way around it, and I have seen some discussion here, so things may change soon. Until then, I'll keep updating my copy, and I'll update when I can.

      Regards,

      John Davies

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlmeditation [id://463721]
Approved by Arunbear
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (7)
As of 2014-10-24 07:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (131 votes), past polls