Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X
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
Solved! Go to 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
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
@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
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
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.
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!
Good luck, Yusra. It's a reasonable request.
Stuart
Thank you Stuart