untitled
viviti

ExcelAPI  

What is ExcelAPI?

Based on JExcelAPI by Andy Khan, ExcelAPI is a handy utility for handling Excel files. It is a java application allows user to read/write/create/modify Excel file. This application keeps all the JExcelAPI functions and add Script, XMLXLS, SrcDump functions to enable user can modify/create Excel file by a script file ,output xml format as xls file as well as dump Excel spreadsheets in script format. The application also changes the library of JExcelAPI to enable the program can handle non-english text informations and provides parameter to switch the text code for dump functions.

Features
  • Excel workbooks data dump in csv, xml, script format
  • Excel information dump
  • create/modify Excel workbooks
  • Supports font, number and date formatting
  • Supports shading and colouring of cells
  • Modifies existing worksheets
  • Supports image creation
  • Preserves macros on copy

    • What is JExcelAPI?

    Java Excel API(JExcelAPI), by Andy Khan, a famous open source API for Excel in Java, which allows applications to read/write Excel spreadsheets dynamically with many advanced features. Widely used and appreciated by Java developers.

    how to use ExcelAPI     goto top

    Command format:

    Dump Excel data in XML format

    ExcelAPI -xml [-format] excelfile [output]


    Dump Excel data in modified XML format with xls sub-name

    ExcelAPI -xmlxls [-unicode|-big5] excelfile [Header]

    Excel data will be dumped in file 'Header.Sheet-Name.xls' In case of Header was not specified, StdOut will be used.

    Create/midify Excel file by scripts

    ExcelAPI -script script-file excelfile output


    Read and Write functions demo

    ExcelAPI -readwrite|-rw excelfile output


    Dump Excel data in biff format

    Write functions demo

    Formulars record dump

    WriteAccess record dump

    Features information dump

    Escher record dump

    Escher DrawingGroup record dump

    ExcelAPI -biffdump | -bd | -write | -formulas -wa | -features | -escher | -escherdg excelfile


    PropertySets record dump

    ExcelAPI -ps excelfile [property] [output]


    Version information dump

    Log function test

    Help informations dump

    Script informations dump

    ExcelAPI -version | -logtest | -h | -help | hs


    Dump Excel data in CSV format

    Dump Excel data in Script format

    ExcelAPI -csv|SrcDump [-unicode|-big5|-c:code] [-hide] excelfile [Header]

    Excel data will be dumped in file 'Header.Sheet-Name.csv|src' In case of O.S. does not use unicode/Big5 code, uses -c:xxxx to defines. xxxx = specified code name.


    EX.
    >java -jar ExcelAPI.jar -rw jxlrwtest.xls xxx.xls
    >java -jar ExcelAPI.jar -csv jxlrwtest.xls
    >java -jar ExcelAPI.jar -c:big5 -srcdump jxlrwtest.xls xxx
    >java -jar ExcelAPI.jar -script script.txt "" script.xls
    >java -jar ExcelAPI.jar -big5 -csv 96q01.xls
    >java -jar ExcelAPI.jar -biffdump jxlrwtest.xls >biffdump.txt
    >java -jar ExcelAPI.jar -logtest
    >java -jar ExcelAPI.jar -version
    >java -jar ExcelAPI.jar -h
    >java -jar ExcelAPI.jar -hs >scripthelp.txt
    >java -jar ExcelAPI.jar
    >java -jar ExcelAPI.jar -rw jxlrwtest.xls rwout.xls


    Format of Script Commands:     goto top

    --> Documentation of Script Commands and Script test

    --> Test result





    Web Hosting · Blog · Guestbooks · Message Forums · Mailing Lists
    Easiest Website Builder ever! · Build your own toolbar · Free Talking Character · Email Marketing
    powered by a free webtools company bravenet.com