Hi Yogesh , I have never tried reading XLS files using Spark . But I think you can use sc.wholeTextFiles to read the complete xls at once , as xls files are xml internally, you need to read them all to parse . Then I think you can use apache poi to read them .
Also, you can copy you XLS data to a MS-Access file to access via JDBC , Regards, Rabin Banerjee On Wed, Jul 20, 2016 at 2:12 PM, Yogesh Vyas <informy...@gmail.com> wrote: > Hi, > > I am trying to load and read excel sheets from HDFS in sparkR using > XLConnect package. > Can anyone help me in finding out how to read xls files from HDFS in > sparkR ? > > Regards, > Yogesh > > --------------------------------------------------------------------- > To unsubscribe e-mail: user-unsubscr...@spark.apache.org > >
