Python Forum
Opening txt file created in python in excel
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Opening txt file created in python in excel
#1
Hello,

I wanted to see if someone can help me address my problem. I created a txt file in python by running the following code____python Guilds_v1.1.py -otu /Users/fabipc/Desktop/FunGuild/otu_table.csv -db fungi -m -u ___

The code worked properly and in return, I received 3 outputs in .txt format. I have worked with txt formats before and I am aware of how to open them in excel, but when I open these files, all the data is placed in one row.

If you could please let me know how to fix this and or how I can convert this txt files to open properly as an excel sheet that would be great.
Reply
#2
We'd need to see some actual code, preferably the smallest bit that would recreate the problem.
Craig "Ichabod" O'Brien - xenomind.com
I wish you happiness.
Recommended Tutorials: BBCode, functions, classes, text adventures
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  File is not being created with 'w' argument CAD79 3 484 Mar-14-2024, 12:05 PM
Last Post: snippsat
  Python openyxl not updating Excel file MrBean12 1 393 Mar-03-2024, 12:16 AM
Last Post: MrBean12
  Copy Paste excel files based on the first letters of the file name Viento 2 493 Feb-07-2024, 12:24 PM
Last Post: Viento
  Search Excel File with a list of values huzzug 4 1,312 Nov-03-2023, 05:35 PM
Last Post: huzzug
  Updating sharepoint excel file odd results cubangt 1 913 Nov-03-2023, 05:13 PM
Last Post: noisefloor
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,154 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Save and Close Excel File avd88 0 3,166 Feb-20-2023, 07:19 PM
Last Post: avd88
  Trying to access excel file on our sharepoint server but getting errors cubangt 0 848 Feb-16-2023, 08:11 PM
Last Post: cubangt
  Import XML file directly into Excel spreadsheet demdej 0 887 Jan-24-2023, 02:48 PM
Last Post: demdej
  how to read txt file, and write into excel with multiply sheet jacklee26 14 10,362 Jan-21-2023, 06:57 AM
Last Post: jacklee26

Forum Jump:

User Panel Messages

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