Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Thu Sep 19, 2019 7:55 am
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: Excel Methods, A example for each one of them
PostPosted: Thu Jun 07, 2012 10:58 pm 
Offline
User avatar

Joined: Thu Dec 29, 2011 6:46 pm
Posts: 191
Location: Edmonton, AB, Canada
Quote:
A journey of a thousand miles begins with a single step.
Lao-tzu, The Way of Lao-tzu


I did Screenshot and OCR all the methods below, because the Rb documentation do not have them listed.
Lets create a example for each one of them...

1 Excel.ExcelAddIn
2 Excel.ExcelAddIns
3 Excel.ExcelAdjustments
4 Excel.ExcelApplication
5 Excel.ExcelArc
6 Excel.ExcelArcs
7 Excel.ExcelAreas
8 Excel.ExcelAutoCorrect
9 Excel.ExcelAutoFilter
10 Excel.ExcelAxes
11 Excel.ExcelAxis
12 Excel.ExcelAxisTitle
13 Excel.ExcelBorder
14 Excel.ExcelBorders
15 Excel.ExcelButton
16 Excel.ExcelButtons
17 Excel.ExcelCalculatedFields
18 Excel.ExcelCalculatedItems
19 Excel.ExcelCalloutFormat
20 Excel.ExcelCharacters
21 Excel.ExcelChart
22 Excel.ExcelChartArea
23 Excel.ExcelChartColorFormat
24 Excel.ExcelChartFillFormat
25 Excel.ExcelChartGroup
26 Excel.ExcelChartGroups
27 Excel.ExcelChartObject
28 Excel.ExcelChartObjects
29 Excel.ExcelCharts
30 Excel.ExcelChartTitle
31 Excel.ExcelCheckBox
32 Excel.ExcelCheckBoxes
33 Excel.ExcelColorFormat
34 Excel.ExcelColorComment
35 Excel.ExcelColorComments
36 Excel.ExcelConnectorFormat
37 Excel.ExcelControlFormat
38 Excel.ExcelCorners
39 Excel.ExcelCubeFields
40 Excel.ExcelCustomView
41 Excel.ExcelCustomViews
42 Excel.ExcelDataLabel
43 Excel.ExcelDataLabels
44 Excel.ExcelDataTable
45 Excel.ExcelDefaultWebOptions
46 Excel.ExcelDialog
47 Excel.ExcelDialogFrame
48 Excel.ExcelDialogs
49 Excel.ExcelDialogSheet
50 Excel.ExcelDialogSheets
51 Excel.ExcelDisplayUnitLable
52 Excel.ExcelDownBars
53 Excel.ExcelDrawing
54 Excel.ExcelDrawingObjects
55 Excel.ExcelDrawings
56 Excel.ExcelDropDown
57 Excel.ExcelDropDowns
58 Excel.ExcelDropLines
59 Excel.ExcelEditBox
60 Excel.ExcelEditBoxes
61 Excel.ExcelErrorBars
62 Excel.ExcelFillFormat
63 Excel.ExcelFilter
64 Excel.ExcelFilters
65 Excel.ExcelFloor
66 Excel.ExcelFont
67 Excel.ExcelFormatCondition
68 Excel.ExcelFormatConditions
69 Excel.ExcelFreeformBuilder
70 Excel.ExcelGlobal
71 Excel.ExcelGridlines
72 Excel.ExcelGroupBox
73 Excel.ExcelGroupBoxes
74 Excel.ExcelGroupObject
75 Excel.ExcelGroupObjects
76 Excel.ExcelGroupShapes
77 Excel.ExcelHiloLines
78 Excel.ExceIHPageBreak
79 Excel.ExceIHPageBreaks
80 Excel.ExcelHyperlink
81 Excel.ExcelHyperlinks
82 Excel.ExcellAddln
83 Excel.ExcellAddIns
84 Excel.ExcellAppEvents
85 Excel.ExcellArc
86 Excel.Excel1Arcs
87 Excel.ExcellAreas
88 Excel.ExcellAutoCorrect
89 Excel.ExcellAutoFilter
90 Excel.ExcellAxes
91 Excel.ExcellAxis
92 Excel.ExcelIAxisTitle
93 Excel.ExcellBorder
94 Excel.ExcellBorders
95 Excel.ExcellButton
96 Excel.ExcellButtons
97 Excel.ExcellCalculatedFields
98 Excel.ExcellCalculatedltems
99 Excel.ExcellCharacters
100 Excel.ExcellChartArea
101 Excel.ExcellChartColorFormat
102 Excel.ExcellChartEvents
103 Excel.ExcellChartFillFormat
104 Excel.ExcellChartGroup
105 Excel.ExcellChartGroups
106 Excel.ExcellChartObject
107 Excel.ExcellChartObjects
108 Excel.ExcellCharts
109 Excel.ExcellChartTitle
110 Excel.ExcellCheckBox
111 Excel.ExcellCheckBoxes
112 Excel.ExcellComment
113 Excel.ExcellComments
114 Excel.ExcellConnectorFormat
115 Excel.ExcellControlFormat
116 Excel.ExcellCorners
117 Excel.ExcellCustomView
118 Excel.ExcellCustomViews
119 Excel.ExcellOataLabel
120 Excel.ExcellOatalabels
121 Excel.ExcellOataTable
122 Excel.ExcellOialog
123 Excel.ExcellOialogFrame
124 Excel.ExcellOialogs
125 Excel.ExcellOialogSheet
126 Excel.ExcellOialogSheets
127 Excel.ExcellOisplayUnitLabel
128 Excel.ExcellOocEvents
129 Excel.ExcellOownBars
130 Excel.ExcellOrawing
131 Excel.ExcellOrawingObjects
132 Excel.ExcellOrawings
133 Excel.ExcellOropDown
134 Excel.ExcellOropDowns
135 Excel.ExcellOropLines
136 Excel.ExcellOummy
137 Excel.ExcellEditBox
138 Excel.ExcellEditBoxes
139 Excel.ExcellErrorBars
140 Excel.ExcellFilter
141 Excel.ExcellFilters
142 Excel.ExcellFloor
143 Excel.Excel]Font
144 Excel.ExcellFormatCondition
145 Excel.ExcellFormatConditions
146 Excel.ExcellFreeformBuilder
147 Excel.ExcellGridlines
148 Excel.ExcellGroupBox
149 Excel.ExcellGroupBoxes
150 Excel.ExcellGroupObject
151 Excel.ExcellGroupObjects
152 Excel.ExcellGroupShapes
153 Excel.ExcellHiLoLines
154 Excel.Excel1HPagareak
155 Excel.Excel1HPagareaks
156 Excel.ExcellHyperlink
157 Excel.ExcellHyperlinks
158 Excel.ExcelIinterior
159 Excel.Excellabel
160 Excel.Excellabels
161 Excel.ExcelleaderLines
162 Excel.Excellegend
163 Excel.ExcellegendEntries
164 Excel.ExcellegendEntry
165 Excel.ExcellLegendKey
166 Excel.ExcellLine
167 Excel.ExcellLines
168 Excel.ExcellinkFormat
169 Excel.ExcellistBox
170 Excel.ExcellistBoxes
171 Excel.Excel]Mailer
172 Excel.ExcellMenu
173 Excel.ExcellIvienuBar
174 Excel.ExcellIvienuBars
175 Excel.ExcellMenuItem
176 Excel.ExcellMenultems
177 Excel.ExcellMenus
178 Excel.ExcellIviodule
179 Excel.ExcellModules
180 Excel.ExcellName
181 Excel.Excel]Names
182 Excel.ExcelInterior
183 Excel.Excell0DBCError
184 Excel.Excell0DBCErrors
185 Excel.ExcellOLE0BError
186 Excel.ExcellOLEDBErrors
187 Excel.ExcellOLEFormat
188 Excel.ExcellOLEObject
189 Excel.ExcellOLEObjectEvents
190 Excel.ExcellOLEObjects
191 Excel.ExcellOptionButton
192 Excel.ExcellOptionButtons
193 Excel.ExcellOutline
194 Excel.ExcellOval
195 Excel.ExcellOvals
196 Excel.ExcellPageSetup
197 Excel.ExcellPane
198 Excel.ExcellPanes
199 Excel.ExcellParameter
200 Excel.ExcellParameters
201 Excel.ExcellPhonetic
202 Excel.ExcellPhonetics
203 Excel.ExcellPicture
204 Excel.Excel]Pictures
205 Excel.ExcellPivotCache
206 Excel.ExcellPivotCaches
207 Excel.ExcellPivotField
208 Excel.ExcellPivotFields
209 Excel.ExcellPivotFormula
210 Excel.ExcellPivotFormulas
211 Excel.ExcellPivotItem
212 Excel.ExcelPivotItems
213 Excel.ExcelPivotLayout
214 Excel.ExcelPivotTable
215 Excel.ExcelPivotTables
216 Excel.ExcelPlotArea
217 Excel.ExcelPoint
218 Excel.ExcelPoints
219 Excel.ExcelPublishObject
220 Excel.ExcelPublishObjects
221 Excel.ExcelQueryTable
222 Excel.ExcelQueryTables
223 Excel.ExcelRange
224 Excel.ExcelRecentFile
225 Excel.ExcelRecentFiles
226 Excel.ExcelRectangle
227 Excel.ExcelRectangles
228 Excel.ExcelRoutingSlip
229 Excel.ExcelScenario
230 Excel.ExcelScenarios
231 Excel.ExcelScrollBar
232 Excel.ExcelScrollBars
233 Excel.ExcelSeries
234 Excel.ExcelSeriesCollection
235 Excel.ExcelSeriesLines
236 Excel.ExcelShadowFormat
237 Excel.ExcelShape
238 Excel.ExcelShapeNode
239 Excel.ExcelShapeNodes
240 Excel.ExcelShapeRange
241 Excel.ExcelShapes
242 Excel.ExcelSheets
243 Excel.ExcelSoundNote
244 Excel.ExcelSpinner
245 Excel.ExcelSpinners
246 Excel.ExcelStyle
247 Excel.ExcelStyles
248 Excel.ExcelTextBox
249 Excel.ExcelTextBoxes
250 Excel.ExcelTextEffectFormat
251 Excel.ExcelTextFrame
252 Excel.ExcelThree0Format
253 Excel.ExcelTickLabels
254 Excel.ExcelToolbar
255 Excel.ExcelToolbarButton
256 Excel.ExcelToolbarButtons
257 Excel.ExcelToolbars
258 Excel.ExcelTreeviewControl
259 Excel.ExcelTrendline
260 Excel.ExcelTrendlines
261 Excel.ExcelUpBars
262 Excel.ExcelValidation
263 Excel.ExceIVPageBreak
264 Excel.ExceIVPageBreaks
265 Excel.ExceIVPagareaks
266 Excel.Excel Walls
267 Excel.Excel WebOptions
268 Excel.Excel Window
269 Excel.ExcelWindows
270 Excel.Excel Workbook
271 Excel.ExcelWorkbooks
272 Excel.ExcelWorksheet
273 Excel.ExcelWorksheetFunction
274 Excel.ExcelWorksheets

