Download
Please watch the video below, to convert any file or a command output into a nice html table, in less than 5 Minutes time. The output html file can then be browsed from any location, using a local webserver or an internet www domain.
Usage Examples: (Type them on Terminal)
cd ~/Downloads/tabulate # location
chmod +x *.sh
cat "student_marks.csv" | { cat ; echo ; } | ./tabulate.sh -d "," -t "My School" -h "First Term" > "marks.html"
# or > "/var/www/html/marks.html"
-d specifies delimiting character, which is in between your input columns
-t specifies page title
-h specifies a header
Browse marks.html with browser now, either by double clicking file, from file manager or inputting location on your browser.
Other Examples:
df -h | { cat ; echo ; } | ./tabulate.sh -d " " -t "My System" -h "Disk Free" > "diskfree.html"
Refer Wiki, Tickets, Discussion for more inputs and new jobs, that can arise, with this script.
Please see below for LATEST UPDATES
Features
- Another Example: Tab Seperated Values : cat "test.tsv" | { cat ; echo ; } | ./tabulate.sh -d $'\t' > "test.html" See Wiki for more such special characters.
- The | { cat ; echo ; } ensures a blank line at the end of your input records, to help process the last record as well.
- LATEST UPDATE : 1. tabulate.zip version 2.11 released on 2022-08-16. Refer Wiki for its new features. 2. A custom Puppy Linux Operating System has been created for this purpose of running the script on various client computers. You can download it here : https://sourceforge.net/projects/command-output-to-html-table/files/OS/ Wherever possible, give preference to the 64-bit system over the 32-bit system for better performance and features. You can copy and paste the code easily on the Terminal / Console program on this operating system, by using the keyboard shortcut keys like Ctrl+Insert for copying selected text and Shift+Insert for pasting copied text OR ELSE Middle Click Mouse Button / Wheel For Pasting on Terminal / Console. Also, you can choose Edit Menu - Paste or else Right Click Menu - Paste. Press F4 to launch the Terminal from any Folder on the File Manager. This will set your working directory automatically. Use your favorite text editor to edit commands as required and then copy / paste it on the terminal / console and then press the enter key to execute it. 4. Also, a custom MX Linux usb installation image and a custom Ubuntu usb installation image is available on my other project sites : https://sourceforge.net/projects/custom-mx-linux-image-for-usb/ and https://sourceforge.net/projects/custom-ubuntu-image-for-usb/
- Please note that this script may be giving "Permission Denied" errors while operating from FAT32 pen drives. Copy them to a permission aware filesystems like ext, hfs etc. and then work on it. Otherwise, try prefixing the ./tabulate.sh with sh word. i.e. sh ./tabulate.sh This does not occur on the Custom Puppy Linux mentioned in the LATEST UPDATE.
- For Converting an Excel Sheet to an HTML Table, please refer my other youtube video : https://youtu.be/5Y8SdI-c7uU
- To generate a CSV file from an Excel Sheet with Pipe Delimiter instead of Comma, please watch : https://www.youtube.com/watch?v=RM6L8sRIPpU
- For more spreadsheet programs that can generate files with custom delimiters, please refer Section 16 of the Wiki Page on this website
- The double quotes used in the examples above for file names and strings will help in allowing multiple words with spaces in them
- For Converting an Excel Sheet OR Command Outputs of Servers OR Database Text Files to a Professional HTML Chart, Please refer my other project : https://sourceforge.net/projects/command-output-to-html-chart/
Project Samples
