ConvertSpot.com Excel to CSV, Convert Excel to CSV, Excel to CSV Converter
PDF to XML, Excel to XML, Excel to Text, Word to Text, PowerPoint to Text, PDF to Text
 
   

Product->Convert Excel to CSV(COM Edition)->Tech Document

Installation:

  • Download the 15 days trial version here.

  • Unzip the package to a folder on your hard drive.

  • Open an dos window and Go to the folder you store P2T Server Edition.

  • Run "regsvr32 E2TServer.dll" from command line to register the component.
     

    Check the methods exposed from the COM interface here.

    Examples:

  • Example in ASP

  • Example in PHP

  • Example in Cold Fusion

  • Example in VC

  • Example in VB

     

    Download Now          FAQ'S            Buy It Now

     

    Example in ASP:

    <%

    'Create the convert excel to csv object
    set e2c = Server.CreateObject("E2TServer.E2C")

    'VerifyLicense verify the username/keycode of excel text converter.
    'it always success in trial version.
    e2c.VerifyLicense "4747457", "345srwr242342423"

    Response.Write e2c.Convert ("c:\test\test1.xls", "c:\box\test1.csv")+ "<br>"
    Response.Write e2c.Convert ("c:\test\test2.xls", "c:\box\test2.csv") + "<br>"
    Response.Write e2c.Convert2Mem ("c:\test\test3.xls", 50000) + "<br>"

    %>

    Go back to top
     

    Example in PHP:  

    <?php

    #Create excel to csv object
    $e2c = new COM("E2TServer.E2C");

    #VerifyLicense always success in trial version.
    $e2c->VerifyLicense("4747457", "345srwr242342423");

    #Convert excel file to csv file

    print $e2c->Convert ("c:\test\test1.xls", "c:\box\test1.csv"). "<br>";
    print $e2c->Convert ("c:\test\test2.xls", "c:\box\test2.csv"). "<br>";
    print $e2c->Convert2Mem ("c:\test\test2.xls", 50000). "<br>";

    #Release excel to csv object.
    $e2c = null;

    ?>

    Go back to top

    Example in ColdFusion:

    <cfobject type="COM"
        action="Create"
        name="e2c"
        class="E2TServer.E2C">
    <cfset strName="4747457">
    <cfset strKey="345srwr242342423">
    <cfset result = e2c.VerifyLicense(strName, strKey)>
    <cfset strExcelName="C:\test\test1.xls">
    <cfset strCSVName="C:\test\test1.csv">
    <cfset result=e2c.Convert(strExcelName, strCSVName)>
    <cfset result=e2c.Convert2Mem(strExcelName, 50000)>

    Go back to top


    Example in VC:


    You need generate wrapper class of Excel to text converter use class wizard first.
    "ClassWizard->ActiveX Events->Add Class->From a type lib..."
    ////////////////////////////////
    IE2C e2c;
    if(e2c.CreateDispatch("E2TServer.E2C"))
    {
    e2c.VerifyLicense("34234","234234");
    CString strRslt = e2c.Convert("C:\\test\\test1.xls","c:\\test\\test1.csv");
    MessageBox(LPCTSTR(strRslt));

    strRslt = e2c.Convert2Mem("C:\\test\\test1.xls",5000);
    MessageBox(LPCTSTR(strRslt));
    }
    /////////////////////////////////

    Go back to top


    Example in VB:


    You need to add the reference of Excel Text Converter to the project
    "Project->References..." Make sure "E2TServer Type Library" was selected there.

    '''''''''''''''''''''''''''''''''''''''''''''''''
    Dim myE2C As E2TSERVERLib.E2C
    Dim strRslt As String
    'Create the Excel to text object
    Set myE2C = New E2C
     

    'Verify the license information of Excel to text Converter.
    myE2C.VerifyLicense "234234", "23423432"

    'Convert Excel file to Text File.
    strRslt = myE2C.Convert(C:\test\test1.xls","c:\test\test1.csv")
    MsgBox strRslt
    strRslt = myE2C.Convert2Mem(C:\test\test1.xls",5000)
    MsgBox strRslt

    '''''''''''''''''''''''''''''''''''''''''''''''''

    Go back to top

    Any comments or question, Send email to
    support@retsinasoftware.com with "E2CCOM" in subject.

     

    COM Interface
    There's 4 methods exposed
    ///////////////////////////////////////////////////////
    1. HRESULT VerifyLicense(
    [in] BSTR bstrName,
    [in] BSTR bstrKey,
    [out, retval] long* pbRetVal);

    VerifyLicense is the method must be called before all other methods.
    It's to verify the run time license information.
    @param BSTR bstrName: The register name
    @param BSTR bstrKey: The register key code.
    @param long* pbRetVal: 1 If verify license cuccessfully.
                           0 If something wrong with the name/key
    This variable always be set to 1 in trial version
    @return S_OK

    ///////////////////////////////////////////////////////
    2. HRESULT GetVersion([out, retval] BSTR* pbstrVersion);

    Return the version information.
    @param BSTR* pbstrVersion: The current version information was returned in this buffer.
    @return S_OK

    ///////////////////////////////////////////////////////
    3. HRESULT Convert(
    [in] BSTR bstrExcel,
    [in] BSTR bstrCSV,
    [out, retval] BSTR* pbstrRetVal);

    @param BSTR bstrExcel: The absolute path and file name of the excel file you
    want to convert.
    @param BSTR bstrCSV: The absolute path and file name of the csv file you
    want to convert to.
    @param BSTR* pbstrRetVal: The result and any warning/error information
    will return by this pointer

    @return S_OK: Process the excel file successfully. Check *pbstrRetVal for detail
    information.

    ///////////////////////////////////////////////////////
    4. HRESULT Convert2Mem(
    [in] BSTR bstrExcel,
    [in] int nBufSize,,
    [out, retval] BSTR* pbstrRetVal);

    @param BSTR bstrExcel: The absolute path and file name of the excel file you want to convert.
    @param BSTR nBufSize: The data buffer size for the output data, if the output data size is bigger than the buffer size, the converter just discard the overflowed data. There's a hard code limitation of buffer size, it's 5M, if pass in nBufSize is bigger than 5M, the converter will set the buffer size to 5M.
    @param BSTR* pbstrRetVal: The converted text will be return directly in the variable.
    @return S_OK: Process the excel file successfully. If it's not S_OK, check *pbstrRetVal for detail information.

    Go back to top

  •  

     
    2004 Retsina Software Solutions Ltd. All rights reserved.           Site Map  |  Contact us  |  Privacy Policy