Features

Excel Html Entities

Excel Html Entities

Features

Excel HtmlEntityConversion Export

Flexsheet supports saving the xlsx file with HTML entities content, too. In the client, convertHtmlEntities property of IFlexSheetXlsxOptions defines the conversion behavior for HTML entities such as """, "<", ">" and "&" when exporting. The default value is HtmlEntityConversion.Auto.

File Name: Convert HTML Entities
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace FlexSheetExplorer.Controllers
{
    public partial class FlexSheetController : Controller
    {
        // GET: ExcelHtmlEntities
        public ActionResult ExcelHtmlEntities()
        {
            return View();
        }
    }
}
@model IEnumerable<Sale>

@section Scripts{
    <script type="text/javascript" src="~/Scripts/FlexSheet/excelHtmlEntities.js"></script>
}
@section Styles{
    <style>
        .btn {
            margin-bottom: 0;
        }
    </style>
}

<div>
    <div class="copy">
        <h3>@Html.Raw(Resources.FlexSheet.ExcelIO_HtmlConversion_Text0)</h3>

        <p>@Html.Raw(Resources.FlexSheet.ExcelIO_HtmlConversion_Text1)</p>

    </div>
    <div class="row">
        <div class="col-md-12 col-xs-24">
            <div class="form-inline well well-lg">
                @Html.Raw(Resources.FlexSheet.ExcelIO_Text5)
                <input type="text" class="form-control" id="fileName2" />
                @Html.Raw(Resources.FlexSheet.ExcelIO_HtmlConversion_Text2)
                @(Html.C1().ComboBox().Id("HtmlEntityConversion").IsEditable(false))
                <button class="btn btn-default" onclick="exportHtmlEntities()">@Html.Raw(Resources.FlexSheet.ExcelIO_Text4)</button>
            </div>
        </div>
    </div>
    <div>
        @(Html.C1().FlexSheet().CssClass("flexSheet").Id("excelHtmlEntitiesSheet")
        .AddUnboundSheet("Unbound", 10, 10))
    </div>
</div>