test

Alejandro Acuña

2024-08-12 1876e65234c20209001178705cfa50d8f9ded67a

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
Êþº¾4à
¾
d    ½
e    ½
f
g
h

i

j    ½
kØ

l
m
n
o

d

p

q

r
9 
s
t

u
v
½
w

u
x
y
z
½
{
|

}
½
~
½
r

r


d
½
€



‚

ƒ
„

…
†

…
‡

ˆ
‰

ˆ
Š
½
‹

ˆ
Œ

ˆ


Ž


Ž

½
‘

…
’
“
”
•
–
•
—
˜
3
™

ˆ
š
3
›
3
œ
3

3
ž

…
Ÿ    ¿
 

Ž
¡

¢
£

Ž
¤

l
¥

Ž
¦

Ž
§

Ž
¨    
¢
©

Ž
ª

Ž
«

Ž
¬

Ž
­

Ž
®

Ž
¯

Ž
°

±

²

…
³

…
´
µ
¶

s
·
O
}

¸
¹
O
º

»
¼
O
½
Y
¾
Y
¿
À
Y
Á
Y
Â
Y
Ã

Ä
Å

Ä
Æ

Ä
Ç

Ä
È    
s
É
Ê b
Ë    
Ì
Í
Î
e
d
Ï
“
Ð
Ñ
Ò
Ó
Ô
Õ
Ö
×
o
Ø
Ù
q
Ú
Û
Ü
q
Ý
Þ
ß
à
á
â
ã

