Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84342members
353519posts

Export a scheduled report to Excel

EcoStruxure IT forum

A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.

Solved
DCIM_Support
Picard
Picard
0 Likes
4
339

Export a scheduled report to Excel

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)


Accepted Solutions
DCIM_Support
Picard
Picard
0 Likes
0
341

Re: Export a scheduled report to Excel

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)

See Answer In Context

4 Replies 4
DCIM_Support
Picard
Picard
0 Likes
0
342

Re: Export a scheduled report to Excel

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)

DCIM_Support
Picard
Picard
0 Likes
1
341

Re: Export a scheduled report to Excel

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)

DCIM_Support
Picard
Picard
0 Likes
0
341

Re: Export a scheduled report to Excel

This comment was originally posted on DCIM Support by spezialist on 2018-10-08


Ok, very thanks for the good feedback 😀.

(CID:134680596)

DCIM_Support
Picard
Picard
0 Likes
0
341

🔒 Closed

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.