Products Technologies Demo Docs Blog Support Company

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.

Opening Microsoft Excel files with TX Text Control X16

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.

Excel documents

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 TXTextControl.TextControl.IsFormulaCalculationEnabled property.

If an Excel document contains more worksheets, the TXTextControl.LoadSettings.GetDocumentPartNames method can be used to retrieve a list of available worksheets in an Excel document. The name of a worksheet can be defined on loading the document using the TXTextControl.LoadSettings.DocumentPartName property.

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.

Stay in the loop!

Subscribe to the newsletter to receive the latest updates.

Also See

This post references the following in the documentation:

  • TXTextControl.LoadSettings.DocumentPartName Property
  • TXTextControl.LoadSettings.GetDocumentPartNames Method
  • TXTextControl.TextControl.IsFormulaCalculationEnabled 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.

See Windows Forms products

Related Posts

Windows FormsExcelRelease

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.


ASP.NETWindows FormsExcel

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…


ReportingExcelRelease

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.


ASP.NETWindows FormsWPF

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…


ASP.NETWindows FormsWPF

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…