jgaunt/ImportExcel
1
0
Fork 0
mirror of https://github.com/dfinke/ImportExcel.git synced 2025-12-19 01:33:46 +00:00
Code Issues Packages Projects Releases Wiki Activity
1,655 Commits 10 Branches 52 Tags
copilot/fix-x-axis-configuration-issue
Commit Graph

1655 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
dfinke
6966d0d4ef bumped version 2017-10-04 18:26:03 -04:00
Doug Finke
2dc50250fc Merge pull request #230 from ili101/master 
Fix Bug. AutoFilter with TableName corrupted file
 2017-10-04 18:21:48 -04:00
ili101
8ad38b544e Fix Bug, Unable to find type [PSPlot] in ISE 
When loading cmdlet info from ISE "Commands" panel you get the error
"Unable to find type [PSPlot]"
https://github.com/dfinke/ImportExcel/issues/131
 2017-10-05 00:15:57 +03:00
ili101
06124e12e7 Fix Bug. AutoFilter with TableName corrupted file 
Fix Bug, AutoFilter with TableName create corrupted Excel file.
https://github.com/dfinke/ImportExcel/issues/65
You now cannot set AutoFilter and TableName at the same time.
"-Now" will not auto add AutoFilter if TableName set.
 2017-10-05 00:02:06 +03:00
