Python Forum
Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: How to copy a .csv worksheet into a .xlsx file without the number values turning into
Post: RE: How to copy a .csv worksheet into a .xlsx file...

Update: I figured it out import sys import openpyxl import csv import glob from openpyxl.utils import get_column_letter def write_to_target(target, directory, sheet_name): book = openpyxl.load_w...
YoshikageKira Data Science 7 793 Mar-28-2020, 09:38 AM
    Thread: How to copy a .csv worksheet into a .xlsx file without the number values turning into
Post: RE: How to copy a .csv worksheet into a .xlsx file...

(Mar-28-2020, 06:51 AM)buran Wrote: When reading from csv you will get str, unless you do conversion. You don't show how you read the file, but you can do the conversion either when reading or when ...
YoshikageKira Data Science 7 793 Mar-28-2020, 07:10 AM
    Thread: How to copy a .csv worksheet into a .xlsx file without the number values turning into
Post: RE: How to copy a .csv worksheet into a .xlsx file...

(Mar-28-2020, 05:44 AM)deanhystad Wrote: There must be something in your csv file that is confusing the reader. Do you have multi-row column headers in the csv file? Do you have ragged columns (no...
YoshikageKira Data Science 7 793 Mar-28-2020, 05:57 AM
    Thread: How to copy a .csv worksheet into a .xlsx file without the number values turning into
Post: How to copy a .csv worksheet into a .xlsx file wit...

Hello there! I'm having a problem with copying a .csv file into a .xlsx file. It does work because the information is there but the numbers do not register as numbers but as text values which causes ...
YoshikageKira Data Science 7 793 Mar-28-2020, 04:30 AM
    Thread: Pyqt5: How do you make a button that adds new row with data to a Qtablewidget
Post: RE: Pyqt5: How do you make a button that adds new ...

(Dec-31-2019, 10:19 PM)Denni Wrote: Okay first you are approaching this in the wrong manner... the data in a QTreeView or QTreeWidget should be stored within your code within a List or Dictionary an...
YoshikageKira GUI 6 1,890 Jan-01-2020, 12:39 AM
    Thread: Pyqt5: How do you make a button that adds new row with data to a Qtablewidget
Post: RE: Pyqt5: How do you make a button that adds new ...

(Dec-31-2019, 09:27 AM)Axel_Erfurt Wrote: It depends on how many columns a row has and in which column it should be inserted. Each column has 3 rows and every column will be filled in each row.
YoshikageKira GUI 6 1,890 Dec-31-2019, 08:23 PM
    Thread: Pyqt5: How do you make a button that adds new row with data to a Qtablewidget
Post: Pyqt5: How do you make a button that adds new row ...

My goal is to create a view only table that allows you to add data to table that is then displayed. Im having trouble with making a script that will actually add a new row to the current amount of r...
YoshikageKira GUI 6 1,890 Dec-31-2019, 08:52 AM
    Thread: MYSQL how to assign a table for each user in my username table database?
Post: MYSQL how to assign a table for each user in my us...

So I have a mysql database with a table that stores each individual's username and password and ID. How do I assign a new table for each individual user when a signal is called (EX: when the user crea...
YoshikageKira General Coding Help 1 999 Dec-25-2019, 10:58 PM
    Thread: PyQt5 How do you make a functioning login and registration program?
Post: RE: PyQt5 How do you make a functioning login and ...

(Dec-25-2019, 09:58 AM)Axel_Erfurt Wrote: I don't really know what your question is. You seem to be using QtDesigner, it is usually a problem to change such files afterwards. This is how it could lo...
YoshikageKira GUI 4 2,760 Dec-25-2019, 10:47 PM
    Thread: PyQt5 How do you make a functioning login and registration program?
Post: PyQt5 How do you make a functioning login and regi...

Hello! I am trying to make a User login and register program involving an sqlite3 database, but Im having trouble where to began nor what to do. Heres a snippet of my code for my registration form. c...
YoshikageKira GUI 4 2,760 Dec-25-2019, 03:20 AM
    Thread: PyQt5: How do you set the user input of a line edit to a specific variable?
Post: RE: PyQt5: How do you set the user input of a line...

(Dec-23-2019, 10:33 PM)Denni Wrote: buran Wrote:do you want me to revert your edits to your original post? currently your post in question is edited 4 times.Yep @buran I made that 2nd change and the...
YoshikageKira GUI 17 3,362 Dec-24-2019, 08:10 AM
    Thread: PyQt5: How do you set the user input of a line edit to a specific variable?
Post: RE: PyQt5: How do you set the user input of a line...

(Dec-23-2019, 10:33 PM)Denni Wrote: buran Wrote:do you want me to revert your edits to your original post? currently your post in question is edited 4 times.Yep @buran I made that 2nd change and the...
YoshikageKira GUI 17 3,362 Dec-23-2019, 10:45 PM
    Thread: PyQt5: How do you set the user input of a line edit to a specific variable?
Post: RE: PyQt5: How do you set the user input of a line...

(Dec-23-2019, 04:07 PM)Denni Wrote: While @Axel_Erfurt nicely provided a way to do it sadly it is fraught with numerous issues. Now while none of these issues would cause the program not to run, the...
YoshikageKira GUI 17 3,362 Dec-23-2019, 09:43 PM
    Thread: PyQt5: How do you set the user input of a line edit to a specific variable?
Post: PyQt5: How do you set the user input of a line edi...

Hello! I made a program using PyQt5. The main problem however is trying to get the program to read a user input in the Qlineedit widget my goal is to transfer the user input of the Qlinedit to a var...
YoshikageKira GUI 17 3,362 Dec-23-2019, 08:09 AM

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020