Skip to main content
I
Ikbal5-Regular Member
5-Regular Member
October 31, 2024
Solved

Import excel into mathcad prime 10

  • October 31, 2024
  • 3 replies
  • 10527 views

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?

Best answer by Werner_E

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.

 

3 replies

AndrewK
AndrewKCommunity Manager
Community Manager
November 5, 2024


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.

I
Ikbal5-Regular MemberAuthor
5-Regular Member
November 5, 2024

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

L
LucMeekes23-Emerald IV
23-Emerald IV
November 6, 2024

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

I
Ikbal5-Regular MemberAuthor
5-Regular Member
November 7, 2024

Dear Luc,

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

 

Best Regards,

Ikbal

W
Werner_E25-Diamond I
25-Diamond I
November 6, 2024

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

Werner_E_0-1730920574446.png

 

 

I
Ikbal5-Regular MemberAuthor
5-Regular Member
November 6, 2024

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

W
Werner_E25-Diamond IAnswer
25-Diamond I
November 7, 2024

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.

 

Terms & ConditionsAccessibility statement