Generating Excel Spreadsheets Programatically - Revision history

PeterHarding at 04:24, 29 August 2009

2009-08-29T04:24:52Z

2008-12-04T03:59:14Z

Write a Simple Spreadsheet with Two Worksheets

← Older revision		Revision as of 13:59, 4 December 2008
Line 137:		Line 137:
	</pre>		</pre>

	[[Category:Python]][[Category:Excel]][[Category:Development]]		[[Category:Python]]
			[[Category:PERL]]
			[[Category:Excel]]
			[[Category:Development]]

2008-01-25T01:25:00Z

← Older revision		Revision as of 11:25, 25 January 2008
Line 18:		Line 18:
	Here is the script:		Here is the script:

			<pre>
	#!/usr/bin/env perl		#!/usr/bin/env perl
	#		#
Line 64:		Line 65:

	#-------------------------------------------------------------------------------		#-------------------------------------------------------------------------------
			</pre>

	Here is how it is used:		Here is how it is used:

			<pre>
	$ cat example		$ cat example

Line 79:		Line 82:
	$ ls -l example.xls		$ ls -l example.xls
	-rw-r--r-- 1 user group 5632 2007-12-15 17:47 example.xls		-rw-r--r-- 1 user group 5632 2007-12-15 17:47 example.xls
			</pre>

	The first argument is the separator character. So to convert the passwd file to a spreadsheet use the following command:		The first argument is the separator character. So to convert the passwd file to a spreadsheet use the following command:

			<pre>
	$ ./txt2xls ":" /etc/passwd		$ ./txt2xls ":" /etc/passwd
			</pre>

	=== Write a Simple Spreadsheet with Two Worksheets ===		=== Write a Simple Spreadsheet with Two Worksheets ===

			<pre>
	#!/usr/bin/env perl		#!/usr/bin/env perl

Line 128:		Line 135:

	#-------------------------------------------------------------------------------		#-------------------------------------------------------------------------------
			</pre>

			[[Category:Python]][[Category:Excel]][[Category:Development]]

2007-12-15T06:59:55Z

@@ Line 14: / Line 14: @@
 == PERL ==
-=== Translate CSV to Excel Format ===
+=== Translating a CSV File to an Excel Spreadsheet ===
 Here is the script:
@@ Line 83: / Line 83: @@
   $ ./txt2xls ":" /etc/passwd

2007-12-15T06:51:44Z

← Older revision		Revision as of 16:51, 15 December 2007
Line 80:		Line 80:
	-rw-r--r-- 1 user group 5632 2007-12-15 17:47 example.xls		-rw-r--r-- 1 user group 5632 2007-12-15 17:47 example.xls

	The first argument is the separator character. So to convert the passwd file to a spreadsheet use the ~~folloing~~ command:		The first argument is the separator character. So to convert the passwd file to a spreadsheet use the following command:

	$ ./txt2xls ":" /etc/passwd		$ ./txt2xls ":" /etc/passwd

2007-12-15T06:51:12Z

← Older revision		Revision as of 16:51, 15 December 2007
Line 80:		Line 80:
	-rw-r--r-- 1 user group 5632 2007-12-15 17:47 example.xls		-rw-r--r-- 1 user group 5632 2007-12-15 17:47 example.xls

	The first argument is the separator character. To convert the passwd file to a spreadsheet use the folloing command:		The first argument is the separator character. So to convert the passwd file to a spreadsheet use the folloing command:

	$ ./txt2xls ":" /etc/passwd		$ ./txt2xls ":" /etc/passwd

2007-12-15T06:51:08Z

← Older revision		Revision as of 16:51, 15 December 2007
Line 79:		Line 79:
	$ ls -l example.xls		$ ls -l example.xls
	-rw-r--r-- 1 user group 5632 2007-12-15 17:47 example.xls		-rw-r--r-- 1 user group 5632 2007-12-15 17:47 example.xls

			The first argument is the separator character. To convert the passwd file to a spreadsheet use the folloing command:

			$ ./txt2xls ":" /etc/passwd

2007-12-15T06:49:12Z

2007-12-15T06:48:26Z

@@ Line 14: / Line 14: @@
 == PERL ==
-=== Ex 1 ===
+=== Translate CSV to Excel Format ===
   #!/usr/bin/env perl
@@ Line 63: / Line 64: @@
   #-------------------------------------------------------------------------------

2007-12-15T06:43:41Z

@@ Line 5: / Line 5: @@
 * [http://search.cpan.org/ Write Excel Spreadsheets]
 * [http://aspn.activestate.com/ASPN/CodeDoc/Spreadsheet-WriteExcel/WriteExcel.html]
 = Python =