Automate Csv Files To Graphs
I need a simple solution to perform the following:
At first I thought an MS Excel macro would be sufficient but it made more sense if the solution supports drag and drop and HTML output. Perhaps MS Excel can do this. I have a small budget and need it quickly.
Requirements.
1. Takes a csv file in the format shown below. Here is where the drag and drop of the actual CSV file would make sense to me.
2. Creates a separate graph (e.g. line) for each column in the CSV file.
3. It should be able to pre-read the headings of the csv file such it knows the unique server names, objects and counters.Therefore, after the file is drag and dropped, I can select the object and counter to graph.
the first row of the sample attachment always has this format
\servernameObject1Counter1 or \servernameObject2Counter1 or \servernameObject1Counter2 or \servernameObject2Counter2, etc
Time is always in the first column.
Please let me know how you plan to do this project.
Thanks