_________________
Regards,
TomazVDaSilva


Clean Code: Robert C. Martin
It is not the language that makes programs appear simple.
It is the programmer that make the language appear simple!


Top
 Profile  
Reply with quote  
 Post subject: Re: Excel Methods, A example for each one of them
PostPosted: Fri Jun 08, 2012 12:23 am 
Offline

Joined: Mon May 30, 2011 12:56 am
Posts: 702
Quote:
the Rb documentation do not have them listed.

Mainly because Excel isn't a REAL application, nor is it really a REAL class.
It just exposes the Excel OLE model in a handy form , which you would otherwise have done by creating an OLEObject yourself.

Short of worked program examples , most of these examples would simply be

Dim ec as Excel.ExcelCharts

What you need is the object model.. which of these objects 'own' other objects, what their methods are, what the values of parameter constants are etc.

You should be able to get all you need from here:

http://msdn.microsoft.com/en-us/library ... =office.12)


Top
 Profile  
Reply with quote  
 Post subject: Re: Excel Methods, A example for each one of them
PostPosted: Fri Jun 08, 2012 6:12 am 
Offline

Joined: Mon Jan 02, 2006 11:43 am
Posts: 172
Location: Calgary, Alberta, Canada
Hello,

There is a book with many Excel examples with REALStudio that is available at http://great-white-software.com/rblibrary/index.php?main_page=product_info&cPath=2&products_id=119. The book is a live document, meaning that it is electronic and is being updated. The Table of Contents and Index can be viewed at http://www.scispec.ca/REALbasic/Publish/Publish.htm. Here is the writeup on the latest version:

