• Coding

    How Python helps outside of work: ods data to excel

    I hate copying and pasting, so might as well automate it 9:43:24 PM Trying to complete my research paper.. … The script below helped me with some research data for my Research Module (wish me good luck!) If you have any question, do ask in the comment section. See you! This allows for transforming my .ods file to .xlsx //Note --> You will have to tweak this to your needs. This is a personalised solution [sourcecode lang=”python”] #USAGE python getdata.py from pyexcel_ods import get_data import os , re, json, openpyxl, logging, typing, sys logging.basicConfig(level=logging.DEBUG, format="%(asctime)s – %(levelname)s – %(message)s") def get_rows_xy(sheet: typing.List ): ”’ argument: sheet : a multidimensional list…

  • Lexpression Web Application
    Coding

    Lexpression Web application | Day (can’t remember) : Deployment

    Lexpression Web App  simplifying language learning… 11:17:20 AM finally can sleep Apologies for not documenting the development process daily, however, if you follow my Youtube channel, you should have seen the coding videos. So yea, the website /web application is deployed and it looks good, like functionally good.Not sure about the basic design. The web app is created using React, pure JS, PHP and MYSQL. PHP and MYSQL were quite problematic for me, especially using classes, traits and encapsulating data that should not accessible to the world. But I did it. The code could be improved, actually, will be improved but later. My main goal is to automate thee database…

error: Content is protected !!