how to convert xls file to csv

RDD val data2:rdd[string] = Spark.sparkContext.textFile ( "Hdfs://ns1/datafile/wangxiao/affairs.txt") Case class Affairs1 (Affairs:int, gender:string, Age:int, Yearsmarried:double, Children:string, Religiousness:int, education:double, Occupation: Double, Rating:int)//RDD Convert to Data frame val Res2 = data2.map {_.split ("")}.map {line + Affairs1 (line (0). ToInt , line (1). trim.tostring (), line (2). ToInt, Line (3). ToDoub

public class Export {public static final String CSVNAME_COMPETITION="cpc.csv";} Public class CSV {public static final string endline = "\ n"; public static final map Import Java. io. bufferedwriter; import Java. io. file; import Java. io. filewriter; import Java. io. ioexception; public class output {public static bufferedwriter getwriter (string name, string path) {bufferedwriter BR = NULL; try {mkdirs

I encountered a problem today. The content is described as follows:There is an Excel file with hundreds of thousands of rows of data, for example:Name number content .......Zhang San 12132 xxxxxxxxxxLili 321321 yyyyyyy....I wanted to apply the data to the app, but I couldn't find a proper method. I originally wanted to convert the data to SQLite. I found the SQLite management tool on MAC for a long time, bu