Quote:
This book has been written as a guide and reference for programmers with REALStudio to program in Excel 2010. There are no plugins, dynamic link libraries (dll), COM, or Active X portions to add. The control that is packaged with REALStudio in Windows provides the functionality. This book is a live document and will be updated. There are 7 chapters, more than 180 pages, over 75 example objects with the complete code of examples such as:graphing, pivot tables, speaking in Excel, printing pages, saving Excel files to a PDF, gradients, text, styles, colors, cell formatting, interaction with an open workbook, and more. Many screenshots have been taken to show you the results of changes in code, with a full index to help you find topics and reference information.

Make sure to keep your download link if you purchase the book, as you will be able to download updates. If there is specific examples that you would like in the book, feel free to send me an email and I will add them.

Happy to help, :)

Eugene
eugenedakin at hotmail dot com
Windows 7, REALStudio 2011 r4.3


Top
 Profile  
Reply with quote  
 Post subject: Re: Excel Methods, A example for each one of them
PostPosted: Fri Jun 08, 2012 7:28 am 
Offline
User avatar

Joined: Thu Dec 29, 2011 6:46 pm
Posts: 191
Location: Edmonton, AB, Canada
kermit wrote:
Quote:
the Rb documentation do not have them listed.

Mainly because Excel isn't a REAL application, nor is it really a REAL class.
It just exposes the Excel OLE model in a handy form , which you would otherwise have done by creating an OLEObject yourself.

