WorksheetToHTMLPage.cs

#region Copyright Syncfusion® Inc. 2001-2025.
// Copyright Syncfusion® Inc. 2001-2025. All rights reserved.
// Use of this code is subject to the terms of our license.
// A copy of the current license can be obtained at any time by e-mailing
// licensing@syncfusion.com. Any infringement will be prosecuted under
// applicable laws. 
#endregion
using Syncfusion.XlsIO;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using COLOR = Syncfusion.Drawing;
using System.IO;
using Android.Content;
using Android.Views;
using Android.Widget;
using Android.Graphics;
using System.Reflection;

namespace SampleBrowser
{
    public partial class WorksheetToHTMLPage : SamplePage
    {
        private Context m_context;
        RadioGroup radioGroup;
        RadioButton workbookButton;
        RadioButton worksheetButton;


        public override View GetSampleContent(Context con)
        {
            LinearLayout linear = new LinearLayout(con);
            linear.SetBackgroundColor(Color.White);
            linear.Orientation = Orientation.Vertical;
            linear.SetPadding(10, 10, 10, 10);

            TextView text2 = new TextView(con);
            text2.TextSize = 17;
            text2.TextAlignment = TextAlignment.Center;
            text2.Text = "This sample illustrates the conversion of a simple Excel document to HTML file.";
            text2.SetTextColor(Color.ParseColor("#262626"));
            text2.SetPadding(5, 5, 5, 5);

            linear.AddView(text2);

            TextView space1 = new TextView(con);
            space1.TextSize = 10;
            linear.AddView(space1);

            m_context = con;

            LinearLayout radioLinearLayout = new LinearLayout(con);
            radioLinearLayout.Orientation = Orientation.Horizontal;

            TextView imageType = new TextView(con);
            imageType.Text = "Convert : ";
            imageType.TextSize = 19;
            radioLinearLayout.AddView(imageType);

            radioGroup = new RadioGroup(con);
            radioGroup.TextAlignment = TextAlignment.Center;
            radioGroup.Orientation = Orientation.Horizontal;
            workbookButton = new RadioButton(con);
            workbookButton.Text = "Workbook";
            radioGroup.AddView(workbookButton);
            radioGroup.Selected = true;
            worksheetButton = new RadioButton(con);
            worksheetButton.Text = "Worksheet";
            radioGroup.AddView(worksheetButton);
            radioLinearLayout.AddView(radioGroup);
            linear.AddView(radioLinearLayout);
            workbookButton.Checked = true;

            TextView space2 = new TextView(con);
            space2.TextSize = 10;
            linear.AddView(space2);

            Button templateButton = new Button(con);
            templateButton.Text = "Input Template";
            templateButton.Click += OnButtonClicked;
            linear.AddView(templateButton);

            Button convertButton = new Button(con);
            convertButton.Text = "Convert";
            convertButton.Click += OnConvertButtonClicked;
            linear.AddView(convertButton);

            return linear;
        }

        private void OnConvertButtonClicked(object sender, EventArgs e)
        {
            //Instantiate excel engine
            ExcelEngine excelEngine = new ExcelEngine();
            //Excel application
            IApplication application = excelEngine.Excel;

            //Get assembly manifest resource
            Assembly assembly = Assembly.GetExecutingAssembly();
            Stream fileStream = assembly.GetManifestResourceStream("SampleBrowser.Samples.XlsIO.Template.NorthwindTemplate.xlsx");

            //Open Workbook
            IWorkbook workbook = application.Workbooks.Open(fileStream);

            //Get Worksheet
            IWorksheet worksheet = workbook.Worksheets[0];

            //Create a new memory stream
            MemoryStream stream = new MemoryStream();

            if(workbookButton.Checked)
            {
                workbook.SaveAsHtml(stream);
            }
            else
            {
                worksheet.SaveAsHtml(stream);
            }

            workbook.Close();
            excelEngine.Dispose();

            //Save and view the generated file.
            if (stream != null)
            {
                stream.Position = 0;
                OpenHtmlFile(stream);
            }
        }

        void OnButtonClicked(object sender, EventArgs e)
        {
            Assembly assembly = Assembly.GetExecutingAssembly();
            Stream filestream = assembly.GetManifestResourceStream("SampleBrowser.Samples.XlsIO.Template.NorthwindTemplate.xlsx");

            MemoryStream stream = new MemoryStream();
            filestream.CopyTo(stream);

            if (stream != null)
            {
                SaveAndroid androidSave = new SaveAndroid();
                androidSave.Save("Template.xlsx", "application/msexcel", stream, m_context);
            }
        }
        void OpenHtmlFile(MemoryStream stream)
        {
            StreamReader reader = new StreamReader(stream);
            string htmlString = reader.ReadToEnd();
            Intent i = new Intent(m_context, typeof(WebViewActivity));
            i.PutExtra("HtmlString", htmlString);
            m_context.StartActivity(i);
        }
    }
}