Printing Reciepts from Excel on a dot matrix printer

%3CLINGO-SUB%20id%3D%22lingo-sub-1476400%22%20slang%3D%22en-US%22%3EPrinting%20Reciepts%20from%20Excel%20on%20a%20dot%20matrix%20printer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1476400%22%20slang%3D%22en-US%22%3EHi%20all%2C%3CBR%20%2F%3E%3CBR%20%2F%3ENeed%20some%20advise%20on%20dot%20matrix%20printing%20and%20excel.%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20looking%20at%20setting%20up%20a%20dot%20matrix%20printing%20system%20at%20work%20to%20generate%20till%20reciepts%20for%20our%20business%2C%20and%20then%20print%20on%20triple%20carbon%20paper%20so%20have%20customer%2C%20office%20and%20warehouse%20picking%20copies.%3CBR%20%2F%3E%3CBR%20%2F%3EWe%20currently%20use%20both%20a%20Google%20sheets%20document%20and%20Excel%20document%20with%20databases%20and%20vlookup%20to%20generate%20quotes%20and%20invoices%20and%20print%20them%20on%20a%20standard%20inkjet%20printer.%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20question%20is%20prior%20to%20buying%20a%20dot%20matrix%20printer%20and%20all%20the%20paper%20will%20excel%20be%20able%20to%20print%20these%20as%20normal%20to%20a%20dot%20matrix%20printer%3F%20Or%20will%20they%20have%20to%20be%20a%20specific%20layout%20or%20spreadsheet%20type%3F%3CBR%20%2F%3E%3CBR%20%2F%3ECan't%20find%20a%20great%20deal%20of%20info%20online%20about%20it%20and%20don't%20really%20know%20much%20about%20this%20type%20of%20printing%20or%20its%20compatability%20with%20programs%20like%20excel%2C%20Google%20sheets%20etc%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20info%20from%20anyone%20that%20uses%20this%20style%20of%20dot%20matrix%20printing%20system%20for%20POS%20till%20systems%20with%20excel%20or%20any%20other%20ideas%20would%20be%20much%20appreciated%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1476400%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1484618%22%20slang%3D%22en-US%22%3ERe%3A%20Printing%20Reciepts%20from%20Excel%20on%20a%20dot%20matrix%20printer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1484618%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F704304%22%20target%3D%22_blank%22%3E%40Kiegilmour%3C%2FA%3E%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20the%20dot%20matrix%20printer%20to%20print%20excel%2C%20compatibility%20will%20be%20based%20on%20your%20operating%20system%20not%20based%20on%20excel.%20You%20should%20check%20%26nbsp%3Byour%20OS%20should%20supports%20that%20printer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20the%20font%20%22%3CSTRONG%3ECourier%20New%3C%2FSTRONG%3E%22%20that%20will%20work%20great%20with%20dot%20matrix%20printer%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1486807%22%20slang%3D%22en-US%22%3ERe%3A%20Printing%20Reciepts%20from%20Excel%20on%20a%20dot%20matrix%20printer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486807%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F704304%22%20target%3D%22_blank%22%3E%40Kiegilmour%3C%2FA%3E%26nbsp%3B%20If%20you%20want%20to%20use%20the%20printer's%20fonts%20directly%2C%20try%20to%20set%20it%20up%20as%20a%20generic%20text%20printer.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hi all,

Need some advise on dot matrix printing and excel.

I'm looking at setting up a dot matrix printing system at work to generate till reciepts for our business, and then print on triple carbon paper so have customer, office and warehouse picking copies.

We currently use both a Google sheets document and Excel document with databases and vlookup to generate quotes and invoices and print them on a standard inkjet printer.

My question is prior to buying a dot matrix printer and all the paper will excel be able to print these as normal to a dot matrix printer? Or will they have to be a specific layout or spreadsheet type?

Can't find a great deal of info online about it and don't really know much about this type of printing or its compatability with programs like excel, Google sheets etc

Any info from anyone that uses this style of dot matrix printing system for POS till systems with excel or any other ideas would be much appreciated
2 Replies

Hi @Kiegilmour;

 

You can use the dot matrix printer to print excel, compatibility will be based on your operating system not based on excel. You should check  your OS should supports that printer.

 

Use the font "Courier New" that will work great with dot matrix printer 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

@Kiegilmour  If you want to use the printer's fonts directly, try to set it up as a generic text printer.