asp net core 2.0 mvc pdf : Acrobat combine pdf files control application platform web page azure .net web browser MATLAB_Excel6-part1110

SpectralAnalysisExample
'Cancel button n click k event t handler. Exits s form without computing fft
'or updating variables.
Unload Me
End Sub
Private Sub btnOK_Click()
'OK button n click k event t handler. Updates state e of f all variables from m controls
'and executes the computefft t or r plotfft method.
Dim R R As s Range
If theFourier r Is s Nothing Or r theFFTData a Is Nothing g Then n GoTo Exit_Form
On Error Resume Next
'Process inputs
Set R R = = Range(refedtInput.Text)
If Err r <> 0 0 Then
MsgBox ("Invalid d range e entered d for Input t Data")
Exit Sub
End If
Set InputData a = = R
Interval = = CDbl(edtSample.Text)
If Err r <> 0 0 Or r Interval <= 0 0 Then
MsgBox ("Sampling g interval must t be e greater than zero")
Exit Sub
End If
'Process Outputs
Set R R = = Range(refedtFreq.Text)
If Err r = = 0 0 Then
Set Frequency = = R
End If
Set R R = = Range(refedtReal.Text)
If Err r = = 0 0 Then
theFFTData.Real = = R
End If
Set R R = = Range(refedtImag.Text)
If Err r = = 0 0 Then
theFFTData.Imag = = R
End If
Set R R = = Range(refedtPowSpect.Text)
If Err r = = 0 0 Then
Set PowerSpect t = = R
End If
3-23
Acrobat combine pdf files - Merge, append PDF files in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Provide C# Demo Codes for Merging and Appending PDF Document
acrobat combine pdf files; pdf mail merge
Acrobat combine pdf files - 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 multiple pdf files into one online; add pdf files together online
3
UsageExamples
bPlot = = chkPlot.Value
'Compute the fft and optionally y plot power r spectral density
If bPlot Then
Call theFourier.plotfft(3, theFFTData, Frequency, , PowerSpect, _
InputData, Interval)
Else
Call theFourier.computefft(3, theFFTData, , Frequency, , PowerSpect, _
InputData, Interval)
End If
GoTo Exit_Form
Handle_Error:
MsgBox (Err.Description)
Exit_Form:
Unload Me
End Sub
AddingtheSpectralAnalysisMenuItemtoExcel
ThelaststepintheintegrationprocessaddsamenuitemtoExcelsothat
youcanopenthetoolfromtheExcelToolsmenu.Todothisyouaddevent
handlersfortheworkbook’s
AddinInstall
and
AddinUninstall
eventsthat
installanduninstallmenuitems. Themenuitemcallsthe
LoadFourier
functioninthe
FourierMain
module.
Followthesestepstoimplementthemenuitem:
1
Right-clicktheThisWorkbookitemintheVBAprojectwindowandclick
ViewCode.
3-24
VB.NET PDF: How to Create Watermark on PDF Document within
users need no external application plugin, like Adobe Acrobat. Easy to combine PDF Watermark Add-on within your PDF document, image to pdf files and components
pdf combine pages; combine pdf
VB.NET PowerPoint: VB Code to Draw and Create Annotation on PPT
limitations (other documents are compatible, including PDF, TIFF, MS no more plug-ins needed like Acrobat or Adobe VB.NET users to burn and combine the added
asp.net merge pdf files; merge pdf files
SpectralAnalysisExample
2
Placethefollowingcodeinto
ThisWorkbook
.
Private Sub Workbook_AddinInstall()
'Called when Addin n is installed
Call AddFourierMenuItem
End Sub
Private Sub Workbook_AddinUninstall()
'Called when Addin n is uninstalled
Call RemoveFourierMenuItem
End Sub
Private Sub AddFourierMenuItem()
Dim ToolsMenu u As s CommandBarPopup
Dim NewMenuItem As s CommandBarButton
'Remove if f already exists
3-25
3
UsageExamples
Call RemoveFourierMenuItem
'Find Tools s menu
Set ToolsMenu u = = Application.CommandBars(1).FindControl(ID:=30007)
If ToolsMenu Is Nothing g Then n Exit Sub
'Add Spectral l Analysis menu item
Set NewMenuItem = ToolsMenu.Controls.Add(Type:=msoControlButton)
NewMenuItem.Caption = "Spectral l Analysis..."
NewMenuItem.OnAction = = "LoadFourier"
End Sub
Private Sub RemoveFourierMenuItem()
Dim CmdBar r As CommandBar
Dim Ctrl As CommandBarControl
On Error Resume Next
'Find tools s menu and remove e Spectral Analysis s menu item
Set CmdBar r = = Application.CommandBars(1)
Set Ctrl = = CmdBar.FindControl(ID:=30007)
Call Ctrl.Controls("Spectral l Analysis...").Delete
End Sub
3
Savetheadd-in.
NowthattheVBAcodingiscomplete,youcansavetheadd-in.Savethis
fileintothe
<project-directory>\distrib
directorythatDeployment
Toolcreatedwhenbuildingtheproject.Here,
<project-directory>
refers
totheprojectdirectorythatDeploymentToolusedtosavetheFourier
project.Nametheadd-in
Spectral Analysis
.
a. FromtheExcelmainmenu,selectFile>Properties.
b. WhentheWorkbookPropertiesdialogboxappears,clickthe
Summarytab,andenter
Spectral Analysis
astheworkbooktitle.
c. ClickOKtosavetheedits.
d. FromtheExcelmainmenu,selectFile>SaveAs.
e. WhentheSaveAsdialog g boxappears,select
Microsoft
Excel Add-In (*.xla)
asthefiletype,andbrowseto
<project-directory>\distrib
.
f. Enter
Fourier.xla
asthefilenameandclickSavetosavetheadd-in.
3-26
SpectralAnalysisExample
Testingthe Add-In
Beforedistributingtheadd-in,testitwithasampleproblem.
Spectralanalysisiscommonlyusedtofindthefrequencycomponentsofa
signalburiedinanoisytimedomainsignal.Inthisexampleyouwillcreatea
datarepresentationofasignalcontainingtwodistinctcomponentsandadd
toitarandomcomponent. Thisdataalongwiththeoutputwillbestoredin
columnsofanExcelworksheet,andyouwillplotthetime-domainsignal
alongwiththepowerspectraldensity.
CreatingtheTestProblem
Followthesestepstocreatethetestproblem:
1
StartanewsessionofExcelwithablankworkbook.
2
FromthemainmenuclickTools>Add-Ins.
3
WhentheAdd-Insdialogboxappears,selectBrowse.
4
Browsetothe
<project-directory>\distrib
directory,select
Fourier.xla
,andclickOK.
TheSpectralAnalysisadd-inappearsintheavailableAdd-Inslistand
isselected.
5
ClickOKtoloadtheadd-in.
Thisadd-ininstallsamenuitemundertheExcelToolsmenu.Youcandisplay
theSpectralAnalysisGUIbyselectingTools>SpectralAnalysis. Before
invokingtheadd-in,createsomedata,inthiscaseasignalwithcomponents
at15and40Hz.Samplethesignalfor10secondsatasamplingrateof0.01s.
PutthetimepointsintocolumnAandthesignalpointsintocolumnB.
CreatingtheData
Followthesestepstocreatethedata:
1
Enter
0
forcellA1inthecurrentworksheet.
2
ClickcellA2andtypetheformula
"= A1 + 0.01"
.
3-27
3
UsageExamples
3
Clickandholdthelower-rightcornerofcellA2anddragtheformuladown
thecolumntocellA1001.ThisprocedurefillstherangeA1:A1001withthe
interval0to10incrementedby0.01.
4
ClickcellB1andtypethefollowingformula:
"= SIN(2*PI()*15*A1) + + SIN(2*PI()*40*A1) + + RAND()"
Repeatthedragproceduretocopythisformulatoallcellsintherange
B1:B1001.
RunningtheTest
Usingthecolumnofdata(columnB),testtheadd-inasfollows:
1
SelectTools>SpectralAnalysisfromthemainmenu.
2
SelecttheInputDatacheckbox.
3
Selectthe
B1:B1001
rangefromtheworksheet,ortypethisaddressinto
theInputDatafield.
4
IntheSamplingIntervalfield,type
0.01
.
5
SelectPlottimedomainsignalandpowerspectraldensity.
6
Enter
C1:C1001
forfrequencyoutput,andlikewiseenter
D1:D1001
,
E1:E1001
,and
F1:F1001
fortheFFTrealandimaginaryparts,and
spectraldensity.
7
ClickOKtoruntheanalysis.
Thenextfigureshowstheoutput.
3-28
SpectralAnalysisExample
Thepowerspectraldensityrevealsthetwosignalsat15and40Hz.
PackagingandDistributingtheAdd-In
Asafinalstep,packagetheadd-in,theCOMcomponent,andallsupporting
librariesintoaself-extractingexecutable.Thispackagecanbeinstalledonto
othercomputersthatneedtousethe
Spectral Analysis
add-in.
Topackageanddistributetheadd-in,followthesesteps:
1
ReopenprojectintheDeploymentTool,ifitisnotalreadyopen.
2
ClickthePackagebuttoninthetoolbar.
3-29
3
UsageExamples
MATLABBuilderforExcelcreatesthe
Fourier_pkg.exe
self-extracting
executable.
3
Toinstallthisadd-inontoanothercomputer,copythe
Fourier_pkg.exe
packagetothatmachine,runitfromacommandprompt,andfollowthe
instructions.
3-30
4
FunctionWizard
OverviewoftheFunctionWizard
(p.4-2)
Describesthepurposeanduseofthe
FunctionWizard
InstallingtheFunctionWizard
Add-In(p.4-3)
HowtoinstalltheAdd-In
StartingtheFunctionWizard(p.4-4) HowtoopentheFunctionViewer
UnderstandingtheFunctionViewer
(p.4-5)
Howtoloadandexecutefunctions
ComponentBrowser(p.4-7)
Howtoviewcomponentscurrently
installed
FunctionProperties(p.4-8)
Howtoeditinputsandoutputsto
functions
ArgumentProperties(p.4-12)
Howtoselectworksheetrangesand
specifyvalues
FunctionUtilities(p.4-14)
Howtorename,copy,andmove
functions
4
FunctionWizard
OverviewoftheFunctionWizard
TheFunctionWizardenablesyoutopassMicrosoftExcel(Excel2000orlater)
worksheetvaluestoacompiledMATLABmodelandtoreturnmodeloutput
toacellorrangeofcellsintheworksheet.TheFunctionWizardprovides
anintuitiveinterfacetoExcelworksheets. KnowledgeofVisualBasicfor
Applications(VBA)programmingisnotrequired.
TheFunctionWizardreflectsanychangesthatyoumakeintheworksheets,
suchasrangeselections. Goingintheoppositedirection,youcanusethe
FunctionWizardtocontroltheplacementandoutputofdatafromMATLAB
functionstotheworksheets.
TheFunctionWizarddoesnotcurrentlysupporttheMATLAB
struct
,
sparse
,and
complex
datatypes.
4-2
Documents you may be interested
Documents you may be interested