1-Visitor

Solved

WRITEEXCEL is corrupting Excel file

Forum|Forum|8 years ago
October 14, 2017
4 replies
6358 views

Hi all! I'm currently using MathCad 15 and I can't seem to get the seem together the Excel function to work correctly. It keeps writing to excel and making the file corrupt and messing with the formating, making it impossible to write all the arrays to Excel is there something I'm doing wrong?

1_MathCad-Windfarm-Collection.zip

Other

Best answer by terryhendicott

Hi,

Final pair. Excel and MathCad.

To stop the formatting from getting changed and to allow auditing of both MathCad and Excel.

Workaround is in the Excel file create a "MathCad Export" worksheet tab. No formats on this worksheet.

On the actual worksheet for the job just set cells equal to corresponding cells on the MathCad Export sheet.

V

ValeryOchkov

24-Ruby IV

What about Mathcad Prime?

J

Johnruehlz

Author

1-Visitor

I'm unable to use MathCad prime because our whole company uses 14/15

T

terryhendicott

21-Topaz II

hi,

sometimes it is better to stick to the one thing. the calculations you are trying to do can be done entirely in excel.

entry is only required in yellow cells. calculation cells can be simply copied/pasted down as required.

to do this you need to change the 4/0 designation in text to a 4.0 designation in number format.

On you mathcad sheet i cannot find the subscript(i) function so this may be your problem

Cheers

Terry

1_171016-1.zip

J

Johnruehlz

Author

1-Visitor

Subscript(i) function is found in one of the tabs. I agree that having Excel do the work would be easier, but if we get an audit it is way easier to show our findings through MathCad then Excel.

T

terryhendicott

21-Topaz II

hi,

sorry mistake in last file the voltage column also needs to be input so should be yellow input cells

1_171016-2.zip

T

terryhendicott

21-Topaz II

Hi,

You are doing nothing wrong. Have been messing with this today. Excel can save files in 2003 "xls" and no year designation "xlsx" MathCad 15 is designed to work with 2007 "xlsx" files acciording to help. Ten years of changes in Excel file standards has not been kept up with by PTC and it is unlikely they will.

You can in Excel name ranges like "Cables" and "Circuit1" etc.

'

On Excel to MathCad

Excel 2003 "xls" MathCad can read and when you input into MathCad using Insert|Data|FileInput choose Excel Files, browse to a file, choose an xls 2003 file with named sheets and ranges, next. In the drop down list boxes for "worksheet" and "named ranges" values are there to select matching those in the excel file. With Excel "xlsx" files nothing appears in the these dialog boxes you must write it yourself in the text box.

On Mathcad to Excel

You can cut and paste no worries. Use WRITEEXCEL only supports 2007 "xlsx" files. You can't use 2003 "xls". Using your example you do loose formats and do corrupt the file. I will experiment some more but I think the problem is the "xlsx" standard has moved on beyond the 2007 era in the last ten years. I have an old laptop running Excel 2007 so I will put it through its paces with WRITEEXCEL and its "xlsx" format to see if the versioning is the problem.