1 / 11

Converting Spreadsheets to Web Pages: CSS Inheritance and Table Management

Explore the process of converting spreadsheets to web pages, focusing on CSS inheritance and efficient table handling. Understand how multiple CSS classes can apply to elements, ensuring uniform styling while avoiding conflicts. Learn to reference cells across worksheets, employ various tools for table conversion, and utilize Regular Expressions for effective data cleanup. This guide includes tips on using Komodo for find/replace operations and the use of HTML Formatter, making your web development smoother and more organized.

ronda
Download Presentation

Converting Spreadsheets to Web Pages: CSS Inheritance and Table Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. From Spreadsheets to Web Pages 27 February 2014

  2. Follow Ups

  3. CSS Inheritence • If you have 2 entries in your CSS: div {} div.class {} • BOTH are applied to <div class=“class”> • Taking advantage: “all my divs will have a border” • Problems: widths can conflict and rules aren’t obvious

  4. Looking at Formulas On PC On Mac

  5. Multiple Worksheets

  6. Crossing Worksheets • Can reference a cell on another worksheet by going there or typing worksheet_name!A7 • Computation Worksheets • Build as many columns as you want • Do it in small steps

  7. From Spreadsheet to Web

  8. Getting Tables to the Web • Numerous tools to convert tables • Addition table • Mr. Data Converter • Sets up classes • Formatted • Caveat: it requires that there be a value in the upper left cell • Tableizer • No classes • Not formatted • We have had Mac problems

  9. Using Komodo Tools • Find/Replace is your friend • Resources page on website • Regular Expressions • Komodo Primer • Notes

  10. Regular Expressions • allow you to match other than an exact string • Key capabilities • /w any alphanumeric • /s any space • [] any of the enclosed • + 1 or more • * 0 or more

  11. Table cleanup • From Mr Data Converter • class=“[\w\s-]+” • Will match all of the classes generated • From Tableizer • Need multi-line as well as Regex • Use enter and tabs in Komodo • Copy and paste into “Replace with” OR • Use HTML Formatter

More Related