Class contains methods to convert Excel Spreadsheet to html for publishing on Web. It also can be used to convert XLS to XML, CSV, TXT, XLSX.
Assembly: Databeam.Excel (in Databeam.Excel.dll)
Version: 2.0.0.0
Syntax
| C# | Visual Basic |
public class Excel : IDisposable
Public Class Excel _ Implements IDisposable
Members
| All Members | Constructors | Properties | Methods |
| Member | Description | |
|---|---|---|
| Excel(String) | Initializes a new instance of the DuoDimension.Databeam.Excel class. | |
| Cells | With the help of this property user can get an access to any cell of the workbook. The property is available after opening the Excel file. | |
| CreateFilesFolder | True if all supporting files, such as background textures and graphics, are organized in a separate folder when you convert XLS sheet to HTML Web page. False if supporting files are saved in the same folder as the HTML page. The default value is False. | |
| Dispose()()() | Immediately releases the unmanaged resources used by the object. This method is automatically launched in windows applications. | |
| IsExcelInstalled | Return true if Excel is installed, else false. | |
| NewXlsFile(Int32, Int32) | Compose the new Excel Spreadsheet file. | |
| OpenXls(String) | Open Excel Spreadsheet file. | |
| OpenXlsx(String) | Open Excel Spreadsheet file. | |
| OutlookMail(String, String, String) | Composes the letter use HTML file. With the help of MS Outlook(R) displays the letter, but doesn't send it. | |
| ReturnCode | The return code of the last conversion. See return codes for each method individually. | |
| SendHTMLMail(String, String, String, String, String, String, String) | Sends HTML file by email. But the method doesn't allow send a mail via smtp server with secure authentication. | |
| Sheets | Array of sheet names. The property is available after opening the Excel file. | |
| UpdateLinksOnSave | True if hyperlinks and paths to all supporting files are automatically updated before you convert the XLS into a Web page, ensuring that the links are up-to-date at the time the XLS is saved. False if the links are not updated. The default value is True. | |
| Version | Version of installed MS Office(R). | |
| XlsToCsv(Int32, String) | Converts Excel Spreadsheet to CSV. | |
| XlsToHtml(String) | Converts Excel Spreadsheet to HTML. | |
| XlsToHtml(Int32, String, String) | Converts certain sheet of Excel Spreadsheet to HTML. | |
| XlsToTxt(Int32, String) | Converts Excel Spreadsheet to TXT. | |
| XlsToXlsx(String) | Converts Excel Spreadsheet to XLSX (available for Excel 2007 only). | |
| XlsToXml(Int32, String) | Converts Excel Spreadsheet to XML. | |
| XlsxToCsv(Int32, String) | Converts Excel Spreadsheet OpenXML to CSV (available for Excel 2007 only). | |
| XlsxToHtml(String) | Converts Excel Spreadsheet OpenXML to HTML (available for Excel 2007 only). | |
| XlsxToHtml(Int32, String, String) | Converts certain Worksheet of the Excel Spreadsheet OpenXML to HTML (available for Excel 2007 only). | |
| XlsxToTxt(Int32, String) | Converts Excel Spreadsheet OpenXML to TXT (available for Excel 2007 only). | |
| XlsxToXls(String) | Converts Excel Spreadsheet to XLS (available for Excel 2007 only). | |
| XlsxToXml(Int32, String) | Converts Excel Spreadsheet OpenXML to XML (available for Excel 2007 only). |