Short of worked program examples , most of these examples would simply be

Dim ec as Excel.ExcelCharts

What you need is the object model.. which of these objects 'own' other objects, what their methods are, what the values of parameter constants are etc.

You should be able to get all you need from here:

http://msdn.microsoft.com/en-us/library ... =office.12)


Thank for the link and idea... I am looking into object model already, but we need a example for each one in RB
If the link above is not working, I suggest :
1)
Super-Easy Guide to the Microsoft Office Excel 2003 Object Model
Frank C. Rice, Microsoft Corporation
Applies to: Microsoft® Office Excel 2003
http://msdn.microsoft.com/en-us/library/aa203714(v=office.11).aspx#odc_super_introduction

2)
Excel Object Model Map
http://office.microsoft.com/en-us/excel-help/CH080550099.aspx

3)
Understanding the Excel Object Model from a .NET Developer's Perspective
http://msdn.microsoft.com/en-us/library/aa168292(v=office.11).aspx

_________________
Regards,
TomazVDaSilva


Clean Code: Robert C. Martin
It is not the language that makes programs appear simple.
It is the programmer that make the language appear simple!


Top
 Profile  
Reply with quote  
 Post subject: Re: Excel Methods, A example for each one of them
PostPosted: Fri Jun 08, 2012 7:46 am 
Offline
User avatar

