Difference between revisions of "Manual:Extension/BlueSpiceExportTables"
[unchecked revision] | [quality revision] |
(Created page with "__HIDETITLE__ <bs:bookshelf src="Book:User manual" /> __TOC__ ==What is ExportTables?== '''ExportTables''' supplements tables with the option to save them with one click i...") |
m (Tag: 2017 source edit) |
Contents
ExportTables allows exporting tables and grids on wiki pages to Excel formats.
Contents
How to export a table[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]
ExportTables supplements tables with the option to save them with one click into other formats, eg. MS Excel, to export.
While editing a page in VisualEditor, click on the table and select Properties. In the dialog that is opened, activtate the option Exportable.
In Wikitext[edit | edit source]
A table can be set to be exportable in 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 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 allow exporting of data. Exporting such data is done over the "Export table" menu in right top corner of the managers like the Namespace manager.
Related info
__HIDETITLE__ <bs:bookshelf src="Book:User manual" /> __TOC__ ==What is ExportTables?== '''ExportTables''' supplements tables with the option to save them with one click into other formats, eg. MS Excel, to export.{{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 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=== A table can be set to be exportable in 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 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 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]]
(29 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, 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 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=== | ||
+ | A table can be set to be exportable in 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 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 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]] |