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). |