Question: Is there a way to achieve exporting the entire active records in a rails application to csv where each relation is a sheet of csv or there is another way to export full db data.Any suggestions?

Answer: 
I solved this issue by clearing cache for Nuget Packages.
I was getting
Program type already present: androidx.appcompat.content.res.AppCompatResources$ColorStateListCacheEntry error.

I had 2 references
a)Xamarin.AndroidX.Appcompat and
b)Xmarin.Androidx.appcompat.content.res.AppCompatResources

I removed the reference Xmarin.Androidx.appcompat.content.res.AppCompatResources
And now the project builds without errors