I am afraid, the current set of the Aspose.Cells APIs do not provide any means to detect the encoding of a CSV file therefore you have to explicitly specify the encoding at the time of loading the CSV in Aspose.Cells object model.
Well, I am afraid, it might not be possible to auto detect the encoding type of a text format like CSV therefore you have to explicitly set the encoding using the TxtLoadOptions class.