call data from other mathcad sheet?( merging two sheets together)

[YA_10963798]

Is it possible to call input from other mathcad sheet?

Like in the first one we have the input and the second sheet has the equations. With out the need to repeat the data in the second sheet

Combining/merging both of them without the need to repeat the data

thanks in advance

Yusra

[terryhendicott]

Hi,

In the equations sheet go to menu item Input/Output | Include Worksheet and include the data sheet.

Cheers

Terry

[YA_10963798]

Nice , and handy 

One more quetion>> If I want to include only x values not the whole sheet? 

Is that possible? 

[terryhendicott]

Hi,

If you only want to include the x values you can quickly cut and paste to a new sheet and include this new sheet with only x values into the equation sheet.

Cheers

Terry

[YA_10963798]

Actually this is just an example... I have more than 500 matrix in other sheet and each has 4 columns length more than 200 ...but I don't need all of the 500 matrices I just need 325 of them ... this is why I asked 

[StuartBruff · Accepted solution]

---

@YA_10963798 wrote:

Actually this is just an example... I have more than 500 matrix in other sheet and each has 4 columns length more than 200 ...but I don't need all of the 500 matrices I just need 325 of them ... this is why I asked 

---

Are you after something like "import(from_worksheet,array_list)"?

If so, then no, I don't believe any such capability exists.  You could raise a feature request with support.  It could be pretty nifty as a means of limiting the (memory) size of a primary worksheet

What you could do, as a workaround, is export them from the secondary worksheet(s) to an Excel workbook (eg, one array to a worksheet) and then read them in as required.  All 500 & 325 of them. 😈

And for that, I'd definitely recommend using something like my Excel range creator function.  I'd also recommend using a similar function in the secondary worksheet to allow you to specify which worksheets to export where.  Even my slapdash soul quakes at the idea of the configuration control nightmare of manually creating and maintaining the necessary range specifications; it's a big enough task just creating the matrix of array/range specifications - but at least that should be more readily portable between Mathcad worksheets.

Stuart

Stuart

[YA_10963798]

Hi Stuart, 

I hope you are doing well. 

So , you are saying that mathcad support  team can add feature like ( RREADMATHCAD) doing the same job as ( READEXCEL). 

Actually I trying to make the pressure faster . When I use Excel that will take me ages. 

Thank you for your suggestion , I will contact the support team. 

Yusra 

[StuartBruff]

I hope you're doing well, too, Yusra.  You seem to be putting in long hours on this task.  🙂

Yes, the Mathcad support team can add features like READMATHCAD.  Whether they will depends upon the perceived usefulness and priority of the feature request. It should be possible for you (*) to write an external program (e.g., C++ or C#) to get the matrix data via the Mathcad API. I don't know whether it's doable through JScript in an advanced control.

Even if the Mathcad support team regarded the feature as Usefulness Rating A*** Priority Immediate+++, you'd still have to wait until the next major version release for it to be available ... unless you were lucky enough to be asked to be a Beta Tester.

Although not quite the same, I suggested way back in Mathsoft Mathcad days that a worksheet would be treated as a Mathcad data type with a user-selectable return value.  The basic idea was along the lines of mcad≔Mathcad(worksheet, optional funlist, optional varlist), so it is very similar to your READMATHCAD function.  IIRC, an extension was a Mathcad Region that would be a resizable embedded Mathcad worksheet, which would be completely editable as per Mathcad usual.  This would also have means of function/data input and output similar to what you see in an advanced control, except that you could call it as a function.

 

However, if you don't ask, you almost certainly won't get!

Stuart

(*) Or your minion or software support team, if you have them.

[YA_10963798]

Actually, Yes Stuart... I'm working on this task day in and day out.. Not only with mathcad other programs as well//

Anyways .. Does the function you suggested available in the new version? and how much time the support team usually takes to answer?

Very wise: if you don't ask, you almost certainly won't get!

[StuartBruff]

I thought you might be busy, given you post during the weekend as well. I hope you’re getting sufficient ”me” time in as well. 🙂

As for when Support will respond, I don’t know, I’m afraid. I don’t know how the Development Team decide what features to implement, their priority, or implementation version. I haven’t been a support-level customer for a long time.

I’m not aware of any plans to implement my request for an embedded Mathcad Region capable of returning data and functions directly or via a function assignment. The feature request is over 15 years old. I don’t even think it’s on the “ Maybe we’ll think about it one day, possibly when the Sun reaches its Red Giant stage” List. 😃

Stuart

[YA_10963798]

I see , thank you for your response ..I appreciate it . I will see what can we do .

[StuartBruff]

Good luck, Yusra.  It's a reasonable request.

Stuart

[YA_10963798]

Thank you Stuart