150 Commits

Author	SHA1	Message	Date
dfinke	25a970e743	Added Get-ExcelSheetInfo	2016-01-07 11:42:38 -05:00
dfinke	5908f33341	Initial commit	2015-12-19 11:39:19 -05:00
dfinke	652255ca9d	Initial commit [charting]	2015-12-18 12:58:42 -05:00
dfinke	4c620ee630	Added several new features	2015-12-17 16:53:13 -05:00
dfinke	dc753b67b2	Set [Parameters] explicitly	2015-12-06 17:07:40 -05:00
dfinke	59d0c4fca7	Renamed Sheet1 parameter, added alias	2015-11-12 17:25:43 -05:00
dfinke	a256b69b24	Added HeaderRow #47	2015-10-19 18:42:12 -04:00
dfinke	cd46819c79	Added -NoHeader and returns .Value	2015-10-15 11:53:47 -04:00
dfinke	4b59eb0e75	Merged ValidateSet for Encoding and Extension	2015-10-01 11:11:05 -04:00
Irwin Strachan	3eac21c11a	Update ImportExcel.psm1 ... Created a ValidateSet for Encoding and Extension. removed Extension from the params. Removed Encoding at the Export-Csv as it is already included in params	2015-10-01 11:11:04 -04:00
dfinke	abaabc6fa1	Update	2015-09-11 17:35:04 -04:00
dfinke	1b775ac5b9	Initial commit	2015-09-11 17:35:02 -04:00
Staffan Gustafsson	5f5ba10021	Use value instead of Text when reading cells to preserve types.	2015-09-08 10:25:59 -04:00
Francois Lachance-Guillemette	6c25606b91	Added missing Stream Close and Alias	2015-08-21 11:26:12 -04:00
Francois Lachance-Guillemette	434a3e5180	Added Reading in ConvertFrom-ExcelSheet + ... ... Streamlined parameters in Import-Excel (still compatible)	2015-08-21 11:18:09 -04:00
Francois Lachance-Guillemette	5b2311c298	Allow reading even if file is open by Excel	2015-08-21 10:59:47 -04:00
dfinke	c878f743fd	tweaked	2015-07-09 12:47:43 -04:00
dfinke	140aaba049	added example	2015-07-09 12:47:42 -04:00
dfinke	63ee3908a8	try	2015-07-09 12:47:42 -04:00
Doug Finke	20d84ace37	works with hashtable	2015-07-09 12:47:41 -04:00
Justin Dearing	b83f4fe55b	Export-Excel can now make a table or a named range.	2015-06-14 06:24:51 -04:00
Justin Dearing	fdc2b8a9df	Cleaned up error checking for worksheet replacement	2015-06-14 04:51:38 -04:00
Doug Finke	7e112b1e2c	Fix null header	2015-05-25 14:37:00 -04:00
Doug Finke	07ec784453	Rename BoldFirstRow to BoldTopRow ... #18	2015-05-18 08:25:32 -04:00
Doug Finke	51f6d4f8a2	Added Filter, Freeze and Bold first row	2015-05-17 11:21:45 -04:00
Peter Schneider	56ca4b1312	Passing $Encoding to Export-Csv and Disposing ExcelPackage Object	2015-05-01 20:48:58 +02:00
Doug Finke	d33a040d43	added Export-MultipleExcelSheets	2015-04-29 18:52:26 -04:00
Doug Finke	6955eea535	Format datetime properties	2015-04-27 10:08:10 -04:00
Doug Finke	4122d11586	Revert "Format datetime propeties" ... This reverts commit 9f8183a7b1.	2015-04-27 10:07:41 -04:00
Doug Finke	9f8183a7b1	Format datetime propeties	2015-04-27 10:07:28 -04:00
Doug Finke	8ca024999f	Added =$true to Parameters to support downlevel versions	2015-04-23 20:16:16 -04:00
Doug Finke	a0602f3361	Updated to ConvertFrom-ExcelSheet	2015-04-20 16:04:43 -04:00
Doug Finke	5a92e51c76	Suggested Changes	2015-04-18 17:17:13 -04:00
Doug Finke	315ba5089a	Revert "Suggesting modifications" ... This reverts commit f21fe248fe.	2015-04-18 17:11:20 -04:00
Doug Finke	f21fe248fe	Suggesting modifications	2015-04-18 17:10:38 -04:00
Claustn	e3159023c6	Added Import-ExcelAllSheet ... Export all sheets	2015-04-18 22:02:03 +02:00
Doug Finke	bb707195af	Re-added TitleBackgroundColor	2015-04-14 09:36:21 -04:00
Doug Finke	681c68f15a	Set a title, the pattern, size and make it bold	2015-04-13 20:15:58 -04:00
Doug Finke	5d4662bd49	Fix password setting	2015-04-13 10:16:01 -04:00
Doug Finke	08418e3455	Added Examples for Get-Help	2015-04-10 14:42:24 -04:00
Doug Finke	ca2dfd7d6c	Fixes #5	2015-04-10 14:35:06 -04:00
Doug Finke	e32095d88d	Replaced -Force switch with -NoClobber switch	2015-04-10 14:32:48 -04:00
Doug Finke	9cb16c12a3	Exposed ability to set a password on the sheet	2015-04-10 14:19:22 -04:00
Doug Finke	e6c8380c58	Added Export-MultipleExcelSheets	2015-04-10 10:02:33 -04:00
Doug Finke	a04e7de2c4	Renamed to AutoSize	2015-04-10 09:37:50 -04:00
Doug Finke	eb8fbc4f4a	Implemented -WorkSheetname parameter	2015-04-08 18:20:10 -04:00
josheinstein	b6b03cfca4	Export-Excel now resolves unresolved pspaths.	2015-04-08 16:22:34 -04:00
ramblingcookiemonster	31bce81433	s/validateset/strongtype	2015-03-31 19:50:25 -04:00
Doug Finke	be1d58ff80	Update	2015-03-30 19:40:35 -04:00
Doug Finke	29839ea142	Initial commit	2015-03-27 13:32:04 -04:00