Import excel into mathcad prime 10

[Ikbal]

Could you kindly assist me with importing an Excel sheet into Mathcad Prime? When I import, the quality of the documents is not good. I have tried to convert the page to an image, but the quality is very poor. How can I make it better?

[AndrewK]

Hi Ikbal,

Thank you for your question. 

Your post appears well documented but has not yet received any response. I am replying to raise awareness. Hopefully, another community member will be able to help.

Also, feel free to add any additional information you think might be relevant. It sometimes helps to have screenshots to better understand what you are trying to do.

[Ikbal]

Thank you Andrew for your response. The snapshot is attached here. 

[MartinHanak]

Hi,

https://community.ptc.com/t5/forums/searchpage/tab/message?filter=location&q=import%20excel%20into%20mathcad&noSynonym=false&location=forum-board:PTCMathcad&collapse_discussion=true

[Ikbal]

Thank you, Martin, for your help. I know all the options for importing from Excel or images in Mathcad Prime 10. 

My problem is when importing into Mathcad Prime, the quality is not as good as Mathcad 14. is this the problem with the Mathcad Prime 10 version?

Thank you in advance.

[MartinHanak]

Hi,

I am not able to answer your question. My suggestion - go to Mathcad area and repeat your question there.

[AndrewK]

Hi @Ikbal 

I can move your question to the Mathcad forum.

[LucMeekes]

The quality of the picture on the Prime 10 sheet looks OK to me. At a zoom level of 100 % it's sharp and tidy. What do you think is not good quality about it?

But the title of this topic says you want to import Excel into Prime... So where's the excel sheet?

And what (part of) Excel do you want to import?

Success!
Luc

[Ikbal]

Dear Luc,

I have uploaded the Excel file and also the Mathcad file. Yes, when I zoom in, it looks blurred.

Best Regards,

Ikbal

[Werner_E]

So your question is not about importing data from Excel to Prime for further calculations, correct?

You want to show a screenshot of an Excel page inside Prime for documentation purposes.

Copy and paste is quite a problem with Prime and we have often had complaints here about the poor quality of printouts, especially concerning plots and embedded images.
I haven't tried it, but maybe in your case the print quality will be better if you use Prime's Excel component.
So insert an Excel component into Prime and then copy the contents of the original Excel sheet into it (it doesn't seem to be more convenient). Reformatting the data in the Excel component might be necessary, though.

@LucMeekes 

Yes, the prime sheet looks good, but when printed as a PDF it looks very blurry. I suspect that this is the problem.

EDIT: I just made a test myself, comparing an embedded screenshot with an embedded Excel component.
I hardly can spot a significant difference in the pdf print. Both are not as crisp clear as the Prime text, but sure not as blurry as the numbers in the OP's posted pdf.
It may (also) have to do with the pdf printer used and the settings for resolution, etc. ?

I attach my test sheet and the pdf print.

@Ikbal 

I compared the original PNG you sent with the result of the pdf print. Doesn't compare that bad IMHO

[Ikbal]

Thank you Werner for your help. When I zoom out the documents (pdf), it looks blurred.

Here is all the file. Hope to get a better solution.

Best Regards,

Ikbal

[Werner_E · Accepted solution]

I agree that the pdf show a lot of antialiasing artefacts while the imported image in Prime looks better.

I now used your Prime file and exported it to a pdf three times.

Using 'printer' "Adobe PDF Print" using standard settings created the smallest file, but also the worst one in quality. Of course the settings in Adobe print could be adjusted.

Using 'printer' "Microsoft Print to PDF" created a much better quality file at the cost of four times the size

Using Primes own "Save to PDF" created a file similar to that of Microsoft, maybe Prime is just using the same printer driver.

So the problem may not be Prime but rather the way you use to create the PDF?
How did you create it, which pdf printer software did you use? Maybe you can set options there to increase resolution, etc. Or you may give Prime' PDF export facility a try.

I attach the three PDFs mentioned above.

EDIT: Just looked at the properties of the file created by Primes export facility and, yes, it used "Microsoft Print To PDF".

EDIT: I played around with the setting in the Adobe printer driver (a rather old version) and choosed something like "quality print". I expected a larger file size, but the file got smaller in size and better in quality 😉

Its additionally attached.

[Ikbal]

Thank you so much Werner,

I use the prime save as pdf option. Your one looks very good.  The same way I did, but the quality is not as good as yours.

Attached for your reference.

[Werner_E]

Hmmm, I agree that  my file is of slightly better quality. I also notice that my file is much larger than yours.

"The internet" says that the default quality of the Microsoft Print To PDF driver can be set to 'High Print Quality'.
I looked up the printer settings on my machine but all I can change is paper orientation and number of copies. I found no option to change the quality. Maybe this is a new feature in Win 11, because i am still using Win 10!?

You may also look in your printer configuration if you can change the quality of the "M$ Print To PDF" printer.

Otherwise you may try to install a free PDF 'printer' like CuteFTP or PDFCreator and give it a try.

[Werner_E]

Here is the result of CutePDF Writer using the standard settings (600 dpi)

Its smaller than yours, but I would say its of good quality.