How to update values after using readcsv function in mathcad?

[ppandarkar-2]

Hi,

I have one csv file which will get modify  by another application. and i want to link this csv with mathcad and use their values for further calculation.

I checked but first time it got imported but if csv got modified the values from mathcad sheet not getting modify so please can some one suggest how can i achieve this.

Thanks,

Prashant Pandarkar

[Werner_E · Accepted solution]

You will have to manually recalculate your worksheet F9 or F5 or Ctrl-F5).

[ppandarkar-2]

Okay.

but we have auto-calculation "ON", so still we need to click again manually.

As we are integrating sheet with creo model so for that we need to launch mathcad and then need to recalculate.

-Prashant Pandarkar

[Werner_E]

---

@ppandarkar-2 wrote:

Okay.

but we have auto-calculation "ON", so still we need to click again manually.

---

Yes. I could image an automation solution using Mathcad (15 or below) using scripted components, but they are not available in Prime.

---

As we are integrating sheet with creo model so for that we need to launch mathcad and then need to recalculate.

---

I don't know Creo - unless there is a way to activate Prime's recalculation from Creo (maybe via a script using Primes API), I guess it has to be done manually. Sure not satisfactory.

[ppandarkar-2]

Okay.

Thanks for the details, it helps me to add my knowledge.

- Prashant Pandarkar