Background...

Microsoft Excel is the most widely used spreadsheet for vast majority of financial reporting application. To generate Excel files from your data/ template. There are following options:

1. Excel automation (C++, VBA macro). Problem: must be running on Windows platform; can be very slow and unstable.
2. Java based library (POI). Problem: Usually very slow and requires large memory. Learning complex programming APIs.
3. 3rd Party library. Problem: Some of them running only on Windows platform; not very fast (against me :-); learning curve.
4. Write Excel XML file. Problem: large file size (vs. xls); slow to process; slow download and file loading for large files; Complex XLS formatting / programming; Future support from Microsoft unknown;

New choice...

directxl is a software library/executable utility designed to have the HIGHEST performance on the market and most memory efficiency. Written entirely in 100% Ansi C++ it can be compiled/built for any platform for portability. All APIs are very easy to use and can be used with 100% pure Java (thru JNI module) or C++. For starter, it comes with an executable utility that processes a batch file without any programming. The batch file is a text file anyone can create and tells the executable how to generate Excel file: import/export CSV, formatting, using template, etc. It also comes with some very convenient features you can not find on the market today...importing CSV larger than 256 columns and 64K rows for Excel and apply virtual formatting ranges on the 'large' spreadsheet.

The software can be run out-process (stand alone) or embedded (as linked software library) at any level from thin client (PDA), mid-tier to back-end servers. It is capable to create very large Excel file ultra fast  and stable (You can benchmark my software against any other solutions by yourself after downloading). It is designed and implemented for 24-7 enterprise wide high volume, high speed Excel Spreadsheet reporting system. 100% multi-instances and thread-safe.

Summary...

• Run on any OS/hardware: Unix, Windows, Mac...
• Read and convert CSV files into Excel sheets (per workbook).
• Automatically split large CSV (> 256x64K) into multiple work sheets or books and works with virtual cell range (outside 256x64K)
• Export Excel to CSV files
  
• Cell range formatting with fonts, align, merge, transpose.
• Uses any Excel XLS file as template. Simple as 'open', 'modify' and 'save as' operations.
  
• Global string replacements in XLS template...so you can separate programming from Excel layout.
  
• Sheet print page setup.
  
• Save as Excel 5.0-10.0 XLS file or create only in-memory for web streaming Excel spreadsheet to browser.
• Support direct database access thru JDBC for any database (with JDBC driver).

Source code and 3rd party branding available. Return to home