From spreadsheets to web pages
This presentation is the property of its rightful owner.
Sponsored Links
1 / 11

From Spreadsheets to Web Pages PowerPoint PPT Presentation


  • 75 Views
  • Uploaded on
  • Presentation posted in: General

From Spreadsheets to Web Pages. 27 February 2014. Follow Ups. CSS Inheritence. If you have 2 entries in your CSS: d iv {} d iv.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.

Download Presentation

From Spreadsheets to Web Pages

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


From spreadsheets to web pages

From Spreadsheets to Web Pages

27 February 2014


Follow ups

Follow Ups


Css inheritence

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


Looking at formulas

Looking at Formulas

On PC

On Mac


Multiple worksheets

Multiple Worksheets


Crossing worksheets

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


From spreadsheet to web

From Spreadsheet to Web


Getting tables to the web

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


Using komodo tools

Using Komodo Tools

  • Find/Replace is your friend

  • Resources page on website

  • Regular Expressions

    • Komodo Primer

    • Notes


Regular expressions

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


Table cleanup

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


  • Login