开发者

How to write data into a .SLK File

开发者 https://www.devze.com 2023-02-06 04:26 出处:网络
I have a very simple ETL job - a simple file conversion from .txt to another. Five minutes, right? Well, except for one thing - the output file needs to be .SLK.

I have a very simple ETL job - a simple file conversion from .txt to another. Five minutes, right? Well, except for one thing - the output file needs to be .SLK.

I Googled a bit and it seems to be a "programmed" format, with format data embedded into the file itself. Anybody have any links regarding the details of the format? Help me out here, guy开发者_开发问答s!


.SLK is the file extension but what you want is probably better known as "SYLK" format. It can be generated using only ASCII text. An overview of the format is here: http://hernk.wordpress.com/2007/06/23/the-sylk-file-format/

And here's is a program that generates SYLK files, although it's probably is not usable for your purposes since your source is a .TXT file rather than an an Oracle database: PL/SQL program at asktom.oracle.com. From that link, SYLK files offer "... the ability to do much fancier stuff like fonts, headings, formulas and such."

0

精彩评论

暂无评论...
验证码 换一张
取 消