Index of Spreadsheet FAQs

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/URL	Title	Comments
External links
		External	The Perl Journal #10 - Win32::OLE	Other MessWare covered too.
		External	How To Automate Excel Using Perl for Win32	Useful, but no strict
		External	Cultured Perl: Reading and writing Excel files with Perl	WriteExcel, ParseExcel
Tutorials
		Internal	Using Win32::OLE and Excel - Tips and Tricks	General Excel Intro. Lots of questions in follow-ups.
Comparisons
		Internal	Spreadsheet::ParseExcel incompatible with Openoffice?	Open Office, Excel, ParseExcel
Specific programmes
	Excel
		External	The Perl Journal #10 - Win32::OLE	Other MessWare covered too.
		External	How To Automate Excel Using Perl for Win32	Useful, but no strict
		Internal	Using Win32::OLE and Excel - Tips and Tricks	General Excel Intro. Lots of questions in follow-ups.
		Internal
		Internal	Excel Spreadsheet Data Set	Web site development
		Internal	mysql dump in excel format	MySQL
		Internal	merging cells in excel	OLE, merge cells
		Internal	Problems with Win32::OLE and different Office versions	OLE, path delimiter, version differences
		Internal
		Internal	Modifying an existing Excel file	OLE, ParseExcel, WriteExcel
		Internal	Reading & Writing Excel Spreadsheets	OLE, ParseExcel, WriteExcel
		Internal	Best way to read excel files?	OLE, ParseExcel, WriteExcel
		Internal	how to consolidate xls/csv/text into one report?	ParseExcel, TieExcel
		Internal	Excel changes?	Formats, SimpleExcel, Template, WriteExcel
		Internal
		Internal	Waiting ...	CSV, ParseExcel, OLE
		Internal	Spreadsheet::ParseExcel MaxRow giving funky results	Value syntax
		Internal	parsing an excel spreadsheet into a SQL insert statement	Solution uses ParseExcel

		Internal	Spreadsheet::WriteExcel to Browser Problem	CGI server issue
		Internal	can Spreadsheet::WriteExcel restrict entries with a drop-down box	Validation
		Internal	Using Spreadsheet::WriteExcel with mod_perl and Content-Disposition?	File handler
		Internal	Spreadsheet::WriteExcel	Multiple books, format, destroy, close
		Internal	Handy wrapper for Spreadsheet::WriteExcel	Populates a spreadsheet & cascades formats
		Internal	Excel Limitations	WriteExcel size limit

		Internal	Spreadsheet::ParseExcel incompatible with Openoffice?	Open Office, Excel, ParseExcel

	Open / Star Office
		Internal	Spreadsheet::ParseExcel incompatible with Openoffice?	Open Office, Excel, ParseExcel
		Internal	Parse Star Office?	Open Office
		Internal	OpenOffice Quickstarter (Linux) in Perl	Startup 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
		External	The Perl Journal #10 - Win32::OLE	Other MessWare covered too.
		External	How To Automate Excel Using Perl for Win32	Useful, but no strict
		Internal	Using Win32::OLE and Excel - Tips and Tricks	General Excel Intro. Lots of questions in follow-ups.
		Internal	Waiting ...	CSV, ParseExcel, OLE
		Internal	Modifying an existing Excel file	OLE, ParseExcel, WriteExcel
		Internal	Reading & Writing Excel Spreadsheets	OLE, ParseExcel, WriteExcel
		Internal	Best way to read excel files?	OLE, ParseExcel, WriteExcel
		Internal	Excel changes?	Formats, SimpleExcel, Template, WriteExcel
		Internal	Problems with Win32::OLE and different Office versions	OLE, path delimiter, version differences

	Spreadsheet::BasicRead
		Internal	Xtabber	Split a file, BasicRead, WriteExcel

	Spreadsheet::ParseExcel
		External	Cultured Perl: Reading and writing Excel files with Perl	WriteExcel, ParseExcel
		Internal	Excel Spreadsheet Data Set	Web site development
		Internal	Spreadsheet::ParseExcel MaxRow giving funky results	Value syntax
		Internal	parsing an excel spreadsheet into a SQL insert statement	Solution uses ParseExcel
		Internal	Waiting ...	CSV, ParseExcel, OLE
		Internal	Spreadsheet::ParseExcel incompatible with Openoffice?	Open Office, Excel, ParseExcel
		Internal	Modifying an existing Excel file	OLE, ParseExcel, WriteExcel
		Internal	Reading & Writing Excel Spreadsheets	OLE, ParseExcel, WriteExcel
		Internal	how to consolidate xls/csv/text into one report?	ParseExcel, TieExcel
		Internal	Best way to read excel files?	OLE, ParseExcel, WriteExcel

	Spreadsheet::SimpleExcel
		Internal	Excel changes?	Formats, SimpleExcel, Template, WriteExcel

	Spreadsheet::WriteExcel
		External	Cultured Perl: Reading and writing Excel files with Perl	WriteExcel, ParseExcel
		Internal	Spreadsheet::WriteExcel to Browser Problem	CGI server issue
		Internal	can Spreadsheet::WriteExcel restrict entries with a drop-down box	Validation
		Internal	Using Spreadsheet::WriteExcel with mod_perl and Content-Disposition?	File handler
		Internal	Spreadsheet::WriteExcel	Multiple books, format, destroy, close
		Internal	Handy wrapper for Spreadsheet::WriteExcel	Populates a spreadsheet & cascades formats
		Internal	Modifying an existing Excel file	OLE, ParseExcel, WriteExcel
		Internal	Reading & Writing Excel Spreadsheets	OLE, ParseExcel, WriteExcel
		Internal	Best way to read excel files?	OLE, ParseExcel, WriteExcel
		Internal	Excel Limitations	WriteExcel size limit
		Internal	Excel changes?	Formats, SimpleExcel, Template, WriteExcel
		Internal	Xtabber	Split a file, BasicRead, WriteExcel

	Spreadsheet::TieExcel
		Internal	how to consolidate xls/csv/text into one report?	ParseExcel, TieExcel
		Internal	nmake install problem for tieExcel	Make

	Excel::Template
		Internal	Excel 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

Replies are listed 'Best First'.
Re: Index of Spreadsheet FAQs by planetscape (Chancellor) on Jun 05, 2005 at 21:39 UTC
Very nice, thank you. You might also wish to include links to Search CPAN for OpenOffice-related modules such as: OOCBuilder, the Perl OO interface for creating OpenOffice Spreadsheets, OODoc, a library for direct OpenOffice.org document processing, and OOSheets, the Perl module for quick access to spreadsheets cells by address and sheets by name. planetscape	[reply]
Re: Answer: Spreadsheets by davies (Monsignor) on Jun 12, 2005 at 18:19 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	[reply]
Re^2: Answer: Spreadsheets by planetscape (Chancellor) on Jun 13, 2005 at 06:58 UTC
At least the additions are in the thread where others may find them. :-) Update: See also: Using Win32::OLE and Excel - Tips and Tricks (unintentional duplicate) planetscape	[reply]