Images not appearing in Excel

[Moin Faisal]

Hi

I am trying to develop an application that takes images from camera and then generate excel report.

Issues:

1. Images are not available in Excel

2. Time does not appear in excel when DateTime is used.

Extensions used

1. Xam.Plugin.Media: Get images from camera

2. Syncfusion.Xamarin.XlsIO: To generate excel report

Steps:

1. Capture images

2. Save the image locally

3. Generate Report

3.1. When generating report we get the data from locally saved images as bytes[]

I have attached the project which is doing something similar that I want to achieve.

Kindly help me find what is incorrect in my approach.

Attachment: Test_a1e2f19f.7z

[Abirami Varadharajan]

Hi Moin, 

Greetings from Syncfusion. 

Please find the details below. 

Queries	Details
1. Images are not available in Excel	We are able to reproduce the issue and validating it currently. We will update further details by 19th June 2019.
2. Time does not appear in excel when DateTime is used.	It is recommended to set the desired format to the Date column. Please refer to below code to set the date time format in the Excel file.  workbook.Worksheets[0].Columns[1].NumberFormat =  "m/d/yyyy h:mm";  You can refer to below documentation to know more on Number formats.  https://help.syncfusion.com/file-formats/xlsio/working-with-cell-or-range-formatting#apply-number-formats

Regards, 

Abirami 

[Abirami Varadharajan]

Hi Moin, 

The issue is reproducing with the default viewer. If you use Microsoft Excel application in your Android/iOS  to view the generated document, then you may not face such issue. So, it is recommended to open in Microsoft Excel app to resolve issue at your end. 

 

We have prepared video screenshot for your reference which can be downloaded from following link. 

 

Video link : http://www.syncfusion.com/downloads/support/directtrac/general/ze/Sample_Excel1372882430.zip 

Regards, 

Abirami 

[Moin Faisal]

Hi

I am sorry for late reply.

The solution provided works.

Thank you.

[Abirami Varadharajan]

Hi Moin, 

Thank you for updating us. 

We are glad that the issue is resolved at your end. Please let us know if you need further assistance. 

Regards, 

Abirami