Excel formatting using powershell

This topic contains 1 reply, has 2 voices, and was last updated by  manjunathrao25 4 weeks ago.

  • Author
    Posts
  • #79981

    Arjun
    Participant

    Hi All,

    I have written a script to fetch basic information of windows machine, and even i have converted the output to csv file.
    Now i am facing with issue in one of the command which as multiple entries in output. so after exporting it to csv that output is been written in one cell. But i need that entries to be written in vertical, so that it is easier to read. Can anyone have idea on how to do this? Kindly please help me out. Thanks in Advance.

  • #79984

    manjunathrao25
    Participant

    Hello Arjun,

    If you are uploading simple information into excel, why don't you write the data directly into excel? I have written a PowerShell script to generate inventory from Azure and then it will save it to excel. Below is the link:
    https://gallery.technet.microsoft.com/scriptcenter/Azure-Inventory-using-3db0f658#content

    You may use it as a reference. Please let me know if this helped. Or we can discuss this further to come up with a solution tailored for you.

You must be logged in to reply to this topic.