Use tab2xls if you have tab delimited files and want to convert them to a binary Excel format.
- It can be used standalone in Linux without D3
- It can be used in D3/Linux to create Excel spreadsheets in a Linux directory
- It can be used with our Email Gateway product to attach Excel documents to emails
- Support portrait and landscape modes
- Supports formulas and formatting commands embedded in the tab delimited files
How To Use It
carat is a special symbol and it is used this way:
^1 = bold this field
^2 = border on top
^3 = border on bottom
^4 = border both top and bottom
^5 = border left
^6 = border right
^7 = border all 4 sides
^8 = border three sides except left
^t = title bold, centered, bigger font
^tn; = title bold, centered, bigger font where n = width
^h = header, bold, centered, underlined
^hn; = header, bold, centered, underlined where n = col width
^p = percent, set_num_format(‘0%’)
^pn; = percent, set_num_format(‘0.n%’) where n = decimal places desired (1-4 only)
^q = percent, set_num_format(‘0%’) with ^4
^qn; = percent, set_num_format(‘0.n%’) where n = decimal places desired (1-4 only) with ^4
^s = percent, set_num_format(‘0%’) with ^6
^sn; = percent, set_num_format(‘0.n%’) where n = decimal places desired (1-4 only) with ^6
^u = percent, set_num_format(‘0%’) with ^8
^un; = percent, set_num_format(‘0.n%’) where n = decimal places desired (1-4 only) with ^8
^g = green background color
^r = red background color
^d = dollars, set_num_format(‘$0.00’)
^e = dollars, set_num_format(‘$0.00’) with ^4
^f = dollars, set_num_format(‘$0,000.00’) commas
^g = dollars, set_num_format(‘$0,000.00’) commas and ^4
^i = dollars, set_num_format(‘$0,000’) commas no decimals
^j = dollars, set_num_format(‘$0,000’) commas and ^4 no decimals
Note: percent values are like this: 15% is represented by .15 and 10 means 1000%
Example of a tab delimited file
^h3;TOTALS BY MONTH ^t12;ACCT ^t28;CATEGORY ^t25;SALES 4270 CHEMICALS ^i4047 4271 CARPETS ^i5143 4272 PAPER GOODS ^i2564
The above example would show a 3 column wide header “TOTALS BY MONTH” in bold large font. Then provide 3 titles for the 3 columns. Then the 3rd column would appear as dollar amounts.