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.