Why i can't use Workbooks.Open() ?

[dep]

Hello when i do my app finish and i Build > Archive to my phone i have problem when use the Workbooks.Open() my app will stoped working.

This is my code.

     IApplication application = excelEngine.Excel;

     application.DefaultVersion = ExcelVersion.Xlsx;

     var asset = Android.App.Application.Context.Assets.Open("test.xlsx"); //this is my stream it is working don't care this.

     IWorkbook workbook = application.Workbooks.Open(fileContent); //it is not working.

I installed on Syncfusion.Xamarin.XlsIO only not Syncfusion.XlsIO.Net.Core

[Shamini Kiruba Sobers]

Hi Dep, 

Greetings from Syncfusion. 

In Xamarin platforms, you can use Workbooks.Open() method only with stream and not with filename. Kindly refer the code snippets from the following UG links. 

Help links: 

https://help.syncfusion.com/file-formats/xlsio/create-read-edit-excel-files-in-xamarin-c-sharp#read-and-edit-excel-file 

https://help.syncfusion.com/file-formats/xlsio/loading-and-saving-workbook?cs-save-lang=1&cs-lang=xamarin 

Please let us know if it helps. 

Regards, 

Shamini 

[dep]

Can you do something for get that i'm just need use for HttpClient but that just my sample.

[Shamini Kiruba Sobers]

Hi Dep, 

We suggest you to add the input Excel document as Embedded resource in the project and load it into stream as shown in the below code snippet. 

Code Snippet: 

//Gets assembly 

Assembly assembly = typeof(App).GetTypeInfo().Assembly; 

 

//Gets input Excel document from an embedded resource collection 

Stream excelStream = assembly.GetManifestResourceStream("GettingStarted.Sample.xlsx"); 

 

IWorkbook workbook = application.Workbooks.Open(excelStream); 

Steps to make input Excel document an Embedded resource: 

1. Add the input Excel document in the project.
2. Right click on the document -> select properties -> select the Build Action as Embedded resource.

We have prepared simple sample for your reference and the same can be downloaded from the following link. 

Sample Link:  

https://www.syncfusion.com/downloads/support/forum/158243/ze/F158243950812818 

Kindly try this and let us know if it helps. 

Regards, 

Shamini