EcoStruxure IT forum
Schneider Electric support forum about installation and configuration for DCIM including EcoStruxure IT Expert, IT Advisor, Data Center Expert, and NetBotz
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-05 12:26 PM
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?
(CID:134680551)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-05 12:27 PM
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.
With respect.
(CID:134680586)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-05 12:27 PM
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.
With respect.
(CID:134680586)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-05 12:27 PM
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.
(CID:134680593)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-05 12:27 PM
This comment was originally posted on DCIM Support by spezialist on 2018-10-08
Ok, very thanks for the good feedback 😀.
(CID:134680596)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-05 12:27 PM . Last Modified: 2023-10-22 02:04 AM
This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.