Difference between revisions of "Manual:Extension/BlueSpiceExportTables"
[unchecked revision] | [quality revision] |
(Tag: 2017 source edit) |
m (Tag: 2017 source edit) |
ExportTables allows exporting tables and grids on wiki pages to Excel formats.


Contents
- 1 What is BlueSpiceExportTables? 2 Using BlueSpiceExportTables 2
- How to export a table 2
- 3
- 2 Formats 4
- 3 Exporting data from grids
- 5 See also


How to export a table[edit | edit source]
BlueSpiceExportTables allows exporting tables on wikipages and grids with tabular data.
Using BlueSpiceExportTables[edit | edit source]
Any regular table that is insert on a page can be exported. Before table export is possible, the table must be configured to support exporting.
In VisualEditor[edit | edit source]
While editing a page in VisualEditor, click on the page table and select "Properties". In the dialog that is opened, turn on activtate the option "Exportable".
In Wikitext[edit | edit source]
Table A table can be set to be exportable in wiki text wikitext as well. Add the classes "bs-exportable" and "exportable" to the table's "class" argument.
{| class="wikitable bs-exportable exportable" |+...
After saving the page, all users viewing the page can export the table by right-clicking on the table and selecting desired an export format.
Formats[edit | edit source]
Formats that are offered for exporting a page are:
- CSV - Comma separated values
- XLS - Microsoft Office Excel 2003
-
XLSX - Microsoft Office Excel
Exporting data from grids[edit | edit source]
In addition to exporting the tables on pages, most of BlueSpice managers and other extensions that display tabluar data also offer allow exporting of data. Exporting such data is done over the "Export table" menu in right top corner of the managers like BlueSpiceNamespaceManagerthe Namespace manager.
See also[edit | edit source]
Reference page for this extension.
Related info
__TOC__ [[File:ExportTables1.png|thumb|Opening properties of a table in VisualEditor]] [[File:ExportTables2.png|thumb|Turning on "exportable" option in VisualEditor]] [[File:ExportTables3.png|thumb|Export table menu in page view mode]] [[File:ExportTables4.png|thumb|Exporting tables in managers]] ==What is BlueSpiceExportTables?== '''BlueSpiceExportTables''' allows exporting tables on wikipages and grids with tabular data. ==Using BlueSpiceExportTables{{DISPLAYTITLE:Export tables}} '''ExportTables''' allows exporting tables and grids on wiki pages to Excel formats. ==How to export a table== Any regular table that is insert on a page can be exported. Before table export is possible, the table must be configured to support exporting. ===<br />[[File:ExportTables3.png|thumb|Making a table exportable|alt=Making a table exportable|center|650x650px]] ===In VisualEditor=== While editing a page in VisualEditor, click on the pagetable and select "''Properties"''. In the dialog that is opened, turn onactivtate the option "''Exportable". ===In Wikitext=== Table ''. <br />[[File:ExportTables2.png|thumb|Opening table properties in VisualEditor|alt=Opening table properties in VisualEditor|center|650x650px]] ===In Wikitext=== A table can be set to be exportable in wiki text wikitext as well. Add the classes "bs-exportable" and "exportable" to the table's "class" argument. <pre> {| class="wikitable bs-exportable exportable" |+... </pre> After saving the page, all users viewing the page can export the table by right-clicking on the table and selecting desired an export format. ==Formats== Formats that are offered for exporting a page are: * *CSV - Comma separated values * XLS - Microsoft Office Excel 2003 * XLSX - Microsoft Office Excel ==<br />[[File:ExportTables4.png|thumb|The "export table" menu in page view mode|alt=The "export table" menu in page view mode|center|650x650px]] ==Exporting data from grids== In addition to exporting the tables on pages, most of BlueSpice managers and other extensions that display tabluar data also offerallow exporting of data. Exporting such data is done over the "Export table" menu in right top corner of the managers like the [[Manual:Extension/BlueSpiceNamespaceManager|BlueSpiceNamespaceManager]]. ==See also== [[ExportTables|Reference page]] for this extension.NamespaceManager|Namespace manager]]. <br /> [[File:ExportTables1.png|thumb|Exporting tables in management grids|alt=Exporting tables in management grids|center|650x650px]]{{Box Links-en|Topic1=[[Reference:BlueSpiceExportTables]]}}<br /> {{Translation}} __FORCETOC__ [[Category:Editing]]
(11 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | + | {{DISPLAYTITLE:Export tables}} | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | ''' | + | '''ExportTables''' allows exporting tables and grids on wiki pages to Excel formats. |
− | == | + | ==How to export a table== |
− | Any regular table that is insert on a page can be exported. Before table export is possible, table must be configured to support exporting. | + | Any regular table that is insert on a page can be exported. Before table export is possible, the table must be configured to support exporting. |
+ | |||
+ | <br />[[File:ExportTables3.png|thumb|Making a table exportable|alt=Making a table exportable|center|650x650px]] | ||
===In VisualEditor=== | ===In VisualEditor=== | ||
− | While editing a page in VisualEditor, click on the | + | While editing a page in VisualEditor, click on the table and select ''Properties''. In the dialog that is opened, activtate the option ''Exportable''. |
− | + | <br />[[File:ExportTables2.png|thumb|Opening table properties in VisualEditor|alt=Opening table properties in VisualEditor|center|650x650px]] | |
===In Wikitext=== | ===In Wikitext=== | ||
− | + | A table can be set to be exportable in wikitext as well. | |
− | Add classes "bs-exportable" and "exportable" to the table's "class" argument. | + | Add the classes "bs-exportable" and "exportable" to the table's "class" argument. |
<pre> | <pre> | ||
{| class="wikitable bs-exportable exportable" | {| class="wikitable bs-exportable exportable" | ||
Line 23: | Line 20: | ||
</pre> | </pre> | ||
− | After saving the page, all users viewing the page can export the table by right-clicking on the table and selecting | + | After saving the page, all users viewing the page can export the table by right-clicking on the table and selecting an export format. |
− | |||
==Formats== | ==Formats== | ||
Formats that are offered for exporting a page are: | Formats that are offered for exporting a page are: | ||
− | * CSV - Comma separated values | + | |
− | * XLS - Microsoft Office Excel 2003 | + | *CSV - Comma separated values |
− | * XLSX - Microsoft Office Excel | + | *XLS - Microsoft Office Excel 2003 |
+ | *XLSX - Microsoft Office Excel<br />[[File:ExportTables4.png|thumb|The "export table" menu in page view mode|alt=The "export table" menu in page view mode|center|650x650px]] | ||
==Exporting data from grids== | ==Exporting data from grids== | ||
− | In addition to exporting the tables on pages, most of BlueSpice managers and other extensions that display tabluar data also | + | In addition to exporting the tables on pages, most of BlueSpice managers and other extensions that display tabluar data also allow exporting of data. Exporting such data is done over the "Export table" menu in right top corner of the managers like the [[Manual:Extension/NamespaceManager|Namespace manager]]. |
+ | <br /> | ||
+ | [[File:ExportTables1.png|thumb|Exporting tables in management grids|alt=Exporting tables in management grids|center|650x650px]]{{Box Links-en|Topic1=[[Reference:BlueSpiceExportTables]]}}<br /> | ||
− | + | {{Translation}} | |
+ | __FORCETOC__ | ||
− | [[ | + | [[Category:Editing]] |