Unexpected import results

[MarianiVentura]

Good day.

I have just started using Powershell and the import-excel module. So far, it has been awesome -- thank you for this wonderful tool.

I have a situation that I cannot understand. I have a very simple xlsx file I am trying to import, but only some of the data is importing.
Here is my simple file:

It has 27 rows, including the header. No matter what I try, I cannot get columns 3 thru 6 to populate on import. Also, I get 55 rows in my object count?

I am pretty sure this is a newbie error, but I am really struggling to figure out.

I appreciate any advice on this issue. Thank you again for making such a wonderful tool.

[dfinke]

Please post the xlsx here

[MarianiVentura]

order.xlsx

Thank you!

Michael

[stahler]

Your workbook has two worksheets.
It is pulling the first one correctly dms_po_l. If you want to import the second, you can specify the worksheetname.

Import-Excel '.\order.xlsx' -WorksheetName Example

[MarianiVentura]

Aha! As I mentioned, I am a newbie and that is definitely a rookie error. Thank you both so much for taking the time to respond and so promptly.

It is very much appreciated.

[dfinke]

@MarianiVentura It's always ok to ask. This also leaves breadcrumbs for other folks new to the module who can hit same issue.