Skip to main content
1-Visitor
April 27, 2010
Question

Where are the components?

  • April 27, 2010
  • 10 replies
  • 4081 views
After being shown through this Colab the "Excel Component" in MCad 13/14, it is now one of my most used features. It facilitates simply data entry and formating (into the Excel component) while also simplifying the integration into Mathcad.

Do I seriously need to revert back to load save function calls? That's going back to early 1990's unintegrated processes. Or alternatively copy and pasting between applications (going back to the mid 1990's - heck even that could be automated). This approach has been outdated since COM/Corba came into being. What's more, since the early 2000's it is simpler than ever to integrate between all applications Soap (and its extensions such as web services).

Integration between applications is becoming seamless - not clunkier.

The Excel component should at least be replicated in Prime


Philip
___________________
Nobody can hear you scream in Euclidean space.

10 replies

1-Visitor
May 1, 2010
Agreed!

I use Mathcad 14 to integrate over 1,000 separate Excel files (and PRN files, TXT file etc.) for empirical analysis. These all come from third parties--the US Federal Reserve, the BLS, etc.

All these data originators still use Excel 2003 or earlier formats to make their data publicly available--none of them are in XLSW or XLSM as Prime expects them to be.

Implement support for loading old Excel formats into Prime please--otherwise anyone like me who has to rely on third party sourced data won't be able to use it without "stepping back in time" to READFILE etc.
1-Visitor
May 1, 2010
The READEXCEL component forces you to specify a data range, unlike the Mathcad 14 function that simply imported the entire Excel component.

This is useless for the work I do, which relies on external data providers updating data on a regular basis. The source data file therefore grows by a row every time data is added--which can be daily for a stock market data feed, monthly for CPI figures from the BLS, etc.

To use Prime where I currently use Mathcad 14, I would have to manually edit every READEXCEL statement every time I wanted new data--not fun when there are about 1,000 data sources that I use every month.

Please generalise the READEXCEL component to make specifying the Sheet, Column and Row components optional rather than compulsory.
1-Visitor
May 3, 2010
We will be looking at all of this in Prime 2. You can also update your Excel 2003 files to be read as Excel 2007.

Mona
1-Visitor
May 12, 2010
We plan to address these issues in Prime 2.0.

Mona