Graph in CSV

Welcome Forums General PowerShell Q&A Graph in CSV

This topic contains 6 replies, has 4 voices, and was last updated by

 
Participant
2 years, 3 months ago.

  • Author
    Posts
  • #48499

    Participant
    Points: 0
    Rank: Member

    Hi,
    I have CSV file with four columns.
    Date time computer timetaken
    12/1/2016 11:45 abc 1324
    12/2/2016 12:15 bca 5567
    12/3/2016 14:06 abc 4446
    12/4/2016 17:59 bca 35789
    12/5/2016 1:00 van 1256
    12/6/2016 13:56 nav 6598
    12/7/2016 14:35 van 4478

    I want graph for time, computer & timetaken.

    I wrote code in VB, but it is getting me only time & time-taken.
    Can someone help me in powershell to get grap for time, computer, timetaken?

    -Kalyan

  • #48550

    Keymaster
    Points: 1,639
    Helping HandTeam Member
    Rank: Community Hero

    I'm assuming you're using Excel, and not a CSV file per se. And what you're talking about is Excel Automation. Unfortunately, PowerShell doesn't have any special abilities for Excel. It would have to use the same thing that you're using in VB. Personally, I prefer not to mess with Excel Automation, as I find it complex and finicky. I prefer to use SQL Server Reporting Services for this kind of thing, since it's much easier (for me) and more reliable. We have a free ebook called "Ditch Excel" on our eBooks menu, and you may find that helpful.

  • #48562

    Participant
    Points: 0
    Rank: Member

    Hi,
    Thanks. Will have a look.

    -Kalyan

  • #48564

    Participant
    Points: 21
    Rank: Member
  • #48696

    Participant
    Points: 166
    Helping Hand
    Rank: Participant

    Just thought it should be mentioned that you don't NEED Excel per se. You can also use .NET chart controls and save charts as images to inject into emails. It would depend on what format you are going to provide the report in. I have built charts manually in Excel to get a general idea of what is contained in the chart. Take a look at this:

    Tutorial: PowerShell and Microsoft Chart Controls (or How To Spice Up Your Reports)

  • #48741

    Participant
    Points: 21
    Rank: Member

    I was going to say that but thought it may be a little over his head.

    I can't picture this data in a chart. All the values are unique except the computername.

  • #48960

    Participant
    Points: 0
    Rank: Member

    Thanks all.

    -Kalyan

The topic ‘Graph in CSV’ is closed to new replies.