Opening Microsoft Excel files with TX Text Control X16
Using TX Text Control X16, Excel spreadsheets can be imported into documents. This article shows several ways to work with Excel worksheets.

Since TX Text Control X16 (26.0), Microsoft Excel spreadsheets can be loaded. Worksheets are converted into TX Text Control tables with formatting, formulas and cell number formats.
After a table has been created, included formulas are evaluated automatically and values are calculated when values of referenced cells are changed. By default, the formulas are evaluated automatically, but this can be disabled using the TXText
If an Excel document contains more worksheets, the TXText
Excel documents can be loaded, appended and inserted at the current input position. The following code loops through the returned document part names and imports all available worksheets into new sections in a TX Text Control document.
string[] sDocumentParts = LoadSettings.GetDocumentPartNames("cash_excel.xlsx",
StreamType.SpreadsheetML);
LoadSettings ls = new LoadSettings();
foreach (string documentPart in sDocumentParts)
{
ls.DocumentPartName = documentPart;
textControl1.Append("cash_excel.xlsx",
StreamType.SpreadsheetML,
ls,
AppendSettings.StartWithNewSection);
}
Test this on your own and download a trial version of TX Text Control X16.
Also See
This post references the following in the documentation:
- TXText
Control. Load Settings. Document Part Name Property - TXText
Control. Load Settings. Get Document Part Names Method - TXText
Control. Text Control. Is Formula Calculation Enabled Property
Windows Forms
Text Control combines the power of a reporting tool and an easy-to-use WYSIWYG word processor - fully programmable and embeddable in your Windows Forms application. TX Text Control .NET for Windows Forms is a royalty-free, fully programmable rich edit control that offers developers a broad range of word processing features in a reusable component for Visual Studio.
Related Posts
Automatically Format Numbers in Table Cells
The NumberFormat property can be used to automatically format numbers in table cells. This article shows how to use this feature.
Loading and Processing Excel XLSX Spreadsheet Tables into TX Text Control…
TX Text Control provides a powerful API to load and process Excel spreadsheet tables in .NET applications. This article shows how to load an Excel file and process the tables using TX Text Control…
Sneak Peek X16: Excel Formulas and MailMerge
With the release of TX Text Control X16, Excel compatible formulas can be used in table cells. This article shows how to utilize them within MailMerge templates.
TX Text Control 33.0 SP3 is Now Available: What's New in the Latest Version
TX Text Control 33.0 Service Pack 3 is now available, offering important updates and bug fixes for all platforms. If you use TX Text Control in your document processing applications, this service…
TX Text Control 33.0 SP2 is Now Available: What's New in the Latest Version
TX Text Control 33.0 Service Pack 2 is now available, offering important updates and bug fixes for all platforms. If you use TX Text Control in your document processing applications, this service…