create a desktop shortcut翻译中文（Create a CSV file）
导读：Create a CSV file...
Create a CSV file
For this example, let’s assume we have an array of maps as our data.
def planets = [
[id:1,color:red,planet:mars,description:Mars, the "red" planet],
[id:2,color:green,planet:neptune,description:Neptune, the "green" planet],
[id:3,color:blue,planet:earth,description:Earth, the "blue" planet],
]
Next, we can create our CSV file as follows:
def out = new File(planets.csv)
planets.each {
def row = [it.id, it.color, it.planet]
out.append row.join(,)
out.append \n
}
Which creates a file with the following content:
1,red,mars 2,green,neptune 3,blue,earthHowever, this does not contain our description field. If you need to also handle double quotes and commas in your data then you can:
qualify your values with a double quote, and replace double quotes in your data with an escaped double quote.In this case our code may look like:
def out = new File(planets.csv)
planets.each {
def row = [it.id, it.color, it.planet, it.description]
.collect { " + it.replace(","") + " }
out.append row.join(,)
out.append \n
}
Which creates a file with the following content:
"1","red","mars","Mars, the ""red"" planet" "2","green","neptune","Neptune, the ""blue"" planet" "3","blue","earth","Earth, the ""blue"" planet"
声明：本站所有文章 ，如无特殊说明或标注 ，均为本站原创发布 。任何个人或组织 ，在未征得本站同意时 ，禁止复制 、盗用 、采集 、发布本站内容到任何网站 、书籍等各类媒体平台 。如若本站内容侵犯了原著者的合法权益 ，可联系我们进行处理 。
创心域SEO版权声明：以上内容作者已申请原创保护，未经允许不得转载，侵权必究！授权事宜、对本内容有异议或投诉，敬请联系网站管理员，我们将尽快回复您，谢谢合作！