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

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

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

YA_10963798
14-Alexandrite

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

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

YA_10963798_0-1730357285785.png

 

YA_10963798_1-1730357298783.png

thanks in advance

Yusra

ACCEPTED SOLUTION

Accepted Solutions
StuartBruff
23-Emerald III
(To:YA_10963798)


@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

 

 

View solution in original post

12 REPLIES 12

Hi,

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

Cheers

Terry

Nice , and handy 

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

Is that possible? 

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

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
23-Emerald III
(To:YA_10963798)


@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
14-Alexandrite
(To:StuartBruff)

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
23-Emerald III
(To:YA_10963798)

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 mcadMathcad(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.

 

 2024 10 31 F.png

 

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
14-Alexandrite
(To:StuartBruff)

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
23-Emerald III
(To:YA_10963798)

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
14-Alexandrite
(To:StuartBruff)

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

StuartBruff
23-Emerald III
(To:YA_10963798)

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

 

Stuart

YA_10963798
14-Alexandrite
(To:StuartBruff)

Thank you Stuart

Announcements

Top Tags