Joined: Thu Dec 29, 2011 6:46 pm
Posts: 191
Location: Edmonton, AB, Canada
eugenedakin wrote:
Hello,

There is a book with many Excel examples with REALStudio that is available at http://great-white-software.com/rblibrary/index.php?main_page=product_info&cPath=2&products_id=119. The book is a live document, meaning that it is electronic and is being updated. The Table of Contents and Index can be viewed at http://www.scispec.ca/REALbasic/Publish/Publish.htm. Here is the writeup on the latest version:

Quote:
This book has been written as a guide and reference for programmers with REALStudio to program in Excel 2010. There are no plugins, dynamic link libraries (dll), COM, or Active X portions to add. The control that is packaged with REALStudio in Windows provides the functionality. This book is a live document and will be updated. There are 7 chapters, more than 180 pages, over 75 example objects with the complete code of examples such as:graphing, pivot tables, speaking in Excel, printing pages, saving Excel files to a PDF, gradients, text, styles, colors, cell formatting, interaction with an open workbook, and more. Many screenshots have been taken to show you the results of changes in code, with a full index to help you find topics and reference information.

Make sure to keep your download link if you purchase the book, as you will be able to download updates. If there is specific examples that you would like in the book, feel free to send me an email and I will add them.

Happy to help, :)

Eugene
eugenedakin at hotmail dot com
Windows 7, REALStudio 2011 r4.3


Thank you!

I will not buy just yet... not because of the price, but because the principle behind.
This is the kind of information that RB documentation should have...for free.

The link : http://www.scispec.ca/REALbasic/Publish/Publish.htm
Is not working, do you have a valid link, I still would like to see the TOC of the book.

_________________
Regards,
TomazVDaSilva


Clean Code: Robert C. Martin
It is not the language that makes programs appear simple.
It is the programmer that make the language appear simple!


Top
 Profile  
Reply with quote  
 Post subject: Re: Excel Methods, A example for each one of them
PostPosted: Fri Jun 08, 2012 7:54 am 
Offline

Joined: Wed May 20, 2009 4:43 pm
Posts: 958
TomazVDaSilva wrote:
I will not buy just yet... not because of the price, but because the principle behind.
This is the kind of information that RB documentation should have...for free.

As was stated before, the RB documentation does not include this because Excel is not an application created by REAL, that documentation is provided by Microsoft. From the LR:
Quote:
The language that you use to automate Microsoft Office applications is documented by Microsoft and numerous third-party books on Visual Basic for Applications (VBA). Microsoft Office applications provide online help for VBA. This is your primary reference for Real Studio office automation. In Office 2007, click the Microsoft Office button and then click Options. Then select Popular and select the Show Developer Tab in the Ribbon checkbox.

_________________
RB 2009r4 Windows XP


Top
 Profile  
Reply with quote  
 Post subject: Re: Excel Methods, A example for each one of them
PostPosted: Fri Jun 08, 2012 8:04 am 
Offline
User avatar

Joined: Thu Dec 29, 2011 6:46 pm
Posts: 191
Location: Edmonton, AB, Canada
markwalsh wrote:
TomazVDaSilva wrote:
I will not buy just yet... not because of the price, but because the principle behind.
This is the kind of information that RB documentation should have...for free.

As was stated before, the RB documentation does not include this because Excel is not an application created by REAL, that documentation is provided by Microsoft. From the LR:
Quote:
The language that you use to automate Microsoft Office applications is documented by Microsoft and numerous third-party books on Visual Basic for Applications (VBA). Microsoft Office applications provide online help for VBA. This is your primary reference for Real Studio office automation. In Office 2007, click the Microsoft Office button and then click Options. Then select Popular and select the Show Developer Tab in the Ribbon checkbox.


