How to set the LoadFormat to LoadOptions

Aspose.Cells Product Family
1

Hi all,


Does anyone know how to set the LoadFormat to the LoadOptions?

According to the description of LoadOptions.LoadFormat, it say “Gets and set the load format.”, but I can see the getter in that property only.

Is that a problem?

Thank you.

PS. I am using Aspose.Cells version 8.2.0

2

Hi,


Thank you for contacting Aspose support.

Please pass the LoadFormat to the LoadOptions’ constructor as elaborated below.

C#

//Create an instance of LoadOptions to tell the API that you are going to load a CSV
var loadOptions = new LoadOptions(LoadFormat.CSV);

//Load a CSV in an instance of Workbook
var book = new Workbook(“D:/temp/test.csv”, loadOptions);

3

Hi,


It work.

Thank you for your prompt reply.
4

Hi,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is now resolved. Let us know if you face any other issue, we will be glad to look into it and help you further.