To display barcodes in Excel, the following are required:
1.A barcode font. We suggest two free barcode fonts:
a."Code 128" available at https://www.dafont.com/fr/code-128.font
128B implementation: Full ASCII set, no ASCII control characters
See https://grandzebu.net/informatique/codbar-en/codbar.htm
See below a message from GrandZebu
b."Free 3 of 9" Code 39 implementation: free3of9.zip available at https://www.barcodesinc.com/wp_new/free-barcode-font/
This includes the "Free 3 of 9" and "Free 3 of 9 Extended" fonts.
See below a message from Matthew Welch, its creator.
2.A structured value to display the bars:
a."Code 128":
Start - stop characters and a checksum are needed, quite difficult to encode.
Our include code128.i does the job for you!
b.Code 39, "Free 3 of 9":
Simply add a "*" at the beginning and end of the value.
Include code128.i:
Progress code:
{ code128.i }
Functions:
•Encoded_Value = getWindows128B( Text_To_Encode ) :
returns the encoded Windows value,
•Encoded_Value = getExcel128B( Text_To_Encode ) :
returns the encoded Excel value,
•Encoded_Value = get128B( Text_To_Encode, isExcel ) :
returns the encoded Windows or Excel value depending on the logical value of isExcel
Use with vpxPrint:
When using code 128B with xPrint, the easiest way is to use the getWindows128B() function.
During standard Excel export, xPrint automatically converts Windows code into Excel code.
This allows barcodes to be displayed equally well in Windows forms or Excel spreadsheets.
Use outside vpxPrint:
If the program directly creates an Excel connection, use getExcel128B()
Demo program:
Excel_Barcode.w:
Code 128 of GrandZebu:
I had to get interested in bar codes for working reasons. Surprise, there is nothing free on the net, it seems awfully intricate and we consider to have to buy a heap of special tools. In fact, after studying some scattered documentation all becomes very easy. I have made my tests with a basic materiel : HP laserjet printer to 300dpi, Canon inkjet printer and barcode reader DC 200 (The first price). In the following pages I will provide you all the software parts... free as usual.
You use my programs and barcode fonts or quite simply you found an interest in my pages.
I write these pages and the barcode programs with informations collected on Internet. I give all this places free under license GNU-GPL. In order to buy some standards I'd founded a system of piggybox. I have these standards now but nevertheless I leave this piggybox in place for those which wishes to pour their mite in thanks.
I have selected the PayPal system which offers all the guarantees of safety, while clicking on one of the 3 piggyboxes below you will be redirected on their site where you will carry out your transaction in protected mode. On this site you can pay with a previous owned PayPal account or by bank card. Personal information which is required of you by PayPal will not be communicated to me.
Free 3 of 9 of Matthew Welch:
Font: Free 3 of 9 Barcode
Created By: Matthew Welch
E-Mail: matt@squaregear.net
Web Address: http://www.squaregear.net/fonts/
"My fonts are all free. You can use them for personal or commercial projects,
and I ask for no money. I would, however, love to hear from you. If you use
my fonts for something please e-mail me letting me know how you used it. Send
me a copy if you can or let me know where I can find your work. You are under
no obligation to do this, I just like to see how my fonts get used."
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
THE SOFTWARE.