如何将数据写入 .SLK 文件
我有一个非常简单的 ETL 作业 - 从 .txt 到另一个文件的简单文件转换。五分钟,对吗?好吧,除了一件事 - 输出文件必须是 .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, guys!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
.SLK 是文件扩展名,但您想要的可能是更广为人知的“SYLK”格式。它只能使用 ASCII 文本生成。该格式的概述如下:http://hernk。 wordpress.com/2007/06/23/the-sylk-file-format/
这是一个生成 SYLK 文件的程序,尽管它可能无法用于您的目的,因为您的源是 .TXT 文件而不是比 Oracle 数据库: PL/SQL 程序位于asktom.oracle.com。通过该链接,SYLK 文件提供了“...能够执行许多更奇特的操作,例如字体、标题、公式等。”
.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."