Skip to main content
ArneClaußen1-Visitor
1-Visitor
December 9, 2010
Question

Output to specific Excel Worksheet (via excel component)

  • December 9, 2010
  • 12 replies
  • 8311 views

Hello,

i want to send Data to different Worksheets in Excel.

But how kann i specify the Sheet in the output range?

Sheetname!A1 oder Sheetname:A1 does not work?

Can someone help me?

Greetings

12 replies

RichardJ19-Tanzanite
19-Tanzanite
December 9, 2010

Except in Mathcad 15, you can't set the sheet. In Mathcad 15 you can use the WRITEEXCEL function, but that is very non-flexible (in particular, it will only write an Excel file in XLXS format).

Here's a scripted component (written by Tom Gutman, not me) that will do what you want, in a very flexible way, in any version of Mathcad.

MikeArmstrong1-Visitor
1-Visitor
December 9, 2010

I have this worksheet saved and filed, but cannot remember where I seen it posted.

Mike

RichardJ19-Tanzanite
19-Tanzanite
December 9, 2010

I couldn't find the original thread either. That's why I reposted it

Terms & ConditionsAccessibility statement