I’ve done a lot with ExcelTable lately and achieved pretty much all I wanted to do.Īny ideas or enhancement requests are still welcome but I’ll now focus on a new “recreational” project : ExcelGen. The generated content starts with a ‘A’, ends with ‘Z’, with the necessary amount of ‘x’ in-between, so that I can quickly and visually check whether the data was correctly read or written by the consuming application.īuf raw(32767) := utl_raw.copies('78',32767) I use it very often to generate binary data of arbitrary size. Here’s the source of my sampledata() function. My implementation in XUTL_CDF is a direct PL/SQL port of the C++ sample code available in the Wikipedia article, but it was fun to do nonetheless. Sibling objects in a given level of the hierarchy are arranged in a Red-Black tree. The hierarchical relationships between file entries (storage and stream objects) in a compound file are stored in a directory structure. Writes the compound file to disk, using given directory and file name.Ĭloses the file (releases handle and associated resources).

In this example, I used a little PL/SQL function sampledata() to generate a BLOB of a given size, but of course any BLOB can be used as data source.

Intermediate storage entries (folders) are created on the fly if they don’t exist. The target path name must be an absolute path. Version 3 is also available (XUTL_CDF.V3), the main difference with V4 is the FAT sector size, which is 512 bytes for V bytes for V4.Īdds streams (binary files) to the compound file. Xutl_cdf.write_file(hdl, 'TEST_DIR', 'cdf.dat') Ĭreates a new file using version 4 format (the default). As a preliminary step towards adding password encryption to ExcelGen (see previous post), I have enhanced my existing CFBF reader with file generation capabilities.Īnd since it is not a reader anymore, I have also renamed it to “CDFManager” in my GitHub repository.

Fileopen client 979