Reads Data from given Excel File and exports Single PDFs and a complete PDF grouped by Gateway

Stefan Knaak

Last update: Nov 13, 2021

Related tags

Office Files Processing E-Shelter_XLS2QR

Overview

E-Shelter Excel2QR

Reads Data from given Excel File and exports Single PDFs and a complete PDF grouped by Gateway

Features

Reads Excel 2021
Export Single Labels as PDF and SVG
Export PDF with all rows grouped by Gateway

Folder Structure

Data
\ xlsx - Insert Excel Files here
\ output - Storage Folder for the combined PDFs
\ output_pdf - Storage Folder for the PDFs grouped by Gateway
\ output_svg - Storage Folder for the SVGs grouped by Gateway

Informations

Workflow

put your Excel Assetlist into data/xlsx Folder
start

Windows executable

Download latest Release Version from https://github.com/corgan2222/E-Shelter_XLS2QR/releases/
Extract Zip File
Start exe

Source Installation Linux

git clone https://github.com/corgan2222/E-Shelter_XLS2QR.git
cd E-Shelter_XLS2QR
./install_linux.sh
python3 -m pip install -r requirements.txt

There are two running modes.

1. Folder Based

python3 xls2qr.py

just run the script with no parameter.
The script will look in the data/xlsx Folder for an Excel File

2. File based

You can define all files and Folder via command line parameter

python3 xls2qr.py -x [excelfile]

example Windows

python3 xls2qr.py -x "c:\tmp\file.xlsx"

example Linux

python3 xls2qr.py -i "/home/user/files/file.xlsx"

Command line Settings

Option	Description	Notes
-x	Excelfile	"/home/user/files/file.xlsx"
-o	Output Folder	"/home/user/files/data/output"
-l	Logfile	"/car/log/debug.log"
-v	verbose	show debug logs if set
-q	quit	no output

Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files

pyexcel - Let you focus on data, instead of file formats Support the project If your company has embedded pyexcel and its components into a revenue ge

1.1k Dec 29, 2022

A suite of utilities for converting to and working with CSV, the king of tabular file formats.

csvkit is a suite of command-line tools for converting to and working with CSV, the king of tabular file formats. It is inspired by pdftk, GDAL and th

5.2k Dec 31, 2022

ObjTables: Tools for creating and reusing high-quality spreadsheets

