semvec/pypi-packages huggingface dataset:
dj-easy-xls 0.2.3
Easy package with helpful method to use openpyxl
Requires Python: >=3.6

# Dj easy xls

Helpful class and methods to import and export xls with django framework.

## Usage

### Import from xls

We call method get_sheet_rows which converts the table into dict with column as keys.

``` py
excel = OpenpyxlImport(file)
rows = excel.get_sheet_rows()
if excel.tally_header(rows[0], self.fields):
    for row in rows[1:]:
        params = excel.row_to_dict(row)
        print(params)
```

### Export from xls

Simple example to export django model queryset into csv file.

```py
file_name = self.file_name + ' ' + datetime.datetime.today().strftime('%Y-%m-%d') or 'Untitled'
export = OpenpyxlExport(file_name)
export.generate(self.fields, True)
for object in self.queryset:
    values = [change_format(object, val) for val in self.fields]
    export.generate(values)
export.set_width() # sets proper width of each columns
```

#### Return xlsx file as a response

Once we generate the xls in an export instance we can return response as

```py
return export.response()
```

#### Return xlsx file as a response

Saving xlsx in a directory path.

```py
return export.wb.save("<path>/test.xlsx")
```

### Saving response from django as a file with axios
Django http response can be saved as a file from an axios request
```es6
const url = '/download'
const config = {
  baseURL: process.env.BaseURL,
  responseType: "blob", // Very important!
};
try {
  const response = await axios.get(url, config);
  const url = window.URL.createObjectURL(new Blob([response.data]));
  const link = document.createElement("a");
  link.href = url;
  link.setAttribute("download", "file.xlsx"); //or any other extension
  document.body.appendChild(link);
  link.click();
} catch (error) {
  console.log(error);
}
```


### Install from Pypi test
``` bash
pip install -i https://test.pypi.org/simple/ dj-easy-xls
```
collibra-catalog 1.0.0
Collibra Catalog API
Keywords: OpenAPI,OpenAPI-Generator,Collibra Catalog API

The Catalog API offers functionality related to the catalog product.&lt;br/&gt;It is mainly focused on facilitating the ingestion of information into Catalog. The API enables users to more easily connect Catalog to sources that are not necessarily natively supported in the product.  # noqa: E501
collibra-classification 1.0.0
Collibra Catalog API
Keywords: OpenAPI,OpenAPI-Generator,Collibra Catalog API

The Catalog API offers functionality related to the catalog product.&lt;br/&gt;It is mainly focused on facilitating the ingestion of information into Catalog. The API enables users to more easily connect Catalog to sources that are not necessarily natively supported in the product.  # noqa: E501
file-merger 0.1.0rc2
Merge multiple text files into one
Requires Python: >=3.6,<4.0

# File merger

Merge multiple files into one. Support inserting code as markdown code blocks.

*Configuration file*

| Key            | Description                                                                               | Default value |
|:---------------|:------------------------------------------------------------------------------------------|:--------------|
| files          | array with input files names <sup>1</sup>                                                 | -             |
| folder         | sub-folder, where files located                                                           | -             |
| output         | output file name with optional path, relative to config location                          | -             |
| extension      | extension for all input and output files <sup>2</sup>                                     | -             |
| add_file_names | add file name before its text, or not                                                     | `false`       |
| file_label     | what write before file name                                                               | `File: `      |
| remove_folder  | extract from 'folder/file.txt' only 'file.txt', for use in file name <sup>3</sup>         | `false`       |
| code_in_md     | write code in markdown file between back-tics \`\`\` with file extension for highlighting | `false`       |
| ask_overwrite  | ask for overwrite or not                                                                  | `false`       |
| empty          | generate empty file by path <sup>4</sup>                                                  | `false`       |
| use            | use this config file or not                                                               | `true`        |

<sup>1</sup> All the contents of the files are combined in the order of the files. In this list you can use key `text` instead of file name for inserting any text between file's content:

```yaml
files:
  - text: 'some text'
```

<sup>2</sup> If specified, you should write the names of all files without extensions.

<sup>3</sup> Used with the `add_file_names` flag enabled.

<sup>4</sup> If specified, no other parameters are needed:

```yaml
empty: path/to/result/file
```

## Running

```bash
python path/to/file_merger.py -f FOLDER -c CONFIG_NAME
```

`-f` - Absolute path to folder with project, default is from where script run.

`-c` - Config file name, default is `file-merger.yaml` (e.g. `folder/config.yaml`).