I want to export data from a csv file and create htm page published for my team.

This topic contains 2 replies, has 2 voices, and was last updated by Profile photo of Mohit Sood Mohit Sood 3 years, 2 months ago.

  • Author
    Posts
  • #12925
    Profile photo of Mohit Sood
    Mohit Sood
    Participant

    Team,

    Thanks in advance.

    I want to export data from a csv file and create htm page published for my team for daily KPI's and it needs to be an automated process.

    Any help will appreciated, i am new to powershell.

    Thanks,
    MS

  • #12936
    Profile photo of Mohit Sood
    Mohit Sood
    Participant

    Thanks for reply Dave. i will check that book out.

  • #12926
    Profile photo of Dave Wyatt
    Dave Wyatt
    Moderator

    In its most basic form, that's quite simple:

    Import-Csv -Path yourCsvFile.csv |
    ConvertTo-Html |
    Out-File -FilePath yourNewHtmlFile.html
    

    This example just creates a fairly bland HTML table. There are lots of little things you can do to tweak the look of the resulting HTML (including CSS code, etc.) If you click the Newsletter link along the top of this site, you'll find a link to a free eBook called "Creating HTML Reports in PowerShell."

You must be logged in to reply to this topic.