Pay attention, I don't want MS documentation under RB software documentation...
I want examples of RB functionality controlling MS Excel.

Are you saying eugenedakin reinvent the wheel by writing the book mentioned above ?
Or Monkey(..) shouldn't reinvent as well, creating classes for the same purpose ?

People talk to much, but I have not seen any example...
It seems that I have to create the examples by myself and start selling instead of sharing, just like others are doing.

_________________
Regards,
TomazVDaSilva


Clean Code: Robert C. Martin
It is not the language that makes programs appear simple.
It is the programmer that make the language appear simple!


Top
 Profile  
Reply with quote  
 Post subject: Re: Excel Methods, A example for each one of them
PostPosted: Fri Jun 08, 2012 9:54 am 
Offline
Real Software Engineer

Joined: Sat Dec 24, 2005 8:18 pm
Posts: 7858
Location: Canada, Alberta, Near Red Deer
TomazVDaSilva wrote:
Pay attention, I don't want MS documentation under RB software documentation...

But that is what you've asked for when you say you want an example for every one of the methods exposed by the Excel OLE object.
The MS references are the definitive source on how to use those objects.

We don't provide full documentation for how to use PostgreSQL, mySQL, etc for the same reason
We document the methods we provide & refer you to the vendors site for anything unique to that vendors tools / classes.

_________________
Norman Palardy (Real Software)


Top
 Profile  
Reply with quote  
 Post subject: Re: Excel Methods, A example for each one of them
PostPosted: Fri Jun 08, 2012 10:23 am 
Offline

Joined: Mon May 30, 2011 12:56 am
Posts: 702
http://msdn.microsoft.com/en-us/library ... =office.12)

.. some of the link was missing, and edit seems to have stopped working again.


Top
 Profile  
Reply with quote  
 Post subject: Re: Excel Methods, A example for each one of them
PostPosted: Fri Jun 08, 2012 10:51 am 
Offline
User avatar

Joined: Thu Dec 29, 2011 6:46 pm
Posts: 191
Location: Edmonton, AB, Canada
npalardy wrote:
But that is what you've asked for when you say you want an example for every one of the methods exposed by the Excel OLE object.
The MS references are the definitive source on how to use those objects.

We don't provide full documentation for how to use PostgreSQL, mySQL, etc for the same reason
We document the methods we provide & refer you to the vendors site for anything unique to that vendors tools / classes.


npalardy, you again...

Ok, I have many clients as well in the field of work I perform which is not programming.
When my clients come to me with questions I don't say "look for it in someplace else",
I do not assume that I know what they want, I ask for details of what they want and try to provide some alternatives...

I don't say I don't do this I don't do that...
I do prefer say what I can do, instead of what I can't.

Don't worry I have provide already a example for:

Open a specific Excel File
Open a new Excel File
SavaAs a Excel File
Etc.

To create those examples is very easy for a experienced programmer, not for me.
In the Feedback tool I asked for 3 things Open, SaveAs, and Close... And I had the same kind of lecture.

As I proceed investigating RB software, will provide examples for each one of the other methods, I am not afraid of share.
If you don't have, don't know, don't want, stop trying to make a point to show yourself superior and try to help instead.

I will not invest my time with this discussion anymore, words can deceive but examples construct future.

_________________
Regards,
TomazVDaSilva


Clean Code: Robert C. Martin
It is not the language that makes programs appear simple.
It is the programmer that make the language appear simple!


Top
 Profile  
Reply with quote  
 Post subject: Re: Excel Methods, A example for each one of them
PostPosted: Sun Jun 17, 2012 4:46 pm 
Offline

Joined: Mon Jan 02, 2006 11:43 am
Posts: 172
Location: Calgary, Alberta, Canada
I updated the link to reflect the legal name of Realbasic, not REALbasic.

Here is the new link to the Authors Website:http://www.scispec.ca/Realbasic/Publish/Publish.htm

Sincerely,

Eugene


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group