ä
å
æ
{
d
ç {
è
é

ê    {
ë
ì
í
ƒ
î
ï
ðy
ñ
ò
ó
ô
õ
ö
÷

øˆ
ù
q
ú
û

s
ü
ý

ƒ

s
þ

ÿ
 
˜
d
š
 
 

…
š 

ˆ
    

ˆ 
š
š    
¢
š    
¢    
¢
 
˜    
¢
š    
¢    
¢
š
š
r
²
}

l    ½
 !
"#$
"%&
 '()*
InnerClasses
workbook
,Lorg/apache/poi/xssf/usermodel/XSSFWorkbook;
language
Ljava/lang/String;
chars
[C
rxquote
Ljava/util/regex/Pattern;
<init>
()V
Code
LineNumberTable
LocalVariableTable
this
$Lart/servers/rtzserver/reports/XLSX;
(Ljava/io/File;)V
source
Ljava/io/File;

Exceptions
save
(Ljava/lang/String;)[B
bos
Ljava/io/ByteArrayOutputStream;
xlsx
[B

e
Ljava/lang/Exception;
format
 StackMapTable
y+
saveAndClose
result
close

columnName
(I)Ljava/lang/String;
index

I
quotient
 createRow
.(Lorg/apache/poi/xssf/usermodel/XSSFSheet;II)V
hoja
)Lorg/apache/poi/xssf/usermodel/XSSFSheet;
numeroFilaReferencia

numeroFila
xssfrowReferencia
'Lorg/apache/poi/xssf/usermodel/XSSFRow;
xssfrow
/(Lorg/apache/poi/xssf/usermodel/XSSFSheet;III)V
sheet
numeroColumnas
0(Lorg/apache/poi/xssf/usermodel/XSSFSheet;IIIZ)V
celda
(Lorg/apache/poi/xssf/usermodel/XSSFCell;

i
newCellRangeAddress
)Lorg/apache/poi/ss/util/CellRangeAddress;
cellRangeAddress
copycontent

Z
    sourceRow
destinationRow,-(.
˜
 copyValue
S(Lorg/apache/poi/xssf/usermodel/XSSFCell;Lorg/apache/poi/xssf/usermodel/XSSFCell;)V
destination
getCellValueAsText
<(Lorg/apache/poi/xssf/usermodel/XSSFCell;)Ljava/lang/String;
cell
getColumnWidth
.(Lorg/apache/poi/xssf/usermodel/XSSFSheet;II)I
col1
col2
getColumnWidthInPixels
.(Lorg/apache/poi/xssf/usermodel/XSSFSheet;II)F

F
getDate
(J)Ljava/lang/String;
  timestamp

J
ISO8601DATEFORMAT
Ljava/text/SimpleDateFormat;
getNumberOfDays
(JJ)I

timestamp1

timestamp2
    calendar1
Ljava/util/Calendar;
  calendar2
numberOfDays
À
   setBorder
~(Lorg/apache/poi/xssf/usermodel/XSSFSheet;Lorg/apache/poi/ss/util/CellRangeAddress;Lorg/apache/poi/ss/usermodel/BorderStyle;)V
    xssfsheet
borderStyle
)Lorg/apache/poi/ss/usermodel/BorderStyle;
toPDF
([B)[B
oooExeFolder

oooOptions
Ljava/util/List;
 oooServer
 Looo/connector/server/OOoServer;
 remoteContext
$Lcom/sun/star/uno/XComponentContext;
remoteServiceManager
*Lcom/sun/star/lang/XMultiComponentFactory;
desktop
Ljava/lang/Object;
xComponentLoader
%Lcom/sun/star/frame/XComponentLoader;
propertyValues
#[Lcom/sun/star/beans/PropertyValue;
document
   xStorable
Lcom/sun/star/frame/XStorable;
pdf
bootstrapSocketConnector
(Looo/connector/BootstrapSocketConnector;Ù
Ù/0
×12)
ã
5
o
ò
toSCV

c
cn
row
 firstCell

r
rn
fe
4Lorg/apache/poi/xssf/usermodel/XSSFFormulaEvaluator;
    formatter
+Lorg/apache/poi/ss/usermodel/DataFormatter;
out
Ljava/io/PrintStream;
bom34
encodeValue
&(Ljava/lang/String;)Ljava/lang/String;
value

needQuotes

m
Ljava/util/regex/Matcher;5
<clinit>

SourceFile
    XLSX.javaÉÊÃÄÅÆ
*org/apache/poi/xssf/usermodel/XSSFWorkbook
java/io/FileInputStreamÉÐÉ6ÁÂ/78
xlsm
java/io/ByteArrayOutputStream9:;<âÊ=>?@AÊ
%
&BÊ
java/lang/Exception
csv
H
&
 Unknow formatÉCÔÕ
java/lang/StringBuilderãäDEDFGH
.IJèJ,KLMNèôOPQP4RSTU

VW0XY-Z[\]
'org/apache/poi/ss/util/CellRangeAddress^_`_a_b_c_Édefghijkl_mHn[oCpqorstuvw[oxyz{|}H~CDD€


‚
java/text/SimpleDateFormat
yyyy-MM-dd HH:mm:ssƒ
[„…†‡ˆ‰Š‹ÜŒŽ
java/util/Calendar‘’“’”•–—˜™˜š˜›˜œ
1art/servers/rtzserver/configuration/ConfigurationžŸ ¡Ä
java/util/ArrayList
--nofirststartwizard“¢

--headless
--nologo
--nodefault
--norestore
--nocrashreport
 --nolockcheck
ooo/connector/server/OOoServerɣ
&ooo/connector/BootstrapSocketConnectorɤ
---accept=socket,host=localhost,port=8600;urp;
Cuno:socket,host=localhost,port=8600;urp;StarOffice.ComponentContext¥¦1§¨
com.sun.star.frame.Desktop2©ª
#com/sun/star/frame/XComponentLoader«¬­
 com/sun/star/beans/PropertyValue
Hidden®Ä
java/lang/BooleanÉx¯
1
InputStream
;com/sun/star/lib/uno/adapter/ByteArrayToXInputStreamAdapterÉ°
private:stream
_blank±²
com/sun/star/frame/XStorable
   Overwrite

FilterName
writer_pdf_Export
OutputStream
?com/sun/star/lib/uno/adapter/OutputStreamToXOutputStreamAdapterÉ:³´µÊ
XLSX¶·
Error generating pdf ƒ¸¹º»¼½
)org/apache/poi/ss/usermodel/DataFormatter
java/io/PrintStream
UTF-8ɾ¿_ÀÁÂ_ÃÄÅLÇÉÊQËÌÄÌCÍtÌxÎtÏt3ÐÑÒÓÔtÌrÕtÖtÃÊ
art/servers/ServerException
Error generating csvׁÇÈØÙÚ5Û[
""Ü
[

"ÝÞ
"art/servers/rtzserver/reports/XLSX
java/lang/Object
$art/servers/rtzserver/reports/XLSX$1
java/lang/Throwable
%org/apache/poi/xssf/usermodel/XSSFRow
java/util/Iterator
'org/apache/poi/xssf/usermodel/XSSFSheet
java/lang/String
java/util/List
"com/sun/star/uno/XComponentContext
(com/sun/star/lang/XMultiComponentFactory
2org/apache/poi/xssf/usermodel/XSSFFormulaEvaluator
&org/apache/poi/xssf/usermodel/XSSFCell
java/util/regex/Matcher
(Ljava/io/InputStream;)V
equalsIgnoreCase
(Ljava/lang/String;)Z
write
(Ljava/io/OutputStream;)V
toByteArray
()[B
art/servers/rtzserver/Shared
mutex
!Lart/library/utils/synchro/Mutex;
art/library/utils/synchro/Mutex
   lockWrite
releaseWrite
(Ljava/lang/String;)V
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;
(C)Ljava/lang/StringBuilder;
toString
()Ljava/lang/String;
getRow
*(I)Lorg/apache/poi/xssf/usermodel/XSSFRow;
  getHeight
()S
   setHeight
(S)V

createCell
+(I)Lorg/apache/poi/xssf/usermodel/XSSFCell;
getCell
getCellStyle
/()Lorg/apache/poi/xssf/usermodel/XSSFCellStyle;
setCellStyle
*(Lorg/apache/poi/ss/usermodel/CellStyle;)V
getMergedRegions
()Ljava/util/List;
iterator
()Ljava/util/Iterator;
hasNext
()Z
next
()Ljava/lang/Object;
getFirstRow
()I
 getRowNum

getLastRow
getFirstColumn
 getLastColumn
(IIII)V
addMergedRegion
,(Lorg/apache/poi/ss/util/CellRangeAddress;)I
/$SwitchMap$org$apache$poi$ss$usermodel$CellType
[I
getCellTypeEnum
(()Lorg/apache/poi/ss/usermodel/CellType;
$org/apache/poi/ss/usermodel/CellType
ordinal
getStringCellValue
isEmpty
setCellValue
getNumericCellValue
()D
(D)V
BLANK
&Lorg/apache/poi/ss/usermodel/CellType;
setCellType
)(Lorg/apache/poi/ss/usermodel/CellType;)V
getBooleanCellValue
(Z)V
getErrorCellValue
()B
setCellErrorValue
(B)V
getCellFormula
setCellFormula
(I)Ljava/lang/StringBuilder;
(Z)Ljava/lang/StringBuilder;
(I)I
(I)F

getMessage
java/util/TimeZone

getDefault
()Ljava/util/TimeZone;
setTimeZone
(Ljava/util/TimeZone;)V
java/lang/Long
valueOf
(J)Ljava/lang/Long;
&(Ljava/lang/Object;)Ljava/lang/String;
getInstance
()Ljava/util/Calendar;
setTimeInMillis
(J)V
set
(II)V
add
getTimeInMillis
()J
!org/apache/poi/ss/util/RegionUtil
setBorderTop
x(Lorg/apache/poi/ss/usermodel/BorderStyle;Lorg/apache/poi/ss/util/CellRangeAddress;Lorg/apache/poi/ss/usermodel/Sheet;)V
 setBorderLeft
setBorderBottom
setBorderRight
 configuration
)Lart/servers/configuration/Configuration;
detail
9Lart/servers/rtzserver/configuration/ConfigurationDetail;
7art/servers/rtzserver/configuration/ConfigurationDetail

binaryPath
(Ljava/lang/Object;)Z
%(Ljava/lang/String;Ljava/util/List;)V
#(Looo/connector/server/OOoServer;)V
connect
J(Ljava/lang/String;Ljava/lang/String;)Lcom/sun/star/uno/XComponentContext;
getServiceManager
,()Lcom/sun/star/lang/XMultiComponentFactory;
createInstanceWithContext
J(Ljava/lang/String;Lcom/sun/star/uno/XComponentContext;)Ljava/lang/Object;
com/sun/star/uno/UnoRuntime
queryInterface
7(Ljava/lang/Class;Ljava/lang/Object;)Ljava/lang/Object;
Name
Value
([B)V
loadComponentFromURL
h(Ljava/lang/String;Ljava/lang/String;I[Lcom/sun/star/beans/PropertyValue;)Lcom/sun/star/lang/XComponent;

storeToURL
8(Ljava/lang/String;[Lcom/sun/star/beans/PropertyValue;)V

disconnect

printstack
*(Ljava/lang/String;Ljava/lang/Exception;)V
8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
getCreationHelper
4()Lorg/apache/poi/xssf/usermodel/XSSFCreationHelper;
0org/apache/poi/xssf/usermodel/XSSFCreationHelper
createFormulaEvaluator
6()Lorg/apache/poi/xssf/usermodel/XSSFFormulaEvaluator;
,(Ljava/io/OutputStream;ZLjava/lang/String;)V
getNumberOfSheets

getSheetAt
,(I)Lorg/apache/poi/xssf/usermodel/XSSFSheet;
 getLastRowNum
println
(C)V
getLastCellNumß
1org/apache/poi/ss/usermodel/Row$MissingCellPolicy
MissingCellPolicy
RETURN_BLANK_AS_NULL
3Lorg/apache/poi/ss/usermodel/Row$MissingCellPolicy;
^(ILorg/apache/poi/ss/usermodel/Row$MissingCellPolicy;)Lorg/apache/poi/xssf/usermodel/XSSFCell;
print
BOOLEAN
ERROR
FORMULA
evaluateInCell
L(Lorg/apache/poi/ss/usermodel/Cell;)Lorg/apache/poi/xssf/usermodel/XSSFCell;
formatCellValue
6(Lorg/apache/poi/ss/usermodel/Cell;)Ljava/lang/String;
NUMERIC
STRING
_NONE
indexOf
java/util/regex/Pattern
matcher
3(Ljava/lang/CharSequence;)Ljava/util/regex/Matcher;
find

replaceAll
compile
-(Ljava/lang/String;)Ljava/util/regex/Pattern;
org/apache/poi/ss/usermodel/Row!½¾ÁÂÃÄÅÆ
ÇÈ
ÉÊ
ËÞ
¨*·
*
µ*¼YAUYBUYCUYDUYEUYFUYGUYHUYIUY  JUY
KUYLUYMUY NUYOUYPUYQUYRUYSUYTUYUUYVUYWUYXUYYUYZUµ±Ì-)  ~§.Í
¨ÎÏ
ÉÐËÿ»*·
*
µ*¼YAUYBUYCUYDUYEUYFUYGUYHUYIUY  JUY
KUYLUYMUY NUYOUYPUYQUYRUYSUYTUYUUYVUYWUYXUYYUYZUµ*»Y»Y+··µ±Ì1)   ~§2º3Í»ÎÏ»ÑÒ
Ó

ÔÕË
«¥+    ¶
š+¶
™»Y· M*´,¶,¶N,¶-°+¶
™@²¶»Y· M*´,¶,¶N,¶*-¶:²¶°M,¿:²¶¿+¶
™"»Y· M*´,¶,¶N,¶*-¶°»Y·¿<\e<\hejhÌf9;<"='>+?-B6D<GDHLIQJUK\QbKeLfNhQsU|W„XŒY‘Z•[›^Í\ Ö×'ØÙD!Ö×QØÙfÚÛ„Öב
ØÙ¥ÎÏ¥ÜÄ
ÝwÞBß
'Ó

àÕËR*+¶M*¶,°Ìfg
hÍ ÎÏÜÄ
áÙÓ

âÊ
ËW
*´¶§L±

Ìrv
twÍ
ÎÏÝJÞãä
Ë¡G„
ÿl=ž"»Y·*¶ ¶!*´p4¶"¶#°»Y·$¶!*´p4¶"¶#°Ì‚„…‡+‹Í GÎÏGåæ
?çæÝ
ü+

èé˔ ±+¶%:+¶&:¶'¶(±Ì“” •–—Í>ÎÏêë
ìæíæ îïðïÝ
Ó

èñËa*+¶)±Ì
›
œÍ4ÎÏòë
ìæíæóæÓ

èôË Ê ±+¶%:+¶&:¶'¶(6¢>¶*:    ¶+Æ% ¶+¶,¶- *¶+    ¶.„
§ÿÁ+¶/¹0
:¹1
™T¹2
À3:      ¶4¶5 8»3Y¶5¶5  ¶4    ¶6d`  ¶7    ¶8·9:
+
¶:W§:
§ÿ¨±
‘ÁÄÌf£¤ ¥¦¨(ª1¬;®J°P²]¨c¹„»‘¿—ÁœÂ¡Ã¦Ä­Å²ÆºÉÁÍÄËÆÏÉÐÍz1,õö   !B÷æºøù
„Búù   ÊÎÏÊòë
ÊìæÊíæÊóæÊûü ½ýï¶þïÝ=þÿÿ
;úü

ÿU







ÿÿ


Þú
úÓ



Ë
ˆ+DZ,DZ²;+¶<¶=.ªr
'<GQ\g+¶>¶?šD,+¶>¶@§9,+¶A¶B§.,²C¶D§$,+¶E¶F§,+¶G¶H§,+¶I¶J§±ÌBÕÖ
Ø<ÛFÝQáYâ\äcåfçnèqêyë|í„î‡òÍ ˆÎψÑö
ˆ
öÝ 1
    
 
 
Ó




Ë
‚²;+¶<¶=.ªp
%*pBpY+¶>°»Y·$¶!+¶AŽ¶K¶#°»Y·$¶!+¶E¶L¶#°»Y·$¶!+¶I¶!¶#°§M$°4~5L~Mc~dz~Ì"û0ý5þMÿd
{
~

Í‚Îς
   ö
Ý0BÞ



˜ 66£+¶M`6„
§ÿì¬Ì




Í>÷æ ÎÏ òë
 
æ 
 æáæÝ
ý

úÓ



˜ 86£+¶Nb8„
§ÿì®Ì


 

#Í>÷æ ÎÏ òë
 
æ 
 æá
Ý
ý
úÓ




Ëc»OYP¸Q·RN-¸S¶T-¸U¶V°Ì
, 
-
.Í ÎÏ


 





Ë
%w¸W:¶X¶Z¶Z ¶Z¶Z¸W:!¶X¶Z¶Z ¶Z¶Z6`6¶[¶\¶\”›ÿè¬ÌF
9
:
;
<
=#
>+
@0
A6
B>
CF
DN
EV
GY
K_
Lf
Nt
QÍ>wÎÏw


w

r

0G

Y
æÝ
þY




 
!
Ëq-,+¸]-,+¸^-,+¸_-,+¸`±Ì
X
Y
Z
[
\Í*ÎÏ
"ë
úù
#
$

%
&Ëä
Ú
M²aÀb´c´dN»eY·f:g¹hWi¹hWj¹hWk¹hWl¹hWm¹hWn¹hW»oY-·p:»qY·rM,st¶u:¹v
:w¹x:y¸zÀy:    ½{:
 
»{Y·|S
2}µ~
2»Y·€µ
»{Y·|S
2‚µ~
2»ƒY+·„µ  …†
¹‡:»Y· :ˆ¸zÀˆ: ½{:
 
»{Y·|S
2‰µ~
2»Y·€µ
»{Y·|S
2Šµ~
2‹µ
»{Y·|S
2ε~
2»Y·Žµ …
¹¶:¶:,Æ,¶°N‘-¸’»Y*´»Y·“¶!-¶”¶!¶#¸•·¿:,Æ,¶¿
–
¡
–
Í
¡
Ï
ÍÌÂ0
d
i
l
m"
n,
o6
p@
qJ
rT
s^
tj
wt
y~
{‡
}”
 
¦
‚±
ļ
„É
…Ô
†Ý
‡ì
‰ü
Œ



Ž


"

+
‘
:
’
E
“
N
”
W
•
b
–
k
—
{
˜
†
›

œ
’
ž
–
¥
š
¨
ž
ž
¡
Ÿ
¢
¡
¨
¢
Í
¥
Ó
¨Í¢
’
'Ä
‰
(
)j
7
*
+~
#
,
-‡

.
/”
 
0
1 


2
3  ¦û
4
5
ü¥
6
1
œÖ×

7
8 

9Ù
¢+ÚÛ
ÚÎÏ
ÚØÙ

Ø
:
;Ýpÿ
ž


<
=
>
?
@
A
B
C
D
E
C
F
G
<
<ÿ


<
=
Þkßÿ    


<
=ßÓ²

H
&Ë„
ž*´¶–¶—M»˜Y·™N»Y· :»šY›·œ:¼YïTY»TY¿T:6*´¶¢
2*´¶ž:6   ¶Ÿ6
   
£
  ¶%:Ç ;¶ §ò66 ¶¡6 ¢Ù ²¢¶£:š
;¶¤Æ®¶<²C¦ $¶¥§™¶<²¦¦¶E¶§§¶<²¨¦ $¶¥§l¶<²©¦-,¶ª¶«¶¥§O¶<²¬¦¶A¶­§7¶<²®¦¶>¶¥§¶<²¯¦ $¶¥§
$¶¥§:6„ 
§ÿ&¶°„ 
§þï„
§þȶ±¶¶°M»²Y*´³¸•·´¿­
]
`
‹
Œ̪*
´
µ
¶
·*
¸>
ºM
¼X
¾i
Àr
Á
„
Õ
Å¡
Ç­
˲
ͽ
ÏÇ
ÑÒ
Óß
Õê
×ô
Ùÿ
Û

Ý

ß
)
á
4
ã
A
å
L
ç
V
ë
]
ñ
`
ï
b
ò
e
Ã
k
ô
p
¾
v
º
|
ù

ú
†
û
Œ
ý

ÿͬ¡Ä
   ö‡ä
Iæ ŽÝ
Jærþ
Kï„ì
Lü[

Mæ   b

Næ
X
òëA
;־

O
P
y
Q
R
pÖ×*
b
S
T>
N
UÙ
ÚÛ
žÎÏ
žØÙ
ÝbÿA


<
V
W
F
X
<
þ 


üÿþ


ü
YBÞ
øùøúÿ


<
ÞÓ²

Z
[
ËÍc<*,¶µ !*"¶µ *
¶µ  * ¶µŸ<²¶*¶·M,¶¸™<,¹¶ºK™»Y·»¶!*¶!»¶!¶#°*°Ì
* ,4DaÍ c
\Äa
]ü
4/
^
_Ýü*

ü
`#
aÊ
Ë!
 »¸¼³¶±
Ì

b
cÀ¿ÆÈ@