ImportExcel
ImportExcel copied to clipboard
"Header" parameter
I use ImportExcel in PowerShell. I need to use "Header" paramenter, as specified in your help.
If I insert "Header = ,..." into the parameter array I get an error message like "the parameter 'Header' is ambiguos. You can use -HeaderName or -StartRow"
If I insert "HeaderName = ...." , then I get an error message like "There's no any parameter with name '-HeaderName'" I attach some pics, with error msg in Italian (but rather easy to be understood)
How can I use "Header" parameter? Thanks
Sergio
Header is a an array of strings:
$Header = "Field1","Field2","Field3"
Looks like you are passing in a string file the fields separated by commas.