XlsxToHtmlConverter

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

XlsxToHtmlConverter

(★ 32)

A fast, versatile, and powerful XLSX to HTML converter. Support an extensive scope of cell stylings and additional elements. Empower the efficient transformation of spreadsheets into well-structured web documents. Provide the ability to easily customize every aspect of the conversion process with progress callbacks. Only depend on the Open XML SDK.

XlsxToHtmlConverter Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# XlsxToHtmlConverter v2.4.0-dev

[![Language](https://img.shields.io/badge/Language-C%23-lightgray.svg?style=flat-square)](https://raw.githubusercontent.com/Fei-Sheng-Wu/XlsxToHtmlConverter/master/)
[![.NET](https://img.shields.io/badge/.NET-%E2%89%A56.0-orange.svg?style=flat-square)](https://raw.githubusercontent.com/Fei-Sheng-Wu/XlsxToHtmlConverter/master/)
[![.NET Standard](https://img.shields.io/badge/.NET%20Standard-%E2%89%A52.1-orange.svg?style=flat-square)](https://raw.githubusercontent.com/Fei-Sheng-Wu/XlsxToHtmlConverter/master/)
[![NuGet](https://img.shields.io/nuget/v/XlsxToHtmlConverter?label=NuGet&logo=nuget&logoColor=white&style=flat-square)](https://www.nuget.org/packages/XlsxToHtmlConverter)
[![Downloads](https://img.shields.io/nuget/dt/XlsxToHtmlConverter?label=Downloads&logo=nuget&logoColor=white&style=flat-square)](https://www.nuget.org/packages/XlsxToHtmlConverter)
[![Commits Since](https://img.shields.io/github/commits-since/Fei-Sheng-Wu/XlsxToHtmlConverter/v2.3.0?label=Commits%20Since&style=flat-square)](https://github.com/Fei-Sheng-Wu/XlsxToHtmlConverter/commits/master)
[![License](https://img.shields.io/github/license/Fei-Sheng-Wu/XlsxToHtmlConverter?label=License&style=flat-square)](https://raw.githubusercontent.com/Fei-Sheng-Wu/XlsxToHtmlConverter/master/LICENSE.txt)
[![Sponsor](https://img.shields.io/badge/GitHub%20Sponsors-red.svg?logo=githubsponsors&logoColor=white&style=flat-square)](https://github.com/sponsors/Fei-Sheng-Wu)

> A fast, versatile, and powerful XLSX to HTML converter. Support an extensive scope of cell stylings and additional elements. Empower the efficient transformation of spreadsheets into well-structured web documents. Provide the ability to easily customize every aspect of the conversion process with progress callbacks. Only depend on the Open XML SDK.

## Dependencies

- [DocumentFormat.OpenXml](https://github.com/dotnet/Open-XML-SDK) ≥ 3.1.1, < 4.0.0

## Features

- [x] Cell structures, sizes, fonts, fills, borders, alignments, and visibilities
- [x] Content presentation with number formats and basic conditional formats
- [x] Elements of pictures and shapes with responsive positioning
- [x] HTML construction with configurable details and modernized organization

| Original XLSX File |
| :---: |
| ![Original XLSX File](https://raw.githubusercontent.com/Fei-Sheng-Wu/XlsxToHtmlConverter/master/sample-xlsx.png) |

| Converted HTML File |
| :---: |
| ![Converted HTML File](https://raw.githubusercontent.com/Fei-Sheng-Wu/XlsxToHtmlConverter/master/sample-html.png) |

## Versioning

For versions ≥ 2.0.0, the versioning of XlsxToHtmlConverter conforms to the following scheme:

| Generation | | Major | | Minor |
| :--- | :---: | :--- | :---: | :--- |
| **2** | . | **4** | . | **0** |
| _(backward-incompatible)_ | | _(backward-incompatible)_ | | _(backward-compatible)_ |
| Significant codebase refactors. | | Severe bug fixes and core improvements. | | Mild changes. |

The changelogs are available at the [Releases](https://github.com/Fei-Sheng-Wu/XlsxToHtmlConverter/releases).

## How to Use

Only one line to convert a local XLSX file to HTML:

```c#
XlsxToHtmlConverter.Converter.Convert(@"C:\path\to\input.xlsx", @"C:\path\to\output.html");
```

Similarly, the use of `Stream` is supported:

```c#
Stream input = ...;
Stream output = ...;
XlsxToHtmlConverter.Converter.Convert(input, output);
```

Alternatively, the input may also be a `DocumentFormat.OpenXml.Packaging.SpreadsheetDocument` instance:

```c#
using DocumentFormat.OpenXml.Packaging;
```
```c#
SpreadsheetDocument input = ...;
Stream output = ...;
XlsxToHtmlConverter.Converter.Convert(input, output);
```

### Conversion Configuration

A third optional parameter can be set to configure the conversion process:

```c#
XlsxToHtmlConverter.ConverterConfiguration configuration = new()
{
    BufferSize = 65536,
    Encoding = Encoding.UTF8,
    NewlineCharacter = "\n",
    TabCharacter = new(' ', 2),
    RoundingDigits = 2,
    CurrentCulture = CultureInfo.CurrentCulture,
    HtmlTitle = null,
    HtmlRootClass = "xlsx",
    HtmlPresetStylesheet = ...,
    XlsxSheetSelector = null,
    XlsxSheetDimensionSelector = null,
    XlsxCellSelector = null,
    XlsxObjectSelector = null,
    ConvertSheetTitles = true,
    ConvertSizes = true,
    ConvertVisibilities = true,
    ConvertStyles = true,
    ConvertNumberFormats = true,
    ConvertPictures = true,
    ConvertShapes = true,
    UseHtmlFragment = false,
    UseHtmlClasses = true,
    UseHtmlHexadecimalColors = true,
    UseHtmlProportionalWidths = true,
    UseHtmlDataElements = true,
    ...
};
XlsxToHtmlConverter.Converter.Convert(..., ..., configuration);
```

### Progress Callback

A fourth optional parameter can be set to add a progress callback event handler:

```c#
XlsxToHtmlConverter.Converter.Convert(..., ..., ..., HandleProgressChanged);
```
```c#
private void HandleProgressChanged(DocumentFormat.OpenXml.Packaging.SpreadsheetDocument? sender, XlsxToHtmlConverter.ConverterProgressChangedEventArgs e)
{
    string summary = $"Sheet {e.CurrentSheet} of {e.SheetCount} | Row {e.CurrentRow} of {e.RowCount}";
    string progress = new string('█', (int)Math.Round(e.ProgressPercentage / 100.0 * 50)).PadRight(50, '░');
    Console.Write($"{e.ProgressPercentage:F2}% ({summary}) {progress}");
}
```

## Contributors

[![Contributors](https://contrib.rocks/image?repo=Fei-Sheng-Wu/XlsxToHtmlConverter)](https://github.com/Fei-Sheng-Wu/XlsxToHtmlConverter/graphs/contributors)

## License

XlsxToHtmlConverter is licensed under the [MIT License](LICENSE.txt).

XlsxToHtmlConverter

XlsxToHtmlConverter Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

XlsxToHtmlConverter

XlsxToHtmlConverter Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README