MATLAB
®
Builder for Excel
®
TheLanguageofTechnicalComputing
Computation
Visualization
Programming
User’sGuide
Version1
Convert pdf to searchable text online - software SDK dll:C# PDF Convert to Text SDK: Convert PDF to txt files in C#.net, ASP.NET MVC, WinForms, WPF application
C# PDF to Text (TXT) Converting Library to Convert PDF to Text
www.rasteredge.com
Convert pdf to searchable text online - software SDK dll:VB.NET PDF Convert to Text SDK: Convert PDF to txt files in vb.net, ASP.NET MVC, WinForms, WPF application
VB.NET Guide and Sample Codes to Convert PDF to Text in .NET Project
www.rasteredge.com
How to ContactTheMathWorks
www.mathworks.com
Web
comp.soft-sys.matlab
Newsgroup
www.mathworks.com/contact_TS.html
TechnicalSupport
suggest@mathworks.com
Productenhancementsuggestions
bugs@mathworks.com
Bugreports
doc@mathworks.com
Documentationerrorreports
service@mathworks.com
Orderstatus,licenserenewals,passcodes
info@mathworks.com
Sales,pricing,andgeneralinformation
508-647-7000(Phone)
508-647-7001(Fax)
TheMathWorks,Inc.
3AppleHillDrive
Natick,MA01760-2098
Forcontactinformationaboutworldwideoffices,seetheMathWorksWebsite.
MATLABBuilderforExcelUser’sGuide
©COPYRIGHT1984–2006TheMathWorks,Inc.
Thesoftwaredescribedinthisdocumentisfurnishedunderalicenseagreement. Thesoftwaremaybeused
orcopiedonlyunderthetermsofthelicenseagreement. Nopartofthismanualmaybephotocopiedor
reproducedinanyformwithoutpriorwrittenconsentfromTheMathWorks,Inc.
FEDERALACQUISITION:ThisprovisionappliestoallacquisitionsoftheProgramandDocumentation
by,for,orthroughthefederalgovernmentoftheUnitedStates. ByacceptingdeliveryoftheProgramor
Documentation,thegovernmentherebyagreesthatthissoftwareordocumentationqualifiesascommercial
computersoftwareorcommercialcomputersoftwaredocumentationassuchtermsareusedordefined
inFAR12.212,DFARSPart227.72,andDFARS252.227-7014. Accordingly,thetermsandconditionsof
thisAgreementandonlythoserightsspecifiedinthisAgreement,shallpertaintoandgoverntheuse,
modification,reproduction,release,performance,display,anddisclosureoftheProgramandDocumentation
bythefederalgovernment(orotherentityacquiringfororthroughthefederalgovernment)andshall
supersedeanyconflictingcontractualtermsorconditions. IfthisLicensefailstomeetthegovernment’s
needsorisinconsistentinanyrespectwithfederalprocurementlaw,thegovernmentagreestoreturnthe
ProgramandDocumentation,unused,toTheMathWorks,Inc.
Trademarks
MATLAB,Simulink,Stateflow,HandleGraphics,Real-TimeWorkshop,andxPCTargetBox
areregisteredtrademarks,andSimBiology,SimEvents,andSimHydraulicsaretrademarksof
TheMathWorks,Inc.
Otherproductorbrandnamesaretrademarksorregisteredtrademarksoftheirrespective
holders.
Patents
TheMathWorksproductsareprotectedbyoneormoreU.S.patents. Pleasesee
www.mathworks.com/patents
formoreinformation.
software SDK dll:Online Convert PDF to Text file. Best free online PDF txt
convert PDF document to editable & searchable text file text converter control toolkit can convert PDF document to Download and try RasterEdge.XDoc.PDF for .NET
www.rasteredge.com
software SDK dll:VB.NET Image: Robust OCR Recognition SDK for VB.NET, .NET Image
more companies are trying to convert printed business on artificial intelligence to extract text from documents will be outputted as searchable PDF, PDF/A,TXT
www.rasteredge.com
RevisionHistory
December2001
Onlineonly
NewforVersion1.0
July2002
Firstprinting
RevisedforVersion1.1(Release13)
June2004
Onlineonly
RevisedforVersion1.2(Release14)Namechangedfrom
MATLABExcelBuilder
August2004
Onlineonly
RevisedforVersion1.2.1(Release14+)
October2004
Onlineonly
RevisedforVersion1.2.2(Release14SP1)
September2005 Onlineonly
RevisedforVersion1.2.5(Release14SP3)
March2006
Onlineonly
RevisedforVersion1.2.6(Release2006a)
September2006 Onlineonly
RevisedforVersion1.2.7(Release2006b)
software SDK dll:C# Create PDF Library SDK to convert PDF from other file formats
PDF document file created by RasterEdge C# PDF document creator library is searchable and can be fully populated with editable text and graphics
www.rasteredge.com
software SDK dll:VB.NET PDF Convert to HTML SDK: Convert PDF to html files in vb.
Why do we need to convert PDF document to HTML webpage One is that compared with HTML file, PDF file (a not be easily edited), is less searchable for search
www.rasteredge.com
software SDK dll:VB.NET PDF Convert to Word SDK: Convert PDF to Word library in vb.
Word documents from both scanned PDF and searchable PDF files without Convert PDF document to DOC and DOCX formats in to export Word from multiple PDF files in
www.rasteredge.com
software SDK dll:C# PDF: C# Code to Draw Text and Graphics on PDF Document
This online guide content is Out Dated! Draw and write searchable text on PDF file by C# code in both Web and Windows applications.
www.rasteredge.com
Contents
GettingStarted
1
WhatIsMATLABBuilderforExcel?
.................
1-2
ComponentNamingConventions
.....................
1-2
BuildingaDeployableApplication
..................
1-4
CreatingandBuildingaComponent
..................
1-4
UsingthemccCommandtoBuildaComponent
.........
1-6
TestingtheComponent
.............................
1-7
DeployingtheComponent
..........................
1-8
PackagingandDistributingtheComponent
............
1-8
ProgrammingwithMATLABBuilderforExcel
2
OverviewoftheIntegrationProcess
................
2-2
WhentoUseaFormulaFunctionoraSubroutine
....
2-3
InitializingMATLABBuilderforExcelLibrarieswith
Excel
...........................................
2-4
CreatinganInstanceofaClass
.....................
2-6
CreateObjectFunction
.............................
2-6
NewOperator
....................................
2-6
HowtheMCRIsSharedAmongClasses
...............
2-8
CallingtheMethodsofaClassInstance
..............
2-9
ProcessingvararginandvarargoutArguments
.......
2-11
v
software SDK dll:C# HTML5 Viewer: Load, View, Convert, Annotate and Edit Word
C# users can convert Convert Microsoft Office Word to searchable PDF online, create multi to add annotations to Word, such as add text annotations to
www.rasteredge.com
software SDK dll:C# PDF Convert to HTML SDK: Convert PDF to html files in C#.net
library also makes PDF document visible and searchable on the Internet by converting PDF document file to Use C#.NET Demo Code to Convert PDF Document to
www.rasteredge.com
HandlingErrorsDuringaMethodCall
..............
2-13
ModifyingFlags
...................................
2-14
ArrayFormattingFlags
............................
2-14
DataConversionFlags
.............................
2-16
UsageExamples
3
MagicSquareExamples
............................
3-2
CreatingtheProject
...............................
3-2
AddingtheExcelBuilderCOMFunctiontoExcel
.......
3-3
Illustration1.OutputMagicSquareResultstoExcel
....
3-3
Illustration2.TransposetheOutput
..................
3-4
Illustration3.ResizetheOutput
.....................
3-4
InspectingtheVisualBasicCode
.....................
3-5
MultipleFilesandVariableArgumentsExample
.....
3-6
CreatingtheProject
...............................
3-6
AddingtheExcelBuilderCOMFunctiontoExcel
.......
3-7
Illustration4:Callingmyplot
........................
3-8
Illustration5:CallingmysumFourDifferentWays
......
3-9
Illustration6:myprimesMacro
......................
3-10
InspectingtheVisualBasicCode
.....................
3-12
SpectralAnalysisExample
.........................
3-13
BuildingtheComponent
............................
3-13
IntegratingtheComponentUsingVBA
................
3-15
TestingtheAdd-In
................................
3-27
PackagingandDistributingtheAdd-In
................
3-29
FunctionWizard
4
OverviewoftheFunctionWizard
...................
4-2
vi
Contents
InstallingtheFunctionWizardAdd-In
...............
4-3
StartingtheFunctionWizard
.......................
4-4
UnderstandingtheFunctionViewer
................
4-5
UsingtheFunctionViewer
..........................
4-5
LoadingandExecutingFunctions
....................
4-5
ComponentBrowser
...............................
4-7
FunctionProperties
...............................
4-8
EditingFunctionArguments
........................
4-8
ArgumentProperties
..............................
4-12
InputArgumentPropertiesDialogBox
................
4-12
OutputArgumentPropertiesDialogBox
..............
4-13
FunctionUtilities
..................................
4-14
RenameFunctionDialogBox
........................
4-14
CopyFunctionDialogBox
..........................
4-14
MoveFunctionDialogBox
..........................
4-15
Functions—AlphabeticalList
5
ProducingaCOMObjectfromMATLAB
A
OverviewofInternalProcesses
.....................
A-2
CodeGeneration
..................................
A-3
InterfaceDefinitionCreation
........................
A-3
C++Compilation
..................................
A-4
LinkingandResourceBinding
.......................
A-4
ComponentRegistration
............................
A-4
vii
ComponentRegistration
...........................
A-5
ObtainingRegistryInformation
......................
A-5
Self-RegisteringComponents
........................
A-7
GloballyUniqueIdentifier(GUID)
...................
A-8
Versioning
.......................................
A-9
CallingConventions
...............................
A-11
ProducingaCOMClass
............................
A-11
IDLMapping
.....................................
A-11
VisualBasicMapping
..............................
A-12
MATLABCompilerOutput
.........................
A-13
DataConversion
B
DataConversionRules
.............................
B-2
ArrayFormattingFlags
............................
B-12
DataConversionFlags
.............................
B-14
CoerceNumericToType
.............................
B-14
InputDateFormat
.................................
B-15
OutputAsDateAsBoolean
..........................
B-16
DateBiasAsLong
.................................
B-16
UtilityLibrary
C
ReferencingUtilityClasses
.........................
C-2
UtilityLibraryClasses
.............................
C-3
ClassMWUtil
....................................
C-3
ClassMWFlags
...................................
C-10
ClassMWStruct
..................................
C-16
ClassMWField
...................................
C-24
ClassMWComplex
................................
C-25
viii
Contents
ClassMWSparse
..................................
C-27
ClassMWArg
.....................................
C-30
Enumerations
.....................................
C-32
EnummwArrayFormat
.............................
C-32
EnummwDataType
...............................
C-32
EnummwDateFormat
.............................
C-33
Troubleshooting
D
Examples
E
CallingaMATLABFunctionfromExcel
.............
E-2
UsingMultipleFilesandVariableArguments
........
E-2
CreatingaComprehensiveExcelAdd-In: Spectral
Analysis
........................................
E-2
QueryingtheRegistry
.............................
E-2
Index
ix
x
Contents
Documents you may be interested
Documents you may be interested