cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Data Monitor for Excel Format

dschultz
6-Contributor

Data Monitor for Excel Format

When creating a saved report and using the 'New Data Monitor' function to create a scheduled report the only file formats available are: .html, .csv, .pdf, or .xml.

XLS or XLSX are not an options and do not look to be configurable.

 

4 REPLIES 4
Ajit_Kulkarni
14-Alexandrite
(To:dschultz)

Hello,

 

You can convert .csv to XLS or XLSX anytime you want.

 

Thanks!!

Setting a Data Monitor to deliver .csv and then converting to .xls or .xlsx does not keep formatting, and does not work as expected for multiple tab reports or formatting.  For example if you have a report column that has a value with a comma in the output the .csv format for the Data Monitor splits the value into multiple cells which is unacceptable.

I think this depends on how you parse the .csv. 

From what I've seen, if a value has commas in it, the data monitor export will enclose the value in quotes. Excel will automatically parse this correctly, so that the string with the comma doesn't get split into two cells. If you are parsing some other way, you will need to add logic for addressing that. 

 

I haven't seen how to add formatting or multiple tabs to a data monitor. 

STEVEG
21-Topaz I
(To:dschultz)

A native Excel sheet is not an option there for whatever reason.  It is in other places.  Just not there.

Top Tags