Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #6445

Re: Read Excel file

From JohnMartens <martens@tennishulp.info>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Read Excel file
Date 2013-12-22 17:49 +0100
Organization A noiseless patient Spider
Message-ID <l9757a$951$1@dont-email.me> (permalink)
References <c31a7f20-19ae-428c-a21e-d94ba61b66b0@googlegroups.com>

Show all headers | View raw


If you do not have a clue what structure the XLS has, how do you want to 
read the data you need ?


H_Fidler@yahoo.com schreef op 22-12-2013 9:15:
> I try to open and read few excel files:
> H11_ is the prefix when I set up the OLE control "Microsoft Office Spreadsheet 11.0"
>
>     oExcel := OLEAutoObject{"Excel.Application.11"}
>     oExcel:Visible := true
>    	
>     oBooks:=H11_Workbooks{oExcel:WorkBooks }
>     oBooks:Open("C:\Schmuck\eBay\eBay 15    28.10.xls")
>     oBooks:Open("C:\Schmuck\eBay\eBay 14 28.10.xls")
>
>     oBook   := H11_Workbook{oBooks:[Item,2]}
>     oSheets := H11_Worksheets{oBook:Worksheets}   //  ERROR in Function WorkSheets
>                                                       member not found.
>
> 1. How can I know how many oBook are there in oBooks?
>     oBooks:Count  does not return.
>
>
> 2. How to build oSheets? How many oSheet are there in oSheets?
>
> 3. Where can I see the class structure?
>
> Many thanks
> Henry
>

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Read Excel file H_Fidler@yahoo.com - 2013-12-22 00:15 -0800
  Re: Read Excel file George Tritsos <GeorgeTritsos@yahoo.gr> - 2013-12-22 05:53 -0800
  Re: Read Excel file JohnMartens <martens@tennishulp.info> - 2013-12-22 17:49 +0100
  Re: Read Excel file Carlos Rocha <FreeTheMusic@ascap.com> - 2013-12-22 19:22 +0000

csiph-web