Export CSV having specific worksheet for specific Vcenter

[deepeshsk14]

Hii,

I need to extract a vm inventory of multiple Vcenters via single script.

But it should be in a single .CSV file having different specific worksheet (specific for Vcenter).

A help will be appreciated.

Thanks!

[LucD]

Afaik, a CSV can not have multiple worksheets

[deepeshsk14]

please suggest me a alternative for this.

because export-excel not working here

[LucD]

What is not working?
You really have to show what you are trying to do, I can't guess what you are doing.

[deepeshsk14]

i mean to say, i need to export single sheet of inventory for multiple vcenters but it should have specific worksheet for specific vcenter.

[LucD]

That is still confusing.

Trying to understand what you actually want.
Is it something like this?
- all output to an Excel spreadsheet (XLSX file)

- in that spreadsheet a worksheet per vCenter

[deepeshsk14]

that's correct.

please help

[LucD]

Ok, in that case can you explain what you mean by "because export-excel not working here"