Several families of WLanguage functions can be used to read and create these files. This allows you to easily read data generated by another software in your WINDEV applications or to create files that require a specific formatting.

Furthermore, several WLanguage functions can be used to handle the directories containing the files.

In this chapter, we will focus on:

Text files (text files, INI files and CSV files),
XML files,
XLS files,
the management of directories.

Handling text or CSV files

Overview

The external files are also called text files or files with direct access. In most cases, this type of file contains text but it can also contain binary information such as images, sounds, ...

In this lesson as in the entire WINDEV documentation, we will be talking of external files.

WINDEV allows you to handle the external files by programming. The WLanguage functions can be used to create, read ... external files. All functions can easily be identified: they all start with the letter "f".

The notion of "record" does not necessarily exist in an external file. To handle an external file, you must know its structure, which means how the data is organized inside the file.

The CSV files are text files that use a specific structure. Therefore, they can be handled like the text files.

The .INI files are also text files that use a specific structure. To handle them, WINDEV includes two specific functions: INIRead and INIWrite.

Practical example

Open the unit example named "Handling text files".

Run the test of "WIN_Text_File" window. This window groups the different operations that can be performed on the external files with WINDEV.

The different window buttons propose to:

Create a text file.
Read and write in a text file.
Operations performed on existing files (copy, delete, read information, ...).
Copy a text file.

See Functions for managing external files for more details.

Handling directories

Several WLanguage functions are used to handle the directories and their files.

Practical example

Open (if necessary) the unit example named "Handling directories" and run the test of corresponding window.

This window groups the operations that can be performed on disks and directories:
- create a directory,
- find out the current directory,
- check the existence of a directory,
- list the directories,
- copy and create a directory, ...

See Functions for managing external files for more details.

Handling XML files

Overview

XML (Extensible Markup Language) is a markup language, which means a language that presents information enclosed in tags. XML is a metalanguage that is used to invent new tags to isolate the elementary information that may be found in a Web page.

XML is used to structure a document containing data. A HFSQL data file containing several items and records can be exported to an XML file for example (XML* functions).

WINDEV supports:

the files in XML format via a native access supplied with WINDEV.
See Native XML Access for more details.
the exports to XML (TableToXML, TextToXML, HExportXML).
import of XML data (HImportXML).
the use of an XML document via the advanced XMLDocument type and via the WLanguage functions starting with XML.

The XML file can also be handled in the code editor directly. Simply:

Drag the XML file from the file explorer and drop it in the "Project explorer" pane tab, "External descriptions" folder.
Drag the XML file from the "Project explorer" pane and drop it in the code editor. The xmlDocument variable is automatically created as follows:
<Variable name> is xmlDocument, description = <Document name>
You now have the ability to access the variable nodes by their names. These names are automatically proposed by the mechanism for automatic completion of the code editor.

Practical example

Open the unit example named "Reading and writing in XML format".

Run the test of "WIN_HandleXML" window. This window is used to:
- create an XML file. This file is created by the XML functions.
- read an XML file.

Study the code associated with each button.


	Remark	We won't go into details about all the features proposed by the XML functions. See XML functions for more details.

Handling XLS files

To handle the Excel files, WINDEV proposes:

the xlsXXX functions. These functions are used to read the data found in the different worksheets of an Excel file.
the advanced variables (xlsDocument, xlsRow, xlsColumn, xlsCell).

Practical example

A quick test of these functions?

To check the use of xlsXXX functions, open the unit example named "The Excel functions".

Run the test of "WIN_XLSFunction" window. This window is used to:
- import data coming from an Excel worksheet.
- export data from a Table control to Excel.
Return to the editor to see the code of the different Button controls in the window.

To check the use of advanced variables, open the unit example named "XLS type".

Run the test of "WIN_XLS_Type" window.

Go back to the editor and study the code of different Button controls in the window.


	Remark	We won't go into details about all the features proposed by the XLS functions and the advanced types. See Functions for managing XLS files for more details.

Páginas

segunda-feira, 31 de agosto de 2020

DICAS 3060 -WINDEV TUTORIAL 83 -Licao 7.3-06-09-2020 11hrs-MANIPULACAO ARQUIVOS

https://youtu.be/jpDiUW806zk

Esse Ao Vivo vai estrear as 11:00 do dia 06/09/2020

o Programa Fonte esta no Scm

do Repositorio do Windev
https://repository.windev.com/

https://youtu.be/i5yP0DtZU5Q

Teste

Marcadores

Páginas

segunda-feira, 31 de agosto de 2020

DICAS 3060 -WINDEV TUTORIAL 83 -Licao 7.3-06-09-2020 11hrs-MANIPULACAO ARQUIVOS

https://youtu.be/jpDiUW806zk

Esse Ao Vivo vai estrear as 11:00 do dia 06/09/2020

o Programa Fonte esta no Scm

do Repositorio do Windevhttps://repository.windev.com/

https://youtu.be/i5yP0DtZU5Q

Teste

do Repositorio do Windev
https://repository.windev.com/