Description

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.

Namespace:  DuoDimension.Databeam
Assembly:  Databeam.Excel (in Databeam.Excel.dll)
Version: 2.1.0.0

Syntax

      
 C#  Visual Basic 
public class Excel : IDisposable
Public Class Excel _
	Implements IDisposable

Members

            
 All Members  Constructors   Properties   Methods  
 Public

 Protected
 Instance

 Static 
 Declared

 Inherited
 XNA Framework Only 

 .NET Compact Framework Only 

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

SendHTMLMail(String, String, String, String, String, String, String, ArrayList)

Sends HTML file by email with attached files. 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).

Inheritance Hierarchy

System..::.Object
  DuoDimension.Databeam..::.Excel

See Also