Skip to main content
14-Alexandrite
October 31, 2024
Solved

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

  • October 31, 2024
  • 1 reply
  • 2398 views

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

Best answer by StuartBruff

@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

 

 

1 reply

21-Topaz II
October 31, 2024

Hi,

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

Cheers

Terry

14-Alexandrite
October 31, 2024

Nice , and handy 

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

Is that possible? 

23-Emerald V
October 31, 2024
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