convert study table to excel spreadsheet

Hello,

How can I convert/export a study table from MS5.5 into an excel sheet... I did not find that option in Save As/Export. I'm trying to visualize multiple radial distribution functions from different runs and they all come out in different study tables. The plotting software in MS seems pretty useless, as it seems impossible to change anything on a plot, what are the quick ways to do it... rather than writing a script.

Either way I strongly feel there should be a mechanism of exporting data out of MS and other Accelrys softwares... if I'm not aware please let me know.

Thanks and regards,

Manish

Answers 3
ST
ST 2011-08-01

The fastest way to get data out of Materials Studio and into other productivity tools is to use Copy and Paste. You should be able to copy and paste from a chart document or a study table directly into Excel or other spreadsheet programs.

Cheers

Stephen

MP
MP 2011-08-02

Dear Stephen,

There is nothing cheerful about copy-pasting a large bunch of data.... It seems what you are telling me is that Accelrys does not provide a way to export  data out of MS5.5... something for which I don't have a good feeling!

Regards

Manish

ST
ST 2011-08-02

As an alternative, if you have a chart document, you can simply export this directly as a .csv which can be read into Excel. There is currently no way to export a study table as a format that can be read into Excel. I appreciate that this is a shortcoming of the study table but it can contain information such as structures which are not compatible with Excel.

Cheers

Stephen