ImportExcel icon indicating copy to clipboard operation
ImportExcel copied to clipboard

"Header" parameter

Open SarSerg opened this issue 1 year ago • 1 comments

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)

Screenshots.zip

How can I use "Header" parameter? Thanks

Sergio

SarSerg avatar Nov 13 '23 16:11 SarSerg

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.

dfinke avatar Nov 14 '23 18:11 dfinke