projects:bvbbs:tables
Capturing Spreadsheet Data
1. Save the spreadsheet as an HTML file
Edit spreadsheet file: File menu --> SaveAs At the bottom of the form Click on the "All Formats" button and select "HTML document" Verify filename and location and Click on the "Save" button. At the popup verify that you want the "html" choice.
2. Remove all html styling from the file.
Open the html file in a "text" capable editor. Select all text and copy to the clip board. go to the "[[http://www.brave.net.au/online-html-cleanup-tool.php|Clean up HTML code]]" web site Paste the text (clipboard) into the "copy and paste" box. Select "clean this text" button. When the tool is finished removing all styling copy the result text back into the clipboard Paste the clean table into the new page. Replace the original text in the html file with the cleaned text save the html file in the work folder.
projects/bvbbs/tables.txt · Last modified: 2017/06/27 15:41 by 127.0.0.1