0

Hi, is there a simple way to convert the xls file to txt file to fit my program's code.

import matplotlib.pyplot as plt

x = []
y = []
t = []

fig = plt.figure()
rect = fig.patch
rect.set_facecolor('#31312e')

**readFile = open('data.xls', 'r')
sepFile = readFile.read().split('\n')
readFile.close()**

for idx, plotPair in enumerate(sepFile):
    if plotPair in '. ':
       # skip. or space
       continue
    if idx > 1:  # to skip the first line
        xAndY = plotPair.split(',')
        time_string = xAndY[0]
        t.append(time_string)
        y.append(float(xAndY[1]))

ax1 = fig.add_subplot(1, 1, 1, axisbg='blue')
ax1.plot(t, y, 'c', linewidth=3.3)

plt.title('IRRADIANCE')
plt.xlabel('TIME')

plt.show()
2
Contributors
1
Reply
43
Views
3 Years
Discussion Span
Last Post by Gribouillis
0

There are python modules to read xls files (such as xlrd). However in your case, it may be easier to convert the file to csv on the command line: if you have Libreoffice installed on your computer, you can use

soffice --headless --convert-to csv data.xls

in a terminal to convert data.xls into data.csv. (In windows, the options with -- may take a single dash -). Make sure there is no data.csv before running the command!

The conversion command line above can also be called from python if you want.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.