This question was originally posted on DCIM Support by Todd Walters on 2018-10-08
Is there a way to get a scheduled report to run in excel instead of coming through as a text file?
Solved! Go to Solution.
This answer was originally posted on DCIM Support by spezialist on 2018-10-08
Dear Todd Walters,
Hopefully Steven Marchetti answer from topic will help you:
...That is correct, we do not export in an XLS format. Exports are formatted in a comma delimited file which Microsoft Excel is capable of opening and formatting. Simply open the file in Excel. If it does not automatically format itself (mine does in CSV format), you should get a text import wizard popup in Excel. Simply choose delimited, hit next, then choose the delimiter which in this case is a comma. You can do some formatting if you would like during the import but then hit finish and it be properly aligned in rows and columns.
If you have more questions, please ask.
This answer was originally posted on DCIM Support by Todd Walters on 2018-10-08
Thanks alot. The data does copy and paste into excel just fine.
This comment was originally posted on DCIM Support by spezialist on 2018-10-08
Ok, very thanks for the good feedback 😀.
Discuss challenges and get support in energy and automation with 30,000+ experts and peers.
Over 10,000+ support articles are available to help you find answers to your product and business challenges.
Find peer based solutions to your questions. Provide answers for fellow community members!