Excel - Code for a row line in source

2019-09-09 05:26发布

All

I am trying to change the "delimiters" in my csv file, so I can open it as an excel file.

I know the delimiter to separeate the columns is ';'. But what is the delimiter for a new line?

Thanks

1条回答
我只想做你的唯一
2楼-- · 2019-09-09 05:52

For windows machines: vbCrLf or Chr(13) & Chr(10)
Carriage Return then Line Feed

If you are going to be using this code on multiple platforms, then vbNewLine will be whatever is needed for the platform (windows/unix/mac/whatever)

查看更多
登录 后发表回答