Linux Based Convert of Excel Spreadsheet to a Professional HTML Table with Search and Filter Option
Download this Video ( High Quality ) and Instructions for Offline Viewing from here : https://sourceforge.net/projects/exce... Please Click SHOW MORE below.
Note-1 : This file gives you the latest and updated steps to do the
excel to html table conversion.
Note-2 : All my Open Source Project Website Links (below) carry
their own detailed instructions. Wish you Good Luck in your new Job Assignments.
Step 1: Download & Install the Custom-Puppy-Linux-For-Scripts Live CD,
Both 32-bit and 64-bit Versions,
on to a 8 GB Sandisk Cruzer Blade USB Drive (For Good Performance), Only Once.
Website : https://sourceforge.net/projects/comm...
Read Instructions given at the bottom of this website first, before downloading.
Step 2: Download the Latest Version of tabulate.zip & Extract it on to the
same USB drive, Only Once.
Website : https://sourceforge.net/projects/comm...
Step 3: Copy your Excel Sheets on to the tabulate folder, created in Step 2.
Step 4: Start the 64-bit OR 32-bit Custom Puppy Linux Live System from the
USB Drive.
Step 5: Single Click on the USB Drive Icon and then Open the tabulate folder
on the file manager.
Step 6: Single Click the *libreoffice*.sfs file downloaded earlier and
Click View contents on the Dialog Box Shown. The file manager will now
show the contents. Click on LibreOffice_Start and then
Open Your Excel Sheet from the LibreOffice Menu.
Step 7: Save Excel Sheet as Text CSV Type with Custom Delimiter,
i.e | or # preferably. Then view the CSV file on a Text Editor.
Note: Your Excel Sheet should not contain any delimiter character
in the data already. Verify this with Search on cell content.
Step 8: Launch Terminal by Pressing F4 on the tabulate folder
in the file manager.
Step 9: Edit / Copy / Paste / Execute the following conversion command
on the Terminal, by Pressing Enter Key :
cat "my_sheet.csv" | { cat ; echo ; } | ./tabulate.sh -d "|" -t "My Sheet" -h "My Data" ＞ "my_sheet.html"
Note-1 : The latest version and the explanation of this command
can be found on my project website mentioned in step 2 above.
Note-2 : Youtube video descriptions don't allow "Greater Than" symbol in
commands and replaces them with unicode lookalikes.
if you are copying the command from youtube, then please replace them
correctly after pasting it in your terminal. Use Arrow Keys to Navigate
inside Your Commands and Backspace / Delete / Insert Characters as required.
The above command can be edited according to your requirements.
Replace the Delimiter in the -d option with your chosen delimiter.
Step 10: Now open my_sheet.html generated with single click.
After verifying, Publish it on Local Webserver or on the
Internet Webserver of your Client.
Refer Section 10: Character Set to be used for your input data
on the Wiki page of my Project :
https://sourceforge.net/p/command-out...
I hope you enjoyed this presentation. Press Like, Share, Comment & Subscribe.
Thanks for watching.
P.S. My Other Open Source Projects are listed on my Profile Page :
https://sourceforge.net/u/nathan-sr/p...
Смотрите видео Linux Based Convert of Excel Spreadsheet to a Professional HTML Table with Search and Filter Option онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Nathan Sr 16 Март 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 406 раз и оно понравилось 1 людям.