isogeotoxlsx.isogeo2xlsx module¶
Get metadatas from Isogeo and store it into a Excel worksheet.
-
class
isogeotoxlsx.isogeo2xlsx.
Isogeo2xlsx
(lang='FR', url_base_edit='', url_base_view='', **kwargs)¶ Bases:
openpyxl.workbook.workbook.Workbook
Used to store Isogeo API results into an Excel worksheet (.xlsx)
Parameters: - lang (str) – selected language for output
- url_base_edit (str) – base url to format edit links (basically app.isogeo.com)
- url_base_view (str) – base url to format view links (basically open.isogeo.com)
-
column_width
(ws, columns)¶ Set the width of the columns of the passed worksheet.
Parameters: - ws (Worksheet) – worksheet into write headers
- columns (ColumnPattern) – column table
-
headers_writer
(ws, columns)¶ Writes the headers from a columns ref table to a worksheet.
Parameters: - ws (Worksheet) – worksheet into write headers
- columns (ColumnPattern) – column table
-
launch_analisis
()¶ Launches special analisis, using the stats submodule.
-
row_height
(ws, from_row=2, height=35)¶ Set the height of the rows of the passed worksheet.
Parameters: - ws (Worksheet) – worksheet into write headers
- from_row (int) – row to start from. Default to ‘2’ = ignoring headers.
- height (int) – fixed height to apply. Default to 35.
-
set_worksheets
(auto=None, vector=1, raster=1, service=1, resource=1, dashboard=0, attributes=0, fillfull=0, inspire=0)¶ Adds new sheets depending on present metadata types in isogeo API search tags.
Parameters: - auto (list) – typically auto=search_results.get(‘tags’).keys()
- vector (bool) – add vector sheet
- raster (bool) – add raster sheet
- service (bool) – add service sheet
- resource (bool) – add resource sheet
- dashboard (bool) – add dashboard sheet
- attributes (bool) – add attributes sheet - only if vector is True too
- fillfull (bool) – add fillfull sheet
- inspire (bool) – add inspire sheet
-
store_md_generic
(md, ws, idx)¶ Exports generic metadata attributes into Excel worksheet with some dynamic adaptations based on metadata type.
Parameters: - md (Metadata) – metadata object to export
- ws (Worksheet) – Excel worksheet to store the exported info
- idx (int) – row index in the worksheet
-
store_metadatas
(metadata, share=None)¶ Write metadata into the worksheet.
Parameters: - metadata (Metadata) – metadata object to write
- share (Share) – share to use to build the OpenCatalog URL
-
styling_cells
(ws, columns)¶ Applies the referenced style to the cells of a column.
Parameters: - ws (Worksheet) – worksheet into write headers
- columns (ColumnPattern) – column table
-
tunning_worksheets
(excluded_sheets=('dashboard', ))¶ Applies some adjustments to the sheets of the workbook: filters, frozen panels, print settings, etc.
Parameters: excluded_sheets (tuple) – sheets name to be excluded from the tunning.