FORUMS PROFESSIONNELS
WINDEV
,
WEBDEV
et
WINDEV Mobile
Accueil
|
Messages récents
|
Connexion
|
Déconnexion
|
Français
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
Connectez-vous…
agata
#1
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.
Signaler
0
0
Mark Irwin
#2
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
Signaler
0
0
Nasser
#3
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
Signaler
0
0
Mark Irwin
#4
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
Signaler
0
0
excel
#5
Posté le 09 janvier 2019 - 10:19
try c# excel oledb...
http://csharp.net-informations.com/excel/csharp-excel-oledb.htm
Signaler
0
0
→ Revenir à WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (précédentes versions)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Type de recherche
Uniquement les sujets
Tous les messages
Période de recherche
Date indifférente
Moins d'une heure
Moins de 24 heures
Moins d'une semaine
Moins d'un mois
Moins d'un an
Annuler
Aperçu de votre message
Ajouter une image
Importer une image depuis une URL
Envoyer une image depuis un fichier de votre disque
Déposez ici un fichier ou cliquez sur "Parcourir..."
ou
Annuler
0%
WLangage
SQL
XML, HTML
JAVA, Javascript
Texte