j V S SK rS SKJr S SKJrJrJr S SKJ r S SK
J r S r S r
S rg) N)load)TableTableRow TableCell)P)Pathc SnU R R SS5 nU( dF U R R S5 S:X a' [ U R R S5 5 nSnOU R R S5 S:X ak S nU R [ 5 nU HL nUR
R S
S :X a M" XWR R 5 R 5 -
nMN SnU( d U( a U( d SnS n/ nU( d, [ [ U5 5 H n UR W5 M U[ U5 4$ )
NT)z/urn:oasis:names:tc:opendocument:xmlns:table:1.0znumber-columns-repeated1)0urn:oasis:names:tc:opendocument:xmlns:office:1.0z
value-typefloat)r valueFstring
annotationr )
attributesgetr getElementsByTyper
parentNodeqname
firstChild__str__striprangeintappend)
cellisStrisLastnoValue repetitions
cell_valuetexts_ptext_pretListis
L/var/www/oekobilanz-rechner-gitlab-dev2026v8/cgi-bin/../pyscripts/readODS.pyget_cell_valuer( s G//%%&tvyzK T__(()klpww4??../lmn
_ `dl l
((+ F &&q)\9 ++335;;= =J WV
G s;'(A NN: & ) S% && c
z [ U 5 nUR [ 5 n0 nU GHT n UR [ 5 nU( d M# / nUS nUR [ 5 n[ U5 Hi u pU [
U5 S-
:X a [ U
SS5 u pO[ U
SS5 u p[
U 5 S: d MG Xk V
s/ s H oR 5 PM sn
-
nMk U( d M / nUSS GH nUR [ 5 nU( d M" / n[ US SS5 u nn [
U5 S:X a MH UU-
n[ S[
U5 5 HX nU[
U5 S-
: a [ UU SS5 u nn UU-
nM/ U[
U5 : d M@ [ UU SS5 u nn UU-
nMZ [
U5 [
U5 -
nUS: a$ [ U5 H nUR S5 M O US: a US U nUR U5 GM U( af S[ 4/USS Vs/ s H nUS4PM sn- n [ R " U Vs/ s H n[ U5 PM snUS9X4R S5 ' GMT GMW U$ s sn
f s snf s snf ! [ ad n[# S UR S5 S
35 [# S U 35 [# S U( a US S
OS 35 [# S[% U5 S35 e S nAff = f! [ a0 n[# SUR S5 S[% U5 S35 e S nAff = f)Nr r TF Parameterf8)dtypenamez.Debug - Failed to create array for sheet z:
zdtype: z
data sample: emptyzerror: z
z$Debug - Error processing sheet z: )r r r r r enumeratelenr( r r r objectnparraytuple getAttribute Exceptionprintstr) file_pathdocsheets sheet_arrayssheetrows column_names
header_row header_cellsidxr cellValuenrCellsval
sheet_datarowcellsrow_data parameterr& cell_data fullRowDiffcolr- xes r' readODSrR sI
y/C
"
"5
)FL: **84D L aJ%77 BL &| 4 #l+a//)7dD)I&Iw)7dE)J&Iy>A% I$FISYY[I$FFL
5 JABx--i8 %3E!HeU%K" 7y>Q& I% q#e*-A3u:>)-;E!HeU-S* 7 I-SZ -;E!HeT-R* 7 I-
. ", /#h- ? ? "; / * 0 1_ ' 5H!!(+- . &v./,WXWYJZ2[JZ3C;JZ2[[?Axx[eHf[eVWq[eHfns?tL!3!3F!;< Y x Y %G> 3\Hf J5K]K]^dKeJffijkGE7+,MJ*Ra.G)TUVGCF8623 89K9KF9S8TTVWZ[\W]V^^de f s L A*L 6L :J
L %B%L BL "J0L 6J
J
J
L
J
K=A K88K==L
L:
+L55L:c [ U 5 n[ U 5 R S5 n[ S[ U5 - 5 [
R " U40 UD6 g )Nz.npzzsaving data to )rR r with_suffixr9 r: r4 savez)filepathdict savefilepaths r' saveODSdataToNPZrY d sD 8 D>--f5L
c, /
/0HH\"T"r) )numpyr4 odf.opendocumentr odf.tabler r r odf.textr pathlibr r( rR rY r) r' r` s( ! 0 0 '2BH#r)