Skip to main content
S
sdidam1-Visitor
1-Visitor
November 4, 2015
Solved

write data to excel (in a row without overwriting the other rows)

  • November 4, 2015
  • 2 replies
  • 1599 views

Hello everyone,

I want to write data from Mathcad to an Exceldocument, where already data is saved.

The original data for example looks like this:

Excel-vorher.JPG

I want to overwrite the data in a special row. In the other rows, the data should not change. Below is my Mathcad file with 3 ways of writing data to Excel. The data should be written to the row with the number of the ID (here 3).

Mathcad.JPG

______________________________________________________________________________________________

The Variable k overwrite the first row, so this is wrong, see below.

Excel-nachher.JPG

________________________________________________________________________________________________

The Variable kk here gives the right solution, but only for ID=3, see below. So I find a third way, where I can change the ID. But if I have 1000 ID´s, this solution is very time-consuming.

Is there a better way to solve the problem?

Excel-nachher2.JPG

Thank you

Stephan

Best answer by MJG

Try using the "concat" & "num2str" functions.  I didn't test it, but I think the following should work:

WRITEEXCEL(".\a.xlsx",M,concat("[3]A",num2str(ID)))

2 replies

M
MJG1-VisitorAnswer
1-Visitor
November 4, 2015

Try using the "concat" & "num2str" functions.  I didn't test it, but I think the following should work:

WRITEEXCEL(".\a.xlsx",M,concat("[3]A",num2str(ID)))

S
StuartBruff23-Emerald V
23-Emerald V
November 4, 2015

Mark Gase wrote:

 

Try using the "concat" & "num2str" functions.  I didn't test it, but I think the following should work:

WRITEEXCEL(".\a.xlsx",M,concat("[3]A",num2str(ID)))

That will work.  There was a recent thread on a similar subject: https://community.ptc.com/t5/PTC-Mathcad/Excel-component-in-a-program/td-p/226416.

 

One of the differences between that thread and this one, is that column ID extended into AA, etc. One solution to that particular problem is to use R1C1 notation, which is simple using just num2str.  However, most people are more familiar with, and can lookup a lot easier, A1 addresses, which means converting the column number to its corresponding string.  

 

Stuart

Terms & ConditionsAccessibility statement