How to Remove Default Bookmark When Exporting a Named Range as HTML

Aspose.Cells Product Family
21

@KeerthanaRamesh214
Also, would you like to provide your complete test code? Including exporting HTML using Aspose.Cells and importing HTML using Aspose.Words. We will check it soon.

22 
var cellArea = CellArea.CreateCellArea(C5, E9);
var range = worksheet.Cells.CreateRange(
    cellArea.StartRow,
    cellArea.StartColumn,
    cellArea.EndRow - cellArea.StartRow + 1,
    cellArea.EndColumn - cellArea.StartColumn + 1
);
InsertHtmlData(builder, workbook, worksheet, range);


private static void InsertHtmlData(DocumentBuilder builder, Workbook workbook, Worksheet worksheet, Range range)
{
    string htmlContent = GetHtmlStream(workbook, worksheet, range);
    builder.InsertHtml(htmlContent, HtmlInsertOptions.RemoveLastEmptyParagraph);
    builder.Writeln();
}

private static string GetHtmlStream(Workbook workbook, Worksheet worksheet, Range range)
{
    string htmlStm;

    workbook.Worksheets.ActiveSheetIndex = worksheet.Index;
    worksheet.PageSetup.PrintArea = range.Address;

    using (MemoryStream htmlStream = new MemoryStream())
    {
        workbook.Save(htmlStream, new Aspose.Cells.HtmlSaveOptions
        {
            ExportImagesAsBase64 = true,
            ExportPrintAreaOnly = true,
            ExportHiddenWorksheet = false,
            ExportActiveWorksheetOnly = true,
            PresentationPreference = true,
            HiddenRowDisplayType = HtmlHiddenRowDisplayType.Remove,
            HiddenColDisplayType = HtmlHiddenColDisplayType.Remove,
            DisableCss = true,
            EmbeddedFontType = HtmlEmbeddedFontType.Woff
        });

        htmlStream.Position = 0;
        using (StreamReader reader = new StreamReader(htmlStream))
        {
            htmlStm = reader.ReadToEnd();
        }
    }
    return htmlStm;
}```
23

@KeerthanaRamesh214
By using the following sample code for testing, we can obtain the correct results if the machine is installed with the font used. Please refer to the attachment. OUTPUT_net.zip (16.7 KB)

Workbook workbook = new Workbook(filePath + "INPUT.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

var cellArea = CellArea.CreateCellArea("C5", "E9");
var range = worksheet.Cells.CreateRange(
    cellArea.StartRow,
    cellArea.StartColumn,
    cellArea.EndRow - cellArea.StartRow + 1,
    cellArea.EndColumn - cellArea.StartColumn + 1
);

Aspose.Words.DocumentBuilder builder = new Aspose.Words.DocumentBuilder();
InsertHtmlData(builder, workbook, worksheet, range);

builder.Document.Save(filePath + "OUTPUT_net.docx");

private static void InsertHtmlData(Aspose.Words.DocumentBuilder builder, Workbook workbook, Worksheet worksheet, Aspose.Cells.Range range)
{
    string htmlContent = GetHtmlStream(workbook, worksheet, range);
    builder.InsertHtml(htmlContent, Aspose.Words.HtmlInsertOptions.RemoveLastEmptyParagraph);
    builder.Writeln();
}

private static string GetHtmlStream(Workbook workbook, Worksheet worksheet, Aspose.Cells.Range range)
{
    string htmlStm;

    workbook.Worksheets.ActiveSheetIndex = worksheet.Index;
    worksheet.PageSetup.PrintArea = range.Address;

    using (MemoryStream htmlStream = new MemoryStream())
    {
        workbook.Save(htmlStream, new Aspose.Cells.HtmlSaveOptions
        {
            ExportImagesAsBase64 = true,
            ExportPrintAreaOnly = true,
            ExportHiddenWorksheet = false,
            ExportActiveWorksheetOnly = true,
            PresentationPreference = true,
            HiddenRowDisplayType = HtmlHiddenRowDisplayType.Remove,
            HiddenColDisplayType = HtmlHiddenColDisplayType.Remove,
            DisableCss = true,
            EmbeddedFontType = HtmlEmbeddedFontType.Woff
        });

        htmlStream.Position = 0;
        using (StreamReader reader = new StreamReader(htmlStream))
        {
            htmlStm = reader.ReadToEnd();
        }
    }
    return htmlStm;
}

We will further investigate your issue and notify you promptly of any updates.

24

Yes if the font is installed then fine. But I need the same behavior when the font is not installed.

25

@KeerthanaRamesh214
Thank you for your feedback. We will further investigate your issue and notify you promptly of any updates.

1 Like
26

@KeerthanaRamesh214
Please remove the DisableCss attribute setting. We tested the generated HTML using the following code and obtained the expected results when viewed on machines with and without the fonts used in the installed files. Please refer to the attachment. out_net_result.zip (8.2 KB)

Workbook workbook = new Workbook(filePath + "INPUT.xlsx");
Worksheet worksheet = workbook.Worksheets[0];
Range range = worksheet.Cells.CreateRange("C5:E9");

string htmlString = GetHtmlStream(workbook, worksheet, range);

File.WriteAllText(filePath + "out_net_result.html", htmlString);

private static string GetHtmlStream(Workbook workbook, Worksheet worksheet, Range range)
{
    string htmlStm;

    workbook.Worksheets.ActiveSheetIndex = worksheet.Index;
    worksheet.PageSetup.PrintArea = range.Address;

    using (MemoryStream htmlStream = new MemoryStream())
    {
        workbook.Save(htmlStream, new Aspose.Cells.HtmlSaveOptions
        {
            ExportImagesAsBase64 = true,
            ExportPrintAreaOnly = true,
            ExportHiddenWorksheet = false,
            ExportActiveWorksheetOnly = true,
            PresentationPreference = true,
            HiddenRowDisplayType = HtmlHiddenRowDisplayType.Remove,
            HiddenColDisplayType = HtmlHiddenColDisplayType.Remove,
                    
            EmbeddedFontType = HtmlEmbeddedFontType.Woff


        }); ;

        htmlStream.Position = 0;
        using (StreamReader reader = new StreamReader(htmlStream))
        {
            htmlStm = reader.ReadToEnd();
        }
    }
    return htmlStm;
}
27

Ok @John.He let me try from my end and update Thank you. One more question will the same font be preserved in word if in html its preserved…?

28

@KeerthanaRamesh214
MS-Word can preserve fonts. If there is still an issue with the text display after importing HTML using Aspose.Words, please add a new post to the Aspose.Words forum. Aspose.Words staff will support you soon.

1 Like