Can Excel and Costar trade data?
All of the Costar reports can export their data to Excel. They can even do it in real time, so that as you change parameters in Costar, all of your related spreadsheets change. So, if none of the 18 built-in reports & graphs show what you want to see, you can use Excel as a fancy report writer/graphing tool. Importing data to Costar is a bit more tricky. Click here to download an Excel spreadsheet that does just that. It has a macro that collects data from the spreadsheet, executes Costar (sending the data), and harvests the results from a Costar report, and places the Costar results into the spreadsheet. The macro assumes that Costar is installed in the “Costar 7” directory or “Costar 7 Demo” directory. You can embellish this simple macro into something that is more useful. Contact us if you need more details about the Costar command language. By the way, when you read the spreadsheet into Excel it will warn you about the presence of a macro — that’s normal in this case.
