Save as csv in xlsIO

[Gary Pansino]

When I use your online instructions, I am getting an error "Argument 1: cannot convert from 'Windows.Storage.StorageFile' to 'System.IO.Stream' when trying to save a sheet (shData) as a csv.

var saveMain = await ApplicationData.Current.LocalFolder.CreateFileAsync("Test.csv", CreationCollisionOption.ReplaceExisting);

await shData.SaveAsAsync(saveMain, ",", Encoding.UTF8); 

Any advice?

Thanks.

[Gary Pansino]

I had also tried  shData.SaveAs(saveMain, ",", Encoding.ASCII); and both SaveAs and ASCII are not recognized as keywords.

[Manoj Kumar G M]

Hi Gary Pansino,

Thank you for choosing Syncfusion products.

Currently we don’t have support for passing  StorageFile as an argument for saving CSV files. Please use the following code snippet to achieve the above scenario.

Code Snippets:

StorageFile storageFile = await ApplicationData.Current.LocalFolder.CreateFileAsync("Test.csv");

            await sheet.SaveAsAsync(await storageFile.OpenStreamForWriteAsync(), ",", System.Text.Encoding.UTF8);

 

Please let us know if you any further clarifications.

Regards,

Manojkumar.