GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV
,
WEBDEV
e
WINDEV Mobile
Inicio
|
Mensagens recentes
|
Conecte-se...
|
Disconnect
|
Português
Inicio
→
WINDEV 2024
→
import data from excel file to HyperFile
import data from excel file to HyperFile
Iniciado por agata, ago., 01 2011 11:27 AM - 4 respostas
Conecte-se…
agata
#1
Publicado em agosto, 01 2011 - 11:27 AM
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.
Denunciar
0
0
Mark Irwin
#2
Publicado em agosto, 01 2011 - 12:18 PM
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
Denunciar
0
0
Nasser
#3
Publicado em março, 27 2013 - 1:00 PM
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
Denunciar
0
0
Mark Irwin
#4
Publicado em março, 27 2013 - 3:12 PM
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
Denunciar
0
0
excel
#5
Publicado em janeiro, 09 2019 - 10:19 AM
try c# excel oledb...
http://csharp.net-informations.com/excel/csharp-excel-oledb.htm
Denunciar
0
0
→ Voltar para WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (versões anteriores)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Tipo de Pesquisa
Apenas tópicos
Todas as mensagens
Período de pesquisa
Qualquer momento
Última hora
Últimas 24 horas
Semana passada
Mês passado
Ano passado
Cancelar
Pré-visualização da sua mensagem
Adicionar imagem
Importar uma imagem de uma URL
Enviar uma imagem a partir do seu disco
Deixe um ficheiro ou clique em "Procurar ..."
ou
Cancelar
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Texto