XLSX

All .NET products of TX Text Control including ASP.NET (Core), Windows Forms and WPF provide an Excel XLSX SpreadsheetML filter to import spreadsheets into a document. Spreadsheets included in an Excel document can be imported and converted into a "smart" table including supported formulas, cell number format settings and the included formatting.

Importing Spreadsheets

In order to load spreadsheets from XLSX files into TX Text Control, all file load methods can be utilized including:

&#9584; TX Text Control .NET Server &#9584; TXTextControl Namespace &#9584; ServerTextControl Class &#9584; Load Method Loads text in a certain format. " data-tippy-interactive="true" data-tippy-placement="bottom" data-tooltip-width="wide"

>Load &#9584; TX Text Control .NET Server &#9584; TXTextControl Namespace &#9584; Selection Class &#9584; Load Method Exchanges the currently selected text with text in a certain format. " data-tippy-interactive="true" data-tippy-placement="bottom" data-tooltip-width="wide"

>Selection. Load &#9584; TX Text Control .NET Server &#9584; TXTextControl Namespace &#9584; ServerTextControl Class &#9584; Append Method Loads text in a certain format from a file, a byte array or a string and appends it to the existing document. " data-tippy-interactive="true" data-tippy-placement="bottom" data-tooltip-width="wide"

>Append

This allows the insertion of spreadsheets into a new document, into the current input position or at a new section or page. The spreadsheets can be loaded from physical files, byte arrays or streams.

The &#9584; TX Text Control .NET Server &#9584; TXTextControl Namespace &#9584; LoadSettings Class &#9584; DocumentPartName Property SpreadsheetML only. " data-tippy-interactive="true" data-tippy-placement="bottom" data-tooltip-width="wide"

>Document Part Name property of the LoadSettings is used to define the sheet in the loaded document. The following code is loading spreadsheet 2021 from the document cashflow.xlsx into the current input position.

TXTextControl.LoadSettings ls = new TXTextControl.LoadSettings() { DocumentPartName = "2021" };

textControl1.Selection.Load("cashflow.xlsx", TXTextControl.StreamType.SpreadsheetML, ls); The following screenshot shows the spreadsheet 2021 opened in Microsoft Excel. This name is used in the DocumentPartName property.

After importing the spreadsheet into TX Text Control, you can see the imported formatting, the table cell format and the working formulas:

Reference Styles

TX Text Control provides two reference styles to reference cells for formulas: A1 and R1C1 .

Loading Multiple Spreadsheets

The following code shows how to load multiple spreadsheets into TX Text Control by calling the Selection.Load multiple times:

private void ImportSpreadsheets(string filename, string[] sheetNames) {

foreach (string sheetName in sheetNames) { TXTextControl.LoadSettings ls = new TXTextControl.LoadSettings() { DocumentPartName = sheetName };

textControl1.Selection.Load(filename, TXTextControl.StreamType.SpreadsheetML, ls); }

}

ImportSpreadsheets("cashflow.xlsx", new string[] { "2021", "2022" }); The following screenshot animation shows the working formulas when changing the associated cell content.

TX Text Control .NET Server

DS Server

Server & Web

Windows Forms

WPF

ActiveX

Core Technologies

Blog

Core Technologies

Blog

Authors

Latest Posts

Support Resources

Documentation

Support

Getting Started

Other Resources

About Us

Industry events

Company

Contact

Newsletter

Legal

Sign in

Create account

Text Control Account

XLSX

Post tagged with XLSX in 2023

Server & Web

Windows Forms

WPF

ActiveX

Core Technologies

​

Latest Posts

​

Support

Getting Started

​

Other Resources

Company

Contact

Newsletter

Legal

Text Control Account

​

​

XLSX

Post tagged with XLSX in 2023 ​

February 2023

Post tagged with XLSX in 2023