ObjTables: Tools for creating and reusing high-quality spreadsheets ObjTables is a toolkit which makes it easy to use spreadsheets (e.g., XLSX workboo

7 Jun 14, 2021

This is a c++ project deploying a deep scene text reading pipeline with tensorflow. It reads text from natural scene images. It uses frozen tensorflow graphs. The detector detect scene text locations. The recognizer reads word from each detected bounding box.

DeepSceneTextReader This is a c++ project deploying a deep scene text reading pipeline. It reads text from natural scene images. Prerequsites The proj

49 Sep 10, 2022

This is a GUI for scrapping PDFs with the help of optical character recognition making easier than ever to scrape PDFs.

pdf-scraper-with-ocr With this tool I am aiming to facilitate the work of those who need to scrape PDFs either by hand or using tools that doesn't imp

75 Oct 21, 2022

Python script that reads Aliexpress offers urls from a Excel filename (.csv) and post then in a Telegram channel using a bot

Aliexpress to telegram post Python script that reads Aliexpress offers urls from a Excel filename (.csv) and post then in a Telegram channel using a b

6 Dec 6, 2022

According to the received excel file (.xlsx,.xlsm,.xltx,.xltm), it converts to word format with a given table structure and formatting

2 Feb 18, 2022

WebScraping - Scrapes Job website for python developer jobs and exports the data to a csv file

WebScraping Web scraping Pyton program that scrapes Job website for python devel

2 Jul 22, 2022

A python library for extracting text from PDFs without losing the formatting of the PDF content.

Multilingual PDF to Text Install Package from Pypi Install it using pip. pip install multilingual-pdf2text The library uses Tesseract which can be ins

49 Nov 7, 2022

A bulk pdf generator. This application can generate PDFs in bulk by using just one click.

A bulk html pdf generator. This application can generate PDFs in bulk by using just one click. Screenshots Requirements 🧱 Your system must have the f

3 Apr 23, 2022

xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa. It works with Microsoft Excel on Windows and macOS. Sign up for the newsletter or follow us on twitter via

xlwings - Make Excel fly with Python! xlwings CE xlwings CE is a BSD-licensed Python library that makes it easy to call Python from Excel and vice ver

2.5k Jan 6, 2023

My sister is a GR of her class. She had to mark attendance of students from screenshots of teams meeting on an excel sheet. I resolved her problem by reading names from screenshots using PyTesseract and marking them present on the excel using Pandas in Python. It took me 1hr to write the code and it is saving half an hour everyday.

auto-team-attandance Don't judge the code, this is not the best way to write code. I was learning tkinter that is why GUI is bad. Here's the Mega link

25 Sep 4, 2022

PowerShell module to import/export Excel spreadsheets, without Excel

PowerShell + Excel = Better Together Automate Excel via PowerShell without having Excel installed. Runs on Windows, Linux and MAC. Creating Tables, Pi

2k Dec 30, 2022

Excel-report-evaluator - A simple Python GUI application to aid with bulk evaluation of Microsoft Excel reports.

Excel Report Evaluator Simple Python GUI with Tkinter for evaluating Microsoft Excel reports (.xlsx-Files). Usage Start main.py and choose one of the

1 Dec 29, 2021

Fetch data from an excel file and create HTML file

excel-to-html Problem Statement! - Fetch data from excel file and create html file Excel.xlsx file contain the information.in multiple rows that is ne

1 Oct 25, 2021

Google Project: Search and auto-complete sentences within given input text files, manipulating data with complex data-structures.

Auto-Complete Google Project In this project there is an implementation for one feature of Google's search engines - AutoComplete. Autocomplete, or wo

10 Jun 20, 2022

Reads Data from given Excel File and exports Single PDFs and a complete PDF grouped by Gateway

Related tags

Overview

E-Shelter Excel2QR

Features

Folder Structure

Informations

Workflow

Windows executable

Source Installation Linux

1. Folder Based

2. File based

Command line Settings

You might also like...

Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files

A suite of utilities for converting to and working with CSV, the king of tabular file formats.

ObjTables: Tools for creating and reusing high-quality spreadsheets

This is a c++ project deploying a deep scene text reading pipeline with tensorflow. It reads text from natural scene images. It uses frozen tensorflow graphs. The detector detect scene text locations. The recognizer reads word from each detected bounding box.

This is a GUI for scrapping PDFs with the help of optical character recognition making easier than ever to scrape PDFs.

Python script that reads Aliexpress offers urls from a Excel filename (.csv) and post then in a Telegram channel using a bot

According to the received excel file (.xlsx,.xlsm,.xltx,.xltm), it converts to word format with a given table structure and formatting

WebScraping - Scrapes Job website for python developer jobs and exports the data to a csv file

A python library for extracting text from PDFs without losing the formatting of the PDF content.

A bulk pdf generator. This application can generate PDFs in bulk by using just one click.

xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa. It works with Microsoft Excel on Windows and macOS. Sign up for the newsletter or follow us on twitter via

PowerShell module to import/export Excel spreadsheets, without Excel

Excel-report-evaluator - A simple Python GUI application to aid with bulk evaluation of Microsoft Excel reports.

Fetch data from an excel file and create HTML file

Google Project: Search and auto-complete sentences within given input text files, manipulating data with complex data-structures.

Exports saved posts and comments on Reddit to a csv file.

inklayers is a command line program that exports layers from an SVG file.

Transfers a image file(.png) to an Excel file(.xlsx)

Releases(1.0.1)

1.0.1(Nov 13, 2021)

Owner

Stefan Knaak

xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa. It works with Microsoft Excel on Windows and macOS. Sign up for the newsletter or follow us on twitter via

PowerShell module to import/export Excel spreadsheets, without Excel

Excel-report-evaluator - A simple Python GUI application to aid with bulk evaluation of Microsoft Excel reports.

Upload an Excel/CSV file ( < 200 MB) and produce a short summary of the data.

Transpiler for Excel formula like language to Python. Support script and module mode

A Python module for creating Excel XLSX files.

Library to create spreadsheet files compatible with MS Excel 97/2000/XP/2003 XLS files, on any platform.

A python tool for batch importing excel/csv files into mysql database.

ExcelPeek is a tool designed to help investigate potentially malicious Microsoft Excel files.

PyExcelerate - Accelerated Excel XLSX Writing Library for Python 2/3