dfinke
d1c3e7b23e Tweaked v4.0.2 2017-10-03 10:00:49 -04:00
dfinke
f0203f38e8 Bumped the version 2017-10-03 10:00:40 -04:00
Doug Finke
ef816d28d2 Merge pull request #228 from jeremytbrun/TitleFix 
Title fix (Issues #182 and #89)
 2017-10-03 09:54:49 -04:00
Brun
85512c2261 README update 2017-10-03 08:39:09 -04:00
Brun
409f69e915 Updated README 2017-10-03 08:29:10 -04:00
Brun
58ae6845ff Updated README 2017-10-03 08:28:37 -04:00
Brun
5d70003582 Title fixes 2017-10-02 10:04:13 -04:00
Doug Finke
9a66cb6123 Merge pull request #227 from DarkLite1/ImportExcelPassword 
Import excel added parameter 'Password'
 2017-09-29 20:53:01 -04:00
DarkLite1
efb9e158b5 Added help text 2017-09-28 14:21:55 +02:00
DarkLite1
75aaff300a Correct version nr 2017-09-28 14:14:36 +02:00
DarkLite1
12fd17b9ea Bumped version to 4.0.1 
- Renamed 'TopRow' to 'StartRow' and added alias
  (More concise with future parameter names like 'StartColumn')
- Removed 'ChangeList' in 'Notes' as this is tracked in Git
- Added parameter 'Password' to import password protected files
- Added Pester tests for parameter aliasses and:
	- parameter 'Password'
	- parameter 'Path' validation for extensions '.xls' and '.xlsx'
	- 'HeaderName' witb blanks
- Changed comments in Pester tests from '<# Comment #>' to '# Comment'
  (Easier to outcomment a whole block of tests when performing a test on a specific piece of code)
 2017-09-28 14:12:07 +02:00
DarkLite1
facb38a2aa Merge branch 'master' of https://github.com/dfinke/ImportExcel 2017-09-27 15:51:51 +02:00
Doug Finke
222e0609d9 Merge pull request #217 from DarkLite1/ImportExcelFirstWorksheet 
Import-Excel parameter
 2017-09-22 16:07:34 -04:00
Brun
a3c2a92e33 Header formatting fix when Title is used (Issue #182) 2017-09-20 13:56:06 -04:00
DarkLite1
1f435277a5 Merge branch 'ImportExcelFirstWorksheet' 2017-09-20 09:40:00 +02:00
DarkLite1
295b369a81 Improved paramter validation and fixed 'WorksheetName' position. Extra Pester tests added too. 2017-09-20 09:35:57 +02:00
Doug Finke
84ad62989a Merge pull request #216 from DarkLite1/ImportExcelFirstWorksheet 
Import excel first worksheet
 2017-09-19 11:36:23 -04:00
DarkLite1
a0563d4daa Import-Excel updated help 2017-09-19 16:00:11 +02:00
DarkLite1
2c16cdcbfe Import-Excel select first worksheet by default 2017-09-19 15:55:13 +02:00
DarkLite1
e45437e32e Fixed spelling 2017-09-18 11:50:30 +02:00
dfinke
aadae64105 Updated to 4.0 2017-09-12 19:22:31 -04:00
Doug Finke
41b2455705 Merge pull request #202 from DarkLite1/master 
Rewrote 'Import-Excel' to fix some serious bugs and added function 'Update-FirstObjectProperties'
 2017-09-12 19:13:32 -04:00
DarkLite1
d75350c659 Improved tests for emtpy rows after TopRow x 2017-09-11 14:06:45 +02:00
DarkLite1
323c52a24b Added alias HeaderRow for TopRow to ImportExcel 2017-09-08 12:53:23 +02:00
DarkLite1
bcc2db8657 Improved ImportExcel.Tests 2017-09-07 13:38:43 +02:00
DarkLite1
e42fa83043 Added position to params of 'Import-Excel' 2017-08-22 08:48:20 +02:00
DarkLite1
662d5913ae Rewrote 'Import-Excel': 
- Added parameter sets for proper parameter validation and to make sure '-NoHeader' and '-HeaderRow' aren't used together
- Added try/catch clause, CmdLetBinding and verbose messages
- Renamed 'HeaderRow' to 'TopRow' to avoid confusion with other parameters
- Renamed '-Header' to '-HeaderName'
- Added test for duplicate property names
- Added test for empty worksheet
- Added test for no data after TopRow
- Fixed incorrect import when there's no value in the first column
- Fixed values being imported under the wrong property name in case one
- Fixed incorrect import in case column A is empty and B and C not ( '$Worksheet.Dimension.Columns' is unreliable because it will say 2 columns are in use while it should say 3).
(Ex. Add data in cell B2 and C2, use the '-NoHeader' switch, notice P1 and P2 are incorrectly blanc.)
 2017-08-21 15:34:30 +02:00
DarkLite1
d8d624ba9c Added the function 'Update-FirstObjectProperties' 
Added help text in 'Export-Excel'
Added try/catch to 'Install' and 'InstallModule'
Improved code readability in 'Install' and 'InstallModule'
 2017-07-26 13:37:08 +02:00
DarkLite1
2e7df0a2fe Merge remote-tracking branch 'upstream/master' 2017-07-25 14:07:32 +02:00
dfinke
b90087bd63 Updated to include ConvertTo-ExcelXlsx v3.0.1 2017-07-03 13:44:01 -04:00
Doug Finke
c39a012205 Merge pull request #195 from NordbergKMD/master 
Update and rename ConvertTo-ExcelXlsx.ps1 to ConvertToExcelXlsx.ps1
 2017-06-29 16:16:10 -04:00
Mikkel Nordberg
675ba9d664 Update and rename ConvertTo-ExcelXlsx.ps1 to ConvertToExcelXlsx.ps1 2017-06-29 16:19:07 +02:00
Doug Finke
a8b20df16c Merge pull request #192 from NordbergKMD/master 
ConvertTo-ExcelXlsx
 2017-06-29 08:41:55 -04:00
Mikkel Nordberg
097f11a661 Minor patch 
Consolidated parameter validation.
Added error handling on -Force if destination file cannot be deleted.
 2017-06-29 14:18:29 +02:00
Mikkel Nordberg
c359560fd8 Removed case-sesitivity check. 
-ne comparison operator is case insensitive so there is no need for .ToLower()
 2017-06-29 12:23:24 +02:00
Mikkel Nordberg
ea0a5a7c76 Update and rename Convert-XLSToXLSX.ps1 to ConvertTo-ExcelXlsx.ps1 2017-06-27 13:20:38 +02:00
DarkLite1
39019d2680 Merge remote-tracking branch 'refs/remotes/origin/master' 2017-06-26 13:15:21 +02:00
DarkLite1
d009581b1b Merge remote-tracking branch 'refs/remotes/origin/master' into dfinke/master 2017-06-26 13:13:23 +02:00
Mikkel Nordberg
8344118c11 Rename Convert-XLSToXLSX to Convert-XLSToXLSX.ps1 2017-06-23 15:56:10 +02:00
Mikkel Nordberg
1b695478e7 Create Convert-XLSToXLSX 2017-06-23 15:55:06 +02:00
dfinke
39d176e31b Updated 2017-06-15 19:56:43 -04:00
dfinke
ed84db6b2e tweaked 2017-06-15 19:56:36 -04:00
dfinke
b33223460e Added example 2017-06-15 19:43:54 -04:00
dfinke
822e63a667 Updated for copying 2017-06-15 19:42:51 -04:00
Doug Finke
f9aa52cdae Merge pull request #190 from dfinke/CodeGen-SQL 
Code gen sql
 2017-06-15 19:35:40 -04:00
dfinke
615f677b2e Added convert from Excel 2017-06-15 19:34:04 -04:00