I figure I'll ask the question here, even though it's probably better suited for a site like superuser or VMUG.
Specifically here is what I'm doing. I administer a few thousand virtual machines spread out over a total of 8 ESXi hosts (clusters). I need to generate some reports weekly which is a very tedious process that I'm trying to automate. I've got it now (with the assistance of some bash scripts I wrote using cygwin) to where it generates the reports for each server split up into 7 separate CSV files.
What I need to accomplish now is to somehow batch convert those separate csv files into one Excel workbook, each CSV being a separate tab within the excel workbook. And I need it to be something I can automate, ie; via command line.
Specifically here is what I'm doing. I administer a few thousand virtual machines spread out over a total of 8 ESXi hosts (clusters). I need to generate some reports weekly which is a very tedious process that I'm trying to automate. I've got it now (with the assistance of some bash scripts I wrote using cygwin) to where it generates the reports for each server split up into 7 separate CSV files.
What I need to accomplish now is to somehow batch convert those separate csv files into one Excel workbook, each CSV being a separate tab within the excel workbook. And I need it to be something I can automate, ie; via command line.
No comments:
Post a Comment