ImportTabTable

Summary: import and convert tab table to simple table markup quickly.
Version: 2010-04-14
Prerequisites:
Status: stable
Maintainer: HansB
Users: (View? / Edit?)

Questions answered by this recipe

How can I import a table from another application? How can I import a tabbed table?

Description

This script makes it possible to import and convert tabbed tables from other applications (as from spreadsheet, word, rtf applications) into PmWiki simple tables.

Copy tab2table.phpΔ to your cookbook folder, install in a config file:

include_once('cookbook/tab2table.php');

Usage:

Highlight and copy the table cells to the clipboard, and paste into the edit box of a wiki page. Then click the 'Table' GUI button to convert into PmWiki simple table markup, and save your page.
Numeric cells are automatically right-aligned, while other cells are left-aligned.
Lines in the edit window which do not contain tab characters are ignored.

If for any reason the page contains tab characters which shall remain intact, add a line with the word TABLE (in Capitals) before the pasted tabbed table, and add a line with the word END after it, then proceed to convert by clicking the table GUI button.

Notes

This script works similar than ExcelPaste, but avoids converting lines which contain no tab characters, and does not add lots of space characters.

Release notes

If the recipe has multiple releases, then release notes can be placed here. Note that it's often easier for people to work with "release dates" instead of "version numbers".

See also

  • Text2Tbl Provide a way to convert arbitrarily structured text to table markup and provide conversion of simple tables to advanced.
  • ExcelPaste Copy and paste spreadsheet tables (e.g., from Excel) into pages
  • Tabulate Handles tab-delimited tables so you can cut and paste to and from spreadsheet applications

Contributors

Comments

See discussion at ImportTabTable-Talk?

User notes? : If you use, used or reviewed this recipe, you can add your name. These statistics appear in the Cookbook listings and will help newcomers browsing through the wiki.