1
GettingStarted
WhatIsMATLABBuilderforExcel?
(p.1-2)
Briefdescriptionoftheproduct
BuildingaDeployableApplication
(p.1-4)
Describesthestepstocreateand
deployanapplication
Add two pdf files together - Merge, append PDF files in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Provide C# Demo Codes for Merging and Appending PDF Document
pdf mail merge; .net merge pdf files
Add two pdf files together - VB.NET PDF File Merge Library: Merge, append PDF files in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
VB.NET Guide and Sample Codes to Merge PDF Documents in .NET Project
add pdf together; attach pdf to mail merge
1
GettingStarted
WhatIsMATLABBuilderforExcel?
MATLAB®BuilderforExcel® (alsocalledExcelBuilder)isanextensiontothe
MATLABCompiler.YouuseExcelBuildertopackageMATLABfunctionsso
thatMicrosoftExceluserscanaccessthemfromExcel.
ExcelBuilderconvertsMATLABM-functionstomethodsofaclassthatyou
define. Fromthisclass,ExcelBuildercreatescomponents. ExcelBuilder
componentsareCOMobjectsthatareaccessiblefromMicrosoftExcelthrough
VisualBasicforApplications(VBA).
COMisanacronymforComponentObjectModel,whichisaMicrosoft
binarystandardforobjectinteroperability.COMcomponentsuseacommon
integrationarchitecturethatprovidesaconsistentmodelacrossmultiple
applications.AllMicrosoftOfficeXPapplicationssupportCOMadd-ins.
EachCOMobjectexposesaclasstotheVisualBasicprogramming
environment. Theclasscontainsasetoffunctionscalledmethods. These
methodscorrespondtotheoriginalMATLABfunctionsincludedinthe
component’sproject.TheCOMcomponentscreatedbyExcelBuildercontain
oneormoreclasses,andeachclassprovidesaninterfacetotheM-functions
thatyouaddtotheclassatbuildtime.TheCOMcomponentprovidesasetof
methodsthatwraptheM-codealongwithaDLLfile.
NoteCurrently,ExcelBuildercomponentssupportoneclasspercomponent.
Whenyoupackageanddistributeanapplicationthatusesyourcomponent,
youmustincludesupportingfilesgeneratedbyExcelBuilderaswellasthe
MATLABComponentRuntime(MCR).
ComponentNamingConventions
Whencreatingacomponent,youmustadditionallyprovideaclassname.The
componentnamerepresentsthenameoftheDynamicLoadLibrary(DLL)file
tobecreated.Theclassnamedenotesthenameoftheclassthatperformsa
callonaspecificmethodatruntime. Therelationshipbetweencomponent
1-2
C# Word - Merge Word Documents in C#.NET
SDK empowers C# programmers to easily merge and append Word files with mature To be more specific, two or more input Word documents can be merged Add references
acrobat combine pdf files; acrobat combine pdf
C# PowerPoint - Merge PowerPoint Documents in C#.NET
To be more specific, two or more input PowerPoint documents C# DLLs: Merge PowerPoint Files. Add necessary XDoc.PowerPoint DLL libraries into your created C#
pdf merge files; merge pdf files
WhatIsMATLABBuilderforExcel?
nameandclassname,andwhichmethods(MATLABfunctions)gointoa
particularclass,arepurelyorganizational.
Asageneralrule,whencompilingmanyMATLABfunctions,ithelpsto
determineaschemeoffunctioncategoriesandtocreateaseparateclassfor
eachcategory. Thenameofeachclassshoulddescribewhattheclassdoes.
Organizingrelatedfunctionsintoclassesinthiswayreducestheamountof
codetorebuildandredeploywhenonefunctionischanged.
1-3
VB.NET Word: How to Process MS Word in VB.NET Library in .NET
corresponding online tutorial on how to add & insert application in VB.NET to merge two or a imaging controls, PDF document, image to pdf files and components
batch pdf merger; pdf merger online
C# PowerPoint: C# Codes to Combine & Split PowerPoint Documents
String doc in dirs) { docList.Add(doc); } PPTXDocument can split a PowerPoint document into two sub-documents & profession imaging controls, PDF document, tiff
pdf combine two pages into one; add pdf files together online
1
GettingStarted
BuildingaDeployableApplication
UsingMATLABBuilderforExceltocreateadeployableapplicationrequires
thefollowingsteps:
• “CreatingandBuildingaComponent”onpage1-4
• “UsingthemccCommandtoBuildaComponent”onpage1-6
• “TestingtheComponent”onpage1-7
• “DeployingtheComponent”onpage1-8
• “PackagingandDistributingtheComponent”onpage1-8
CreatingandBuildingaComponent
TouseMATLABBuilderforExceltobuildacomponent,followthisprocedure:
1
Ifyouhavenotalreadydoneso,enterthefollowingMATLABcommand
atthecommandline:
mbuild -setup
Besuretochooseasupportedcompiler. SeeSupportedCompilersat
http://www.mathworks.com/support/tech-notes/1600/1601.shtml
.
2
Enterthefollo
wingMATLABcommandatthecommandline:
deploytool
MATLABopensth
eDeploymentTooldialogbox,showninthefollowing
figure.
1-4
VB.NET Word: .NET Project for Merging Two or More Microsoft Word
Support to add or delete pages from a Word dll and RasterEdge.Imaging.MSWordDocx. dll two dlls are controls, PDF document, image to pdf files and components for
batch combine pdf; merge pdf online
C# Excel - Merge Excel Documents in C#.NET
To be more specific, two or more input Excel documents can be merged and appended together according to its C# DLLs: Merge Excel Files. Add necessary references
attach pdf to mail merge in word; combine pdf
BuildingaDeployableApplication
3
CreateanewprojectbyclickingtheNewProjectbutton
inthetoolbar.
4
AddfilesthatyouwanttoencapsulatebydraggingthemtotheDeployment
Tool,orbyselectingthemandclickingtheAddFilesbutton
inthe
toolbar.
NoteThenameofanyfileaddedtotheprojectcannotduplicatethename
ofanyfunctionexistinginthelibraryofprecompiledfunctions.
5
Setpropertiesforbuildingandpackaging.
Whenyoubuildyoucancreateadebugversionofyourcompiledmodels
andcanspecifyverboseoutput.Thedebugoptionletsyoutracebacktothe
pointwhereyoucanidentifyifthefailureoccurredintheinitializationof
MCR,thefunctioncall,ortheterminationroutine.
ClickSettingstoviewandspecifytheseandothersettingsorclickthe
Settingsbutton
inthetoolbar.
1-5
C# TIFF: How to Convert TIFF to GIF Using Sample C# Code
Imaging Converting Library, conversions from TIFF to PDF & vector with other add-on DLLs, like TIFF add-on. Please refer to following two sets of APIs for TIFF
all jpg to one pdf converter; break pdf into multiple files
VB.NET TIFF: .NET TIFF Printer Control; Print TIFF Using VB.NET
Actually, the combination of those two VB.NET TIFF this VB.NET TIFF file printer control add-on does controls, PDF document, image to pdf files and components
append pdf; batch pdf merger online
1
GettingStarted
6
Addclasses(optional).
7
SavetheprojectbyclickingtheSavebutton
inthetoolbar.
8
Buildthecomponent.
ClicktheBuildbutton
inthetoolbartostartthebuildprocess.
ExcelBuildercopiesintermediatesourcefilesto
project_directory\src
andoutputfilesnecessaryfordeployment(aDLLandaVBAfile(
.bas
)to
project_directory\distrib
.
TheOutputpaneshowstheoutputofthebuildprocessandinformsyouof
anyproblemsencountered.TheresultingDLLisautomaticallyregistered
onyoursystem.
9
Test,edit,andrebuildasnecessary.
UsingthemccCommandtoBuildaComponent
InsteadusingtheDeploymentTool,youcanusethe
mcc
commandonthe
MATLABcommandlinetobuildExcelBuildercomponents.Thefollowing
sectionsprovidesomeexamplesofusingthe
mcc
command.SeetheMATLAB
Compilerdocumentationforacompletedescriptionofthe
mcc
command
anditsoptions.
Note If you use
mcc
, the
project_directory\src
and
project_directory\distrib
directories arenotautomatically
created. Tocreatethesedirectoriesandcopyassociatedfilestothem,use
the
mcc
command’s
-d
option.
ThefollowingisthegeneralsyntaxtocreateExcelBuildercomponentswith
mcc
:
mcc -W 'excel:<component_name>[,<class_name>[,<major>.<minor>]]'
Thesyntaxusesthe
-W
option,specifyingan
excel
wrapper.Youmustspecify
thenameyouwanttoassignthecomponent(
<component_name>
).Ifyoudo
1-6
BuildingaDeployableApplication
notspecifytheclassname(
<class_name>
),
mcc
usesthecomponentnameas
thedefault.Ifyoudonotspecifyaversionnumber,
mcc
usesthelatestversion
builtor1.0,ifthereisnopreviousversion.
Thefollowingexampleshowsthe
mcc
commandusedtocreateaCOM
componentcalled
mycomponent
containingsingleCOMclassnamed
myclass
withmethods
foo
and
bar
,andaversionof1.0. The
-T
optiontellsmccto
createaDLL.
mcc -W 'excel:mycomponent,myclass,1.0' ' -T T link:lib foo.m m bar.m
TogenerateanExcel-compatibleformulafunctionforeachM-file,specifythe
-b
optiononthecommandline,asfollows:
mcc -W 'excel:mycomponent,myclass,1.0' ' -b b -T link:lib foo.m m bar.m
Asanalternative,youcanalsousethe
cexcel
bundlefiletosimplifythe
commandline. Intheexample,notehowyoudonotneedtospecifythe
-T
orthe
-b
options.
mcc -B 'cexcel:mycomponent,myclass,1.0' foo.m bar.m
TestingtheComponent
Afteryoubuildacomponent,youcantestyoursoftwarebyimportingthe
VBAfile(
.bas
)intotheExcelVisualBasicEditorandinvokingoneofthe
functionsfromtheExcelworksheet.
ToimporttheVBAcodeintoExcel’sVisualBasicEditor,openExceland
selectTools>Macros>VisualBasicEditor. FromtheVisualBasic
Editor,selectFile>ImportandselectthecreatedVBAfilefromthe
<project_dir>\distrib
directory.
TheVisualBasicmodulecreatedwhenyoubuildtheprojectcontainsthe
necessaryinitializationcodeandaVBAformulafunctionforeachMATLAB
functionprocessed. Eachsuppliedformulafunctionwrapsacalltothe
respectivecompiledfunctioninaformatthatcanbeaccessedfromacell
inanExcelworksheet.Thefunctiontakesalistofinputscorrespondingto
theinputsoftheoriginalMATLABfunctionandreturnsasingleoutput
correspondingtothefirstoutputargument.
1-7
1
GettingStarted
Formulafunctionsofthistypearemostusefultoaccessafunctionofoneor
moreinputsthatreturnsasinglescalarvalue.Whenyourequiremultiple
outputsoroutputsrepresentingrangesofdata,youneedamoregeneral
VisualBasicsubroutine. FordetailsaboutintegratingExcelBuilder
componentsintoMicrosoftExcelviaVisualBasicforApplications,see
Chapter2,“ProgrammingwithMATLABBuilderforExcel”.
DeployingtheComponent
Afteryoucreateandtestyourcomponent,youthencreateanExceladd-in
(
.xla
)fromtheVBAcodegeneratedbyExcelBuilderbysavingtheworksheet
fileasan
.xla
filetothe
<project_dir>\distrib
directory.
FormoreinformationaboutcreatinganExcelAdd-in,refertotheExcel
documentationoncreatinga
.xla
file.
1
StartExcel.
2
SelectTools>Macros>VisualBasicEditor.
3
IntheMicrosoftVisualBasicwindow,selectFile>Import.
4
SelectVBAfile(
.bas
)fromthe
<projectdir>distrib
directory.
5
ClosetheVisualBasicEditor.
6
FromtheExcelworksheetwindow,selectFile>SaveAs.
7
SetSaveastoMicrosoftExceladd-in(
*.xla
).
8
Savethe
.xla
fileto
<projectdir>\distrib
.
Youcanalsodeployfilesin
*.xls
and
*.bas
formats. Todeployin
*.xls
format,followthepreviousstepsbutchangetheSaveastypeinstep7to
*.xls
.TodeployasVBAcode,followsteps1to4only.
PackagingandDistributingtheComponent
AfteryouhavesuccessfullycompiledyourmodelsandcreatedtheExcel
add-in,youcanpackagethecomponentfordistributiontoyourendusersby
1-8
BuildingaDeployableApplication
reopeningtheprojectinDeploymentToolandclickingthePackagebutton
inthetoolbar.Repeatthisdistributionprocessoneachtargetmachine.
MATLABBuilderforExcelcreatesaself-extractingexecutablecontaining
thefollowingfiles.
File
Description
<componentname>.ctf
ComponentTechnologyFile
archive;platform-dependent
filethatmustcorrespondto
theenduser’splatform
<componentname_projectversion>.dll
Compiledcomponent
_install.bat
Script run by the
self-extractingexecutable
MCRInstaller.exe
Self-extractingMATLAB
ComponentRuntimelibrary
utility that installs the
MCR;platform-dependent
filethatmustcorrespondto
theenduser’splatform;you
mustinstallonthetarget
machineonceperrelease.See
“WorkingwiththeMCR”for
moreinformation.
*.xla
AnyExceladd-infilesfoundin
the
<projectdir>\distrib
directory
TousetheExceladd-ins,startExcel,clickTools>Add-Ins,andselectthe
desired
.xla
file.
1-9
1
GettingStarted
1-10
Documents you may be interested
Documents you may be interested