topic Re: Output to specific Excel Worksheet (via excel component) in Mathcad

Output to specific Excel Worksheet (via excel component)

ArneClaußen — Thu, 03 May 2018 19:08:44 GMT

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

Re: Output to specific Excel Worksheet (via excel component)

RichardJ — Thu, 09 Dec 2010 16:11:04 GMT

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.

Re: Output to specific Excel Worksheet (via excel component)

MikeArmstrong — Thu, 09 Dec 2010 17:36:43 GMT

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

Mike

Re: Output to specific Excel Worksheet (via excel component)

RichardJ — Thu, 09 Dec 2010 18:13:06 GMT

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

Re: Output to specific Excel Worksheet (via excel component)

MikeArmstrong — Thu, 09 Dec 2010 19:42:34 GMT

In my opinion that is one of the most important scripted components, before the release of Mathcad 15.

It's a little shame they included it in M15, makes the function a little less impressive.

Mike

Re: Output to specific Excel Worksheet (via excel component)

RichardJ — Thu, 09 Dec 2010 20:10:16 GMT

It's a little shame they included it in M15, makes the function a little less impressive.

Not to me, and probably many others. My version of Excel will not read the new XML based format, so the new Mathcad function is completely useless.

Re: Output to specific Excel Worksheet (via excel component)

MikeArmstrong — Thu, 09 Dec 2010 20:12:44 GMT

Not to me, and probably many others. My version of Excel will not read the new XML based format, so the new Mathcad function is completely useless.

2007 or 2010?

Mike

Re: Output to specific Excel Worksheet (via excel component)

RichardJ — Thu, 09 Dec 2010 20:35:28 GMT

You mean my version of Excel? It's version 2000.I'm too cheap to upgrade because the only thing I use Excel for is tabulating some data ocasionally. I use Mathcad for everything else. I do also have OpenOffice, which will read Excel 2007 XML files, but I would rather write the file from Mathcad in a format that my old version of Excel can read.

Actually, I misread the help anyway. READEXCEL can read from specified sheets and ranges, but WRITEEXCEL does not allow you to specify even the range, let alone the sheet! So the scripted component is still necessary.

Re: Output to specific Excel Worksheet (via excel component)

MikeArmstrong — Thu, 09 Dec 2010 21:10:49 GMT

You mean my version of Excel? It's version 2000.I'm too cheap to upgrade because the only thing I use Excel for is tabulating some data ocasionally. I use Mathcad for everything else. I do also have OpenOffice, which will read Excel 2007 XML files, but I would rather write the file from Mathcad in a format that my old version of Excel can read.

Exactly in the same boat. My employer just upgrade though because we still have engineer who have not converted yet.

Actually, I misread the help anyway. READEXCEL can read from specified sheets and ranges, but WRITEEXCEL does not allow you to specify even the range, let alone the sheet! So the scripted component is still necessary.

Great It's still worthwhile, until Prime is released.

Mike

Re: Output to specific Excel Worksheet (via excel component)

RichardJ — Thu, 09 Dec 2010 22:14:20 GMT

Great It's still worthwhile, until Prime is released.

WRITEEXCEL in Prime has the same limitations, except that it will also wrrite to XLS files.

Re: Output to specific Excel Worksheet (via excel component)

MikeArmstrong — Thu, 09 Dec 2010 22:19:49 GMT

I'm getting a bad dose of de deja vu here. Are you sure Tom posted that worksheet? I know he posted the XLstorage function.

I have created mulitple threads on this topic and eventually got the answer I wanted. Although most of my work on using an Excel embedded component.

Mike

Re: Output to specific Excel Worksheet (via excel component)

RichardJ — Thu, 09 Dec 2010 22:32:08 GMT

I'm getting a bad dose of de deja vu here. Are you sure Tom posted that worksheet?

I think I got it from one of his posts. The worksheet certainly conforms exactly to his default template.

Re: Output to specific Excel Worksheet (via excel component)

MikeArmstrong — Thu, 09 Dec 2010 22:34:48 GMT

I think I got it from one of his posts. The worksheet certainly conforms exactly to his default template.

Yes it does. I have just checked my saved file and it matches the one you posted.

Mike