FOROS PROFESIONALES
WINDEV
,
WEBDEV
y
WINDEV Mobile
Inicio
|
Mensajes recientes
|
Conéctese...
|
Desconectar
|
Español
Inicio
→
WINDEV 2024
→
import data from excel file to HyperFile
import data from excel file to HyperFile
Iniciado por agata, 01,ago. 2011 11:27 - 4 respuestas
Conéctese…
agata
#1
Publicado el 01,agosto 2011 - 11:27
Hello,
I'm fresh user in Windev . I'm begining my adventure with this tool
I have a data in excel file and I need to import it to HyperFile .
I have already found a function to import data from file txt (HImportText()) but It can't go with excel data.
Could You help me please ?
I would appreciate for any help.
Informar
0
0
Mark Irwin
#2
Publicado el 01,agosto 2011 - 12:18
Hi
You can use the built i XLS functions to read and import an XLS document.
xlsAddWorksheet Adds or inserts a new worksheet into an Excel document
xlsClose Closes an XLS file
xlsColumnTitle Retrieves the title of a column in an XLS file
xlsColumnType Returns the type of the data entered in a column of an XLS file
xlsCurrentWorksheet Used to find out and modify the current worksheet in an XLS file
xlsData Retrieves the content of a cell found in an XLS file.
xlsDeleteWorksheet Deletes a worksheet from the Excel document
xlsMsgError Returns the caption of the last error caused by an XLS function
xlsNbColumn Returns the number of columns found in a worksheet of an XLS file
xlsNbColumns xlsNbColumns is kept for backward compatibility
xlsNbRow Returns the number of rows found in an XLS file.
xlsNbRows xlsNbRows is kept for backward compatibility
xlsNbWorksheet Returns the number of worksheets found in an XLS file.
xlsOpen Opens an Excel file (xls or xlsx files).
xlsSave Saves an XLS document
xlsVersion Returns the Excel version that was used to save the file
cheers
Mark
Informar
0
0
Nasser
#3
Publicado el 27,marzo 2013 - 13:00
is ther any example to use this ?
______________________________________________________________________________
Mark Irwin wrote in news message <c0bf90f5573a2311a0cd4b951dd3ee0e@news.pcsoft>:
Hi
You can use the built i XLS functions to read and import an XLS document.
xlsAddWorksheet Adds or inserts a new worksheet into an Excel document
xlsClose Closes an XLS file
xlsColumnTitle Retrieves the title of a column in an XLS file
xlsColumnType Returns the type of the data entered in a column of an XLS file
xlsCurrentWorksheet Used to find out and modify the current worksheet in an XLS file
xlsData Retrieves the content of a cell found in an XLS file.
xlsDeleteWorksheet Deletes a worksheet from the Excel document
xlsMsgError Returns the caption of the last error caused by an XLS function
xlsNbColumn Returns the number of columns found in a worksheet of an XLS file
xlsNbColumns xlsNbColumns is kept for backward compatibility
xlsNbRow Returns the number of rows found in an XLS file.
xlsNbRows xlsNbRows is kept for backward compatibility
xlsNbWorksheet Returns the number of worksheets found in an XLS file.
xlsOpen Opens an Excel file (xls or xlsx files).
xlsSave Saves an XLS document
xlsVersion Returns the Excel version that was used to save the file
cheers
Mark
Informar
0
0
Mark Irwin
#4
Publicado el 27,marzo 2013 - 15:12
Hi Nasser
yes there is a training example called controlling spreadsheets and a unit examp-le called Excel functions. They should get you started.
cheers
Mark
Informar
0
0
excel
#5
Publicado el 09,enero 2019 - 10:19
try c# excel oledb...
http://csharp.net-informations.com/excel/csharp-excel-oledb.htm
Informar
0
0
→ Volver a WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (versiones precedentes)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Búsqueda Tipo
Sólo temas
Todos los mensajes
Periodo Buscar
Cualquier fecha
Última hora
Última 24 horas
Última semana
Último mes
Último año
Cancelar
Vista previa del mensaje
Añadiendo una imagen
Importar una imagen desde una URL
Enviar una imagen desde un archivo de su disco
Arrastrar un archivo o click en "Examinar..."
o
Cancelar
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Texto