XLS Files

[yidabu]

using DWin on Windows:
http://www.dsource.org/projects/dwin/

here is an example from D China
http://bbs.d-programming-language-china.org/thread-797-1-1.html

import dwin.sys.win32.com.Core;
import dwin.sys.win32.com.Client;
import tango.io.Stdout;


void main()
{
    auto app = new DispatchObject("Excel.Application");
   
     app.set("Visible",1);                                
   
    auto vbooks = app.get("Workbooks");                  
    auto books = new DispatchObject(vbooks.pdispVal);
   
    auto vbook = books.get("Open", "d:\\200.xls");                     \\打开此文件
    auto book = new DispatchObject(vbook.pdispVal);  
   
    auto vsheet = book.get("ActiveSheet");
    auto sheet = new DispatchObject(vsheet.pdispVal);
   
    auto vrange = sheet.get("Range", "A1");                          \\设定单元格
    auto range = new DispatchObject(vrange.pdispVal);
   
    auto vvalue = range.get("Value");                                        \\读该设定的单位格的值
     Stdout ( vvalue ).newline;       \\ vvalue 是Variant结构体，为什么可直接输出成员变量的值 呢？  
        
}



Zarathustra <adam.chrapkowski at gmail.com> wrote:

> Max Samukha Wrote:
> 
> > On Mon, 18 Aug 2008 03:35:52 -0400, Zarathustra
> > <adam.chrapkowski at gmail.com> wrote:
> > 
> > >Is there easy way of to get access to *.xls files.
> > >To particular cells in sheets.
> > >I need to read some data from spreadsheet straight to my program.
> > >Thanks in advance.
> > 
> > As you can access COM objects from D, you could use Automation or
> > whatever they call it now.
> 
> Reply to Max Samukha:
> 
> Could you tell me where can I find more information about this way?
> 


-- 
yidabu <yidabu.spam at gmail.com>
http://www.dsource.org/projects/dwin

D 语言-中文(D Chinese):
http://www.d-programming-language-china.org/
http://bbs.d-programming-language-china.org/
http://dwin.d-programming-language-china.org/
http://scite4d.d-programming-language-china.org/