Python Forum
Transposing in Excel and converting to txt
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Transposing in Excel and converting to txt
#1
Hello;
I am a new user. I would like to automate a process that will save me a lot of time. In attached excel file I have some calculations of stresses for different parts. I want to take the data of "Part ID" and "Mean Stresses" and of a string format, which is on right side of excel file, that is compatible with the software I use. The red color and blue color represent the location of the data in string. The rest of the data should not be changed (Each sheet has different data). Finally, all the output should be dumped into a txt file( An Example for the first two data set is attached).

Any kind of help is appreciated. Thank you.

Muhsin

Attached Files

.xlsx   mean stress.xlsx (Size: 18.21 KB / Downloads: 470)
.txt   final output.txt (Size: 1.25 KB / Downloads: 503)
Reply


Messages In This Thread
Transposing in Excel and converting to txt - by muhsin - Dec-10-2017, 07:52 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Transposing a dataframe without creating NaN values doug2019 2 932 Mar-18-2023, 03:14 PM
Last Post: jefsummers
  Converting cells in excel to JSON format desmondtay 4 1,680 May-23-2022, 10:31 AM
Last Post: Larz60+
  Converting a patterned string or text into excel table soup1987 1 2,093 Oct-03-2019, 01:37 AM
Last Post: Larz60+
  Transposing Table salihozturk 3 2,491 Mar-03-2019, 06:55 PM
Last Post: salihozturk
  Transposing a Matrix WITHOUT numpy TreasureDragon 5 11,105 Mar-02-2019, 10:48 PM
Last Post: ichabod801

Forum Jump:

User Panel Messages

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