PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → import data from excel file  to HyperFile
import data from excel file to HyperFile
Débuté par agata, 01 aoû. 2011 11:27 - 4 réponses
Posté le 01 août 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.
Posté le 01 août 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
Posté le 27 mars 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
Posté le 27 mars 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
Posté le 09 janvier 2019 - 10:19