View ProjeQtOr On
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Requirements import from excel with images - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !


Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)


Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)


Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)




Requirements import from excel with images

05 Mai 2022 16:56 - 06 Mai 2022 11:24 #1 by LaurentC
Usually requirements are given by customers in excel or reqif format.Reqif (*.reqifz files) can be converted (with all cell images) to excel by the excellent library (for python language).Therefore, the question is: how to import a large excel file with a large number of images encapsulated in cells and potentially several images per cell ?Unfortunately Projeqtor does not import images from excel.In case of a small number of images, it can be done manualy. In case of hundreds of images ensapsulated in thousands of lines, it becomes tricky....The attached file is a answer to that concern.It's written in python 3. So you need python 3.x to execute it or convert it to an exe file (the produced exe file is to big to be uploaded to this forum). Also, you need a direct access to the server file system (could be obsolete in the future, for further development).Just fill in the config.ini and execute the script in a command window or in a python environnement like pyscripter or pycharm.Tested on large XLSX files with dozens of images.Could be translated in php. For further study.Feedback is welcomed in case anybody may use it.
Last edit: 06 Mai 2022 11:24 by LaurentC. Reason: Attachment version updated

Please Connexion or Create an account to join the conversation.

06 Mai 2022 11:18 #2 by babynus
Thanks for your contribution.
If you agree, we'll share it on the download page.

We won't include it in Community version as we want to include only full PHP features.

Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

06 Mai 2022 11:31 #3 by LaurentC
Yes, you can share the source file (*.py) and the windows exe file
I've the compiled exe file here:

Feel free to download it.
The following user(s) said Thank You: babynus

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.034 seconds

Paramétrages de cookies


Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.


Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.