Problem with saving all the whole data in R using biomaRt

Question

[palaganiajay]

I am new to R programming and have a question in saving the output file. I am unable to save all the data which consists of 4500 rows generated from R. It can only save the first 15 rows generated. Can someone please help me out with this.

below is the code which i used

> result<- getBM(attributes=attributes,filters=c("chromosome_name","start","end"),values=list(chrom,chr.start,chr.end),mart=ensembl)
> result
>write.xlsx(result,"/Users/ajaypalagani/Desktop/ajdat.xlsx")

Thank you Ajay

[Benn]

Please show the first 16 rows of your data frame.

head(result, n=16)

Also, try to save it as a tab delim txt file instead of xlsx.

[palaganiajay]

hi thank you for your reply.

I think i didn't post the question in a right way.

I am getting only first 15 rows of data and i need to export all the 4000 rows of data from R to excel.

Thanks, Ajay

[Jean-Karim Heriche]

The question was clear the first time around. We just need more info in order to help you. For example, we need to see the first 16 rows of your data because the suspicion is that the parser goes wrong between the 15th and the 16th line. Also exporting in another format can help figure out where the problem lies.

[Jean-Karim Heriche]

Do not 'add answer' to provide more info because this makes it look like your question is already answered. Use the 'add reply' button to reply to a request for info or 'add comment' to add something to the discussion that is not an answer.