topic Write Excel Function in Mathcad https://www.ptcusercommunity.com/t5/Mathcad/Write-Excel-Function/m-p/37955#M15295 <HTML><HEAD></HEAD><BODY><P>Prime 2.0 has the function WRITEEXCEL. This will write data to an Excel spreadsheet. The function does not have the flexibility of the MathCAD v15. MathCAD v15 will start the writing to a specified sheet and cell. Not having this feature reduces the ability to transfer data to a spreadsheet for pre and post processing. Does anybody have a work around for this issue?</P></BODY></HTML> Thu, 03 May 2018 17:47:47 GMT tietjee 2018-05-03T17:47:47Z Write Excel Function https://www.ptcusercommunity.com/t5/Mathcad/Write-Excel-Function/m-p/37955#M15295 Prime 2.0 has the function WRITEEXCEL. This will write data to an Excel spreadsheet. The function does not have the flexibility of the MathCAD v15. MathCAD v15 will start the writing to a specified sheet and cell. Not having this feature reduces the ability to transfer data to a spreadsheet Thu, 03 May 2018 17:47:47 GMT https://www.ptcusercommunity.com/t5/Mathcad/Write-Excel-Function/m-p/37955#M15295 tietjee 2018-05-03T17:47:47Z Re: Write Excel Function https://www.ptcusercommunity.com/t5/Mathcad/Write-Excel-Function/m-p/37956#M15296 <HTML><HEAD></HEAD><BODY><P>It's such a shame that they never included this, but I can't see a workaround without the use of scriptable objects. I can't understand how they managed to implement the feature in READEXCEL but nor WRITEEXCEL??</P><P></P><P>Mike</P></BODY></HTML> Thu, 18 Oct 2012 06:22:30 GMT https://www.ptcusercommunity.com/t5/Mathcad/Write-Excel-Function/m-p/37956#M15296 MikeArmstrong 2012-10-18T06:22:30Z Re: Write Excel Function https://www.ptcusercommunity.com/t5/Mathcad/Write-Excel-Function/m-p/37957#M15297 <HTML><HEAD></HEAD><BODY><P>The functionality you are looking for is there in Prime 2 as well, only the syntax is changed(I think it is documented on the Migration guide). See screenshot below</P><P><IMG __jive_id="39026" class="jive-image-thumbnail jive-image" onclick="" alt="WriteXL_test.png" src="https://community.ptc.com/legacyfs/online/39026_WriteXL_test.png" width="450" /></P><P>Here 3 and 4 arguments represent starting row, col of dataset you want to write. So, 1,1 writes entire dataset.</P></BODY></HTML> Fri, 19 Oct 2012 13:57:30 GMT https://www.ptcusercommunity.com/t5/Mathcad/Write-Excel-Function/m-p/37957#M15297 tselvan 2012-10-19T13:57:30Z Re: Write Excel Function https://www.ptcusercommunity.com/t5/Mathcad/Write-Excel-Function/m-p/37958#M15298 <HTML><HEAD></HEAD><BODY><P>Well done you are correct. I really need to start working on Prime a little more.</P><P></P><P>My on earth does it say you cannot do this in the help?</P><P></P><P>Mike</P></BODY></HTML> Fri, 19 Oct 2012 14:08:41 GMT https://www.ptcusercommunity.com/t5/Mathcad/Write-Excel-Function/m-p/37958#M15298 MikeArmstrong 2012-10-19T14:08:41Z Re: Write Excel Function https://www.ptcusercommunity.com/t5/Mathcad/Write-Excel-Function/m-p/37959#M15299 <HTML><HEAD></HEAD><BODY><P>Tamizh, I tried using the format, but got the followin error</P><P></P><P>"The value must be a scalar or vector" The sheet and cell are highleghted.</P></BODY></HTML> Fri, 19 Oct 2012 19:41:39 GMT https://www.ptcusercommunity.com/t5/Mathcad/Write-Excel-Function/m-p/37959#M15299 tietjee 2012-10-19T19:41:39Z