{"action":"created","issue":{"url":"https://api.github.com/repos/dfinke/ImportExcel/issues/460","repository_url":"https://api.github.com/repos/dfinke/ImportExcel","labels_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/460/labels{/name}","comments_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/460/comments","events_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/460/events","html_url":"https://github.com/dfinke/ImportExcel/issues/460","id":368398604,"node_id":"MDU6SXNzdWUzNjgzOTg2MDQ=","number":460,"title":"Merge-MultipleSheets - Error: System.Drawing.Color","user":{"login":"DomPizzie","id":3649922,"node_id":"MDQ6VXNlcjM2NDk5MjI=","avatar_url":"https://avatars2.githubusercontent.com/u/3649922?v=4","gravatar_id":"","url":"https://api.github.com/users/DomPizzie","html_url":"https://github.com/DomPizzie","followers_url":"https://api.github.com/users/DomPizzie/followers","following_url":"https://api.github.com/users/DomPizzie/following{/other_user}","gists_url":"https://api.github.com/users/DomPizzie/gists{/gist_id}","starred_url":"https://api.github.com/users/DomPizzie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DomPizzie/subscriptions","organizations_url":"https://api.github.com/users/DomPizzie/orgs","repos_url":"https://api.github.com/users/DomPizzie/repos","events_url":"https://api.github.com/users/DomPizzie/events{/privacy}","received_events_url":"https://api.github.com/users/DomPizzie/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"dfinke","id":67258,"node_id":"MDQ6VXNlcjY3MjU4","avatar_url":"https://avatars2.githubusercontent.com/u/67258?v=4","gravatar_id":"","url":"https://api.github.com/users/dfinke","html_url":"https://github.com/dfinke","followers_url":"https://api.github.com/users/dfinke/followers","following_url":"https://api.github.com/users/dfinke/following{/other_user}","gists_url":"https://api.github.com/users/dfinke/gists{/gist_id}","starred_url":"https://api.github.com/users/dfinke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dfinke/subscriptions","organizations_url":"https://api.github.com/users/dfinke/orgs","repos_url":"https://api.github.com/users/dfinke/repos","events_url":"https://api.github.com/users/dfinke/events{/privacy}","received_events_url":"https://api.github.com/users/dfinke/received_events","type":"User","site_admin":false},"assignees":[{"login":"dfinke","id":67258,"node_id":"MDQ6VXNlcjY3MjU4","avatar_url":"https://avatars2.githubusercontent.com/u/67258?v=4","gravatar_id":"","url":"https://api.github.com/users/dfinke","html_url":"https://github.com/dfinke","followers_url":"https://api.github.com/users/dfinke/followers","following_url":"https://api.github.com/users/dfinke/following{/other_user}","gists_url":"https://api.github.com/users/dfinke/gists{/gist_id}","starred_url":"https://api.github.com/users/dfinke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dfinke/subscriptions","organizations_url":"https://api.github.com/users/dfinke/orgs","repos_url":"https://api.github.com/users/dfinke/repos","events_url":"https://api.github.com/users/dfinke/events{/privacy}","received_events_url":"https://api.github.com/users/dfinke/received_events","type":"User","site_admin":false}],"milestone":null,"comments":6,"created_at":"2018-10-09T21:08:02Z","updated_at":"2018-10-22T16:38:36Z","closed_at":null,"author_association":"NONE","body":"Below error output when running example code from: [Merge_3_Servers_Services.ps1](https://github.com/dfinke/ImportExcel/blob/master/Examples/MergeWorkSheet/Merge_3_Servers_Services.ps1)\r\n\r\n``` Powershell\r\nMerge-MultipleSheets : Cannot process argument transformation on parameter 'KeyFontColor'. Cannot convert the \"Red\" value of type \"System.String\" to type \"System.Drawing.Color\".\r\nAt C:\\Users\\example\\Documents\\Scripts\\example.ps1:34 char:1\r\n+ Merge-MultipleSheets -Path \"$env:temp\\server1.xlsx\", \"$env:temp\\Serve ...\r\n+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\r\n+ CategoryInfo          : InvalidData: (:) [Merge-MultipleSheets], ParameterBindingArgumentTransformationException\r\n+ FullyQualifiedErrorId : ParameterArgumentTransformationError,Merge-MultipleSheets\r\n```\r\n\r\nComputer  Details\r\n```\r\nName                           Value\r\n----                           -----\r\nPSVersion                      6.0.4\r\nPSEdition                      Core\r\nGitCommitId                    v6.0.4\r\nOS                             Microsoft Windows 6.1.7601 S\r\nPlatform                       Win32NT\r\nPSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}\r\nPSRemotingProtocolVersion      2.3\r\nSerializationVersion           1.1.0.1\r\nWSManStackVersion              3.0\r\n```\r\n\r\nPotentiality related to #150 "},"comment":{"url":"https://api.github.com/repos/dfinke/ImportExcel/issues/comments/431890745","html_url":"https://github.com/dfinke/ImportExcel/issues/460#issuecomment-431890745","issue_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/460","id":431890745,"node_id":"MDEyOklzc3VlQ29tbWVudDQzMTg5MDc0NQ==","user":{"login":"dfinke","id":67258,"node_id":"MDQ6VXNlcjY3MjU4","avatar_url":"https://avatars2.githubusercontent.com/u/67258?v=4","gravatar_id":"","url":"https://api.github.com/users/dfinke","html_url":"https://github.com/dfinke","followers_url":"https://api.github.com/users/dfinke/followers","following_url":"https://api.github.com/users/dfinke/following{/other_user}","gists_url":"https://api.github.com/users/dfinke/gists{/gist_id}","starred_url":"https://api.github.com/users/dfinke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dfinke/subscriptions","organizations_url":"https://api.github.com/users/dfinke/orgs","repos_url":"https://api.github.com/users/dfinke/repos","events_url":"https://api.github.com/users/dfinke/events{/privacy}","received_events_url":"https://api.github.com/users/dfinke/received_events","type":"User","site_admin":false},"created_at":"2018-10-22T16:38:36Z","updated_at":"2018-10-22T16:38:36Z","author_association":"OWNER","body":"Thanks! Sounds good. I've got the Azure DevOps pipeline wired up. It was catching the Color issues, it is throwing elsewhere. I runs on PRs. Probably useful as a smoke test."}}
{"actor":{"display_login":"dfinke"}}