PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → Import excel-sheet into a table
Import excel-sheet into a table
Débuté par devi, 27 fév. 2008 12:10 - 2 réponses
#1
Posté le 27 février 2008 - 12:10
hello together,
i am looking for a function to import an excel sheet / data into a table.
I.e "imortexceltotabe"?!?!
Does anybody know how to do so easy?

Thank for your help!
#2
Posté le 27 février 2008 - 16:32
>hello together,

i am looking for a function to import an excel sheet / data into a table.


>I.e "imortexceltotabe"?!?!

Does anybody know how to do so easy?


>Thank for your help!

Hi,

You can use windev's code, no ?

Example :

nIdFichierXLS is int

nIdFichierXLS = xlsOpen(EXCEL_FILE)

FOR nZ_indice=2 TO xlsNbRow(nIdFichierXLS)

IF NoSpace(xlsData(nIdFichierXLS, nZ_indice, 1))<>"" THEN

END

END

REGARDS
#3
Posté le 27 février 2008 - 16:58
Hi,

I'm pretty new to windev, but there doesn't seem to be a lone function to import a whole spreadsheet. This seems strange as there is a method of doing what you require but it's in the New Project wizard.

There are however a whole host of individual functions to process excel contents - search for "XLS functions" in the help system.

You'll find functions to open/close and read data from a sheet, but there are also functions to find the number of rows and columns, so from this you could set up your own loopers to get the data in the way you want it :-)

Hope this helps..

Regards,
Darren.
→ Revenir à WINDEV 2024