Search Results
|
Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
|
|
Thread: How to access all xlsx files in all subdirectories?
Post: How to access all xlsx files in all subdirectories...
Hello,
How to modify this program if I have more dirs in dir1 to get all xlsx.?
So the xls files are within different dirs in dir1, like
dir1\1990\1.xlsx
dir1\1991\123.xlsx
dir1\1992\124.xlsx
im... |
|
Krszt |
General Coding Help |
2 |
5,417 |
Mar-19-2019, 07:10 AM |
|
|
Thread: deactivate compatibility pop up with excel files
Post: deactivate compatibility pop up with excel files
Hello,
I have a program, that save all xlsx files in xls format. But there is always a pop up that checks the compatibility. How can I skip this pop up with python? I tried to extract it with wb.Disp... |
|
Krszt |
General Coding Help |
0 |
1,910 |
Mar-19-2019, 06:39 AM |
|
|
Thread: how to convert xlsx to xls
Post: RE: how to convert xlsx to xls
Yes, but I have more than 100 xlsx so it would keep more times. I thought it would be possible to have a new program that save all xlsx to xls. |
|
Krszt |
General Coding Help |
3 |
14,304 |
Mar-13-2019, 01:05 PM |
|
|
Thread: how to convert xlsx to xls
Post: how to convert xlsx to xls
I have a bunch of .xlsx files that I want to convert to xls, because my code works only with .xls
Could you suggest something for me? |
|
Krszt |
General Coding Help |
3 |
14,304 |
Mar-13-2019, 12:54 PM |
|
|
Thread: working with more excel files
Post: working with more excel files
Hello,
I would like to modify my existing code that extracts the value of some cells. How can I modify it to do it not only one but for more xls, that are in the same directory.
I tried something lik... |
|
Krszt |
General Coding Help |
1 |
2,448 |
Mar-13-2019, 09:46 AM |
|
|
Thread: How to obtain the background color of a cell using xlrd?
Post: How to obtain the background color of a cell using...
Hi all,
I wat to get the background color of a given cell with python from an xlsx. Iam new with it, could you please help me to finish this :
import xlrd
workbook = xlrd.open_workbook('67.xlsx')
wo... |
|
Krszt |
General Coding Help |
1 |
12,475 |
Mar-12-2019, 01:13 PM |
|
|
Thread: create three digit numbers
Post: create three digit numbers
Hello!
I would like to get all the 3 digit numbers where, the digit on the right side is equal or bigger than the previos one (on its left). Like: 112, 122,123 are okay but 132 is not good.
Could yo... |
|
Krszt |
Homework |
4 |
4,442 |
Dec-09-2018, 12:07 PM |
|
|
Thread: create three digit numbers
Post: create 3 digit numbers
Hello!
I would like to get all the 3 digit numbers where, the digit on the right side is equal or bigger than the previos one (on its left). Like: 112, 122,123 are okay but 132 is not good.
Could yo... |
|
Krszt |
Homework |
4 |
4,442 |
Dec-08-2018, 08:30 PM |
|
|
Thread: How to extend the sclale of a graph?
Post: How to extend the sclale of a graph?
Hello,
I would like to create a ,,nicer" graph with matplot lib. How can I define, that on the generated x axis, the scale would be larger and also the text would be more frequent.
Here is the code:... |
|
Krszt |
General Coding Help |
1 |
2,315 |
Nov-13-2018, 07:54 AM |
|
|
Thread: How to put together datas into a file?
Post: How to put together datas into a file?
Hello,
I would like to collect different type of datas into a file. Here is a part of the code.
val = str(float(data[-1]))
val_dB = float(val)
val_dB = math.log(val_dB, 10) * 10
myfile = open('../..... |
|
Krszt |
General Coding Help |
1 |
1,912 |
Nov-07-2018, 08:52 AM |
|
|
Thread: Extend the scale
Post: Extend the scale
Hello,
I am using matplotlib to make a scatter-plot, here is the code:
if os.path.isfile("example.txt"):
days_KECS, intensity_KECS = np.loadtxt("example.txt", unpack=True,
... |
|
Krszt |
General Coding Help |
1 |
2,687 |
Nov-05-2018, 12:58 PM |
|
|
Thread: Plotting datas
Post: Plotting datas
Hello,
I am completely new with matplotlib. I would like to create a graph (with points), where every data on x axis is a date and y is a float number.
The datas are coming from a file, looks like (... |
|
Krszt |
General Coding Help |
2 |
2,373 |
Oct-31-2018, 09:06 AM |
|
|
Thread: How to put together datas from different files
Post: RE: How to put together datas from different files
I have one more question. How can I skip to get an ,,ValueError: could not convert string to float:" if there is no data in the text file? |
|
Krszt |
General Coding Help |
3 |
2,369 |
Oct-31-2018, 07:37 AM |
|
|
Thread: How to put together datas from different files
Post: How to put together datas from different files
Hello,
I am dealing with a program, which puts together some datas from different files. I wrote a part of the code it looks like:
for path, subdirs, files in os.walk(r'./'):
for filename in f... |
|
Krszt |
General Coding Help |
3 |
2,369 |
Oct-29-2018, 11:46 AM |
|
|
Thread: How to write datas into a file?
Post: RE: How to write datas into a file?
(Oct-25-2018, 01:18 PM)buran Wrote: you open and close the test.txt every time you write in it. However the mode is 'w'. i.e. if the file exists it is replaced by new file. that is why you get just ... |
|
Krszt |
General Coding Help |
2 |
2,384 |
Oct-25-2018, 01:45 PM |
|
|
Thread: How to write datas into a file?
Post: [split] How to make an activation flag?
I have program, which looks for every files starting with mli_value_IHAR_. I want these files' special date ID into a file (every date into a new line). Here is the code that I wrote. My problem is t... |
|
Krszt |
General Coding Help |
2 |
2,384 |
Oct-25-2018, 12:36 PM |
|
|
Thread: How to make an activation flag?
Post: RE: How to make an activation flag?
(Oct-11-2018, 01:19 PM)Krszt Wrote: Hello, I have a program, which runs well. It looks like os.chdir('zips') a = open("ziplist.txt", "w") for path, subdirs, files in os.walk(r'./'): for filename in ... |
|
Krszt |
General Coding Help |
4 |
3,277 |
Oct-11-2018, 01:49 PM |
|
|
Thread: How to make an activation flag?
Post: How to make an activation flag?
Hello,
I have a program, which runs well.
It looks like
os.chdir('zips')
a = open("ziplist.txt", "w")
for path, subdirs, files in os.walk(r'./'):
for filename in files:
if filename.endsw... |
|
Krszt |
General Coding Help |
4 |
3,277 |
Oct-11-2018, 01:19 PM |
|
|
Thread: using a shell script within python
Post: using a shell script within python
I want to use a C-shell script within a python program, which works with two arguments.
os.system("recall 20170121 ../E725.txt xy 1")
But I want to use it for a stack, so declared the variables like... |
|
Krszt |
General Coding Help |
2 |
3,159 |
Oct-10-2018, 09:26 AM |