func X3.EN_FILE_CSV_TO_XLSX(Clbfile CSV_PATH_IN, Clbfile XLSX_PATH_IN, Char DELIMITER_IN, Char ENCLOSURE_IN, Char ENCODING_IN, Tinyint CONTAINS_HEADER_IN, Tinyint INTERPRET_FORMULAS_IN) : Tinyint

Allows you to transform a csv file into an xlsx file

  • CSV_PATH_IN Clbfile Full path or volume to the original csv file
  • XLSX_PATH_IN Clbfile Full path or volume to the file to create
  • DELIMITER_IN Char CSV file field separator (Ex: ";", ",", chr$(9))
  • ENCLOSURE_IN Char Field delimiter if existing (Ex: '"')
  • ENCODING_IN Char File encoding ("UTF-8", "CP1252", "ISO-8859-1", "ISO-8859-2")
  • CONTAINS_HEADER_IN Tinyint Indicate whether the first row is, 1, or not, 0, a column header (Field names)
  • INTERPRET_FORMULAS_IN Tinyint Indicate whether the file contains Excel formulas to interpret 1 or not 0
Return Tinyint 1 if xlsx file created, 0 otherwise
Example

func X3.EN_FILE_CSV_TO_XLSX("C:\...\test.csv", "C:\...\test.xlsx", ";", "", "utf-8", 0, 0)
Create the file C:\...\test.xlsx from the utf-8 csv file with ; as field delimiter