PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV 25
→
DICAS 2123 - WINDEV WEBDEV MOBILE - EXCEL 9 - IMPORTAR TABELA
DICAS 2123 - WINDEV WEBDEV MOBILE - EXCEL 9 - IMPORTAR TABELA
Started by amarildo, May, 25 2019 2:33 PM - No answer
Connect yourself…
amarildo
#1
Registered member
535 messages
Popularité : +14 (14 votes)
Posted on May, 25 2019 - 2:33 PM
BOM DIA,SEJA BEM VINDOS A MAIS UMA VIDEO AULA. ESSA AULA ESTA SENDO GRAVADA NO DIA 25 05 2019.
DICA 2123.HOJE VOU MOSTRAR COMO LER EXCEL E COLOCAR NUMA TABELA.
DICAS 2123 - WINDEV WEBDEV MOBILE - EXCEL 9 - IMPORTAR TABELA
// BTN_PROCURA_EXCEL
s
File
is string
// Opens the file picker
s
File
=
fSelect
(
""
,
""
,
"Select a file..."
,
"All the files (*.*)"
+
TAB
+
"*.*"
+
CR
+
"EXCEL"
+
TAB
+
"*.XLS"
,
"*.*"
)
E
DT_PROCURA_ARQUIVO_eXCEL
=
s
File
//btn_abrir_excel
TableDeleteAll
(
TABLE_
EXCEL
)
n
ABRE_EXCEL
is int
=
xlsOpen
(
E
DT_PROCURA_ARQUIVO_eXCEL
)
IF
n
ABRE_EXCEL
<
>
-
1
THEN
n
NUMERO_LINHAS
is int
=
xlsNbRow
(
n
ABRE_EXCEL
)
n
CONTADOR
is int
=
0
FOR
n
CONTADOR
=
2
TO
n
NUMERO_LINHAS
POSICAO
is int
=
TableAddLine
(
TABLE_
EXCEL
)
Message
(
n
CONTADOR
+
"/"
+
n
NUMERO_LINHAS
)
TABLE_
EXCEL
[
POSICAO
]
.
COL_01_A_CODE
=
xlsData
(
n
ABRE_EXCEL
,
n
CONTADOR
,
1
)
TABLE_
EXCEL
[
POSICAO
]
.
COL_02_B
=
xlsData
(
n
ABRE_EXCEL
,
n
CONTADOR
,
2
)
TABLE_
EXCEL
[
POSICAO
]
.
COL_03_C_OUVRAGE
=
xlsData
(
n
ABRE_EXCEL
,
n
CONTADOR
,
3
)
TABLE_
EXCEL
[
POSICAO
]
.
COL_04_D_UNITE
=
xlsData
(
n
ABRE_EXCEL
,
n
CONTADOR
,
4
)
TABLE_
EXCEL
[
POSICAO
]
.
COL_05_E_DURÉE
=
xlsData
(
n
ABRE_EXCEL
,
n
CONTADOR
,
5
)
TABLE_
EXCEL
[
POSICAO
]
.
COL_06_F_DEB_MO
=
xlsData
(
n
ABRE_EXCEL
,
n
CONTADOR
,
6
)
TABLE_
EXCEL
[
POSICAO
]
.
COL_07_G_DEB_FO
=
xlsData
(
n
ABRE_EXCEL
,
n
CONTADOR
,
7
)
TABLE_
EXCEL
[
POSICAO
]
.
COL_08_H_PV_HT
=
xlsData
(
n
ABRE_EXCEL
,
n
CONTADOR
,
8
)
END
END
ErpMatos - TgsSistemas
email: amarildo.matos@gmail.com
whats: 51984197742
Youtube: Amarildo Matos
http://www.amarildomatos.com.br
https://groups.google.com/forum/…
www.windev.com
https://www.pcsoft.fr/webinaires.htm…
https://forum.pcsoft.fr/fr-FR/pcsoft.br.windev/page/1.awp
https://www.windev.com/windev/WD-Express.htm
https://www.windev.com/windevmobile/WM-Express.htm
http://windevdesenvolvimento.blogspot.com.br/2017/07/menu-blog.html
https://windevdesenvolvimento.blogspot.com/2019/05/dicas-2123-windev-webdev-mobile-excel-9.html
https://doc.windev.com/en-US/…
Report
0
0
→ Go back to WINDEV 25
WINDEV 25
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text