I have been trying to prepare either *.txt or *.csv files from Julia to be read by a VBA script. It appears that the files prepared by Julia NOT PUT a carriage return(CR) line feed(LF) at the end of each line. It seems VBA detects and end of file (EOF) upon the first line feed (see VBA script below)…

Writing CSV or TXT files to be read by VBA script (not just opened by excel)

sijo January 24, 2021, 7:46am 2

CSV.write has a newline parameter: Home · CSV.jl

Can you try with CSV.write("input_VBA.csv", df, delim=',', decimal='.', newline="\r\n")?

1 Like

Topic		Replies	Views
How do i get CR+LF ('\r\n') line endings using CSV.jl? New to Julia	2	956	February 12, 2019
Julia program reading CSV file from stdin Data	13	1967	August 29, 2018
Reading text or csv files and assigning values to variable names New to Julia question	24	5827	November 25, 2020
Update the last line while writing the current line during writing to a file in julia General Usage	1	311	December 5, 2019
Can't get seekend working on a manually updated csv file New to Julia	2	441	January 17, 2022