PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

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
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.
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
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
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
Publicado el 09,enero 2019 - 10:19