Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Downloads
Add
Search: 
Search

Rep2Excel Exporting/Writing/Reporting to Excel
Srdjan Djordjevic, Independent
VFP/EXCEL Ole Automation class that let's you manipulate Excel file as 3D array. Broad set of calls for common automation tasks. Writing is as easy as oXL.make_cell(1,1,5,'Hi There'). Also Generic Reporting Class - for writing structured grouped reports via code directly to excel or any other available Output. Works like FRX engine but is in code. Recursive - Unlimited number of groups. Source and samples included. Added: -Silent mode for supressing messages -Insert Picture Wrapper -Start from template file -More Documentation
Created on
21 years ago
Downloads
5172
File type
Rating
4.67/5.00
General information
URL:
rep2excel.zip
Rating:
4.67/5.00 (3 rates) Rate this item
Description
A) VFP/EXCEL Automation class ----------------------------- Idea is simple - Manipulating Excel file as 3D array. There4 I made all bunch of wrapper methods for common automation calls joined in one code based class, so I/O having to use Cumbersome Excel constructions like oExcel.ActiveSheet...do whatewer ; All came down to simple instructions like oXL.make_cell(nSheet,nRow,nCol,'Hello World') oXL.draw_box(i,j,k,l) oXL.l_v_single(i,j,k,j) (Line/Vertical/Single) etc. Also data writing is available as easy as; oXL.table_in_section(i,j,k,cAlias,cFieldsIWant) oXL.table_in_row(i,j,k,cAlias,cFieldsIWant) oXL.array_in_section(i,j,k,@myArray) oXL.insert_picture(i,j,k,cFileName) (New) And many many more (See Samples). Ideal tool for those who don't mind coding - You can do anything you want with Excel file. B) Reporting to Excel ------------------------------------- Being that I was writing in the past (DOS) fully structured Code based reports and having report designer (FRX) in mind, I created generic reporting class, that works pretty much similar to FRX data engine, having in the same time all flexibility of Old code based reports, and more over, being a class - subclassing prospect. It is structured grouped report with virtualy unlimited number of groups since is based on recursive mechanism. So in the pretty similar manner that you would define group in report designer and then add expressions in header/footer/detail band, using this class you can define grouping by assigning couple of properties in the report (sub)class and then write into respective header(i)/footer(i)/detail - place holder method(s). Class by itself is generic and is covering only essential data flow of a report structure without going into output specific details like printer handling, paging etc. There4 can be used and/or customized for any type of 'Output'. In this case I customised it to work with Excel OLE automation class because this is why I wrote it at first place - but it can easily report directly to the printer or text file using ?/?? Commands or ANY OTHER format depends on availability (HTML, WORD, PDF etc.) No wizards/graphs yet, but we will come to it.
Created by
Srdjan Djordjevic, Independent
Djordjevic Srdjan is Senior FoxPro developer with over 30 years of experience. Independent.

Comments
Add a comment
More downloads created from this member
Report Sculptor Foundation - Version 1.00
Srdjan Djordjevic, Independent
Report Sculptor is free Reporting Framework for VFP9. It features Visual OOP Reporting, WYSWYG FreePages Design, Scripting, SmartText(*), Replication of native VFP controls on report surface, FRX Interpreter, Fast Export to PDF and much more. ***NEW*** New version brings Live Report Preview S...
Created on
16 years ago
Downloads
4066
File type
Freeware
Rating
4.60/5.00
XDIR Recursive Directory Scan
Srdjan Djordjevic, Independent
Class effectively scans drives/directory, firing an event/methods for each subdirectory and file within. Using this class, you can do variety of directory/files processing tasks. Freeware/Source/Samples Included. Check out; Mass FRX CleanUp, Folder Preview/Print, File Search, XCopy etc.
Created on
19 years ago
Downloads
3291
File type
Freeware
Rating
5.00/5.00
CodeRep
Srdjan Djordjevic, Independent
Fully OOP Reports in code. Class/Subclasses for writing reports in CODE to any available output. Write your reports as reusable subclasses, or just add some reporting directly to your forms. Subclasses with report samples provided for XLS,PDF,HTML,TXT output formats. No odd results - it is code & yo...
Created on
20 years ago
Downloads
4400
File type
Freeware
Rating
4.50/5.00