Skip to content

vytautasmatukynas/Excel-Sheet-Generator-App-Python-PyQt-Pandas

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Excel Sheet Generator App

I created this app basically for generating sheets for pallet content info, that i won't have to write everything by hand from main excel.

This app generates excel file with separate sheets from main excel file. It searches for column "column_name" with numbers or names, sorts that column and splits it in several tables, then puts everything to new excel file and creates sheets.

Prepare:

Select file:

image

image

image

Type name of column you want to split and name of new file:

image

Generate:

Creates new excel file:

image

image

Result:

New file is saved in current file dir:

image

Table from main excel file are sorted and new file is created with sheets:

image

Screenshot 2023-10-30 143722

Screenshot 2023-10-30 143816

About

python, pyqt, pandas

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages