Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #6445
| 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> |
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
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