1.
Create the java project
2. Create /lib folder in project folder and add the library fil
3. Create batch file to create jar file and manifestfile
4. Create batch file and Enter the input and output filepath
5. Run the batch file (double click) to create jar and manife
Output file will create in that folder entered In runjar batch
We can see all the output data
d the library files into this folder
nifestfile
output filepath for running the jar file
jar and manifest file
In runjar batch file.
1. Initially Open the Source File and check if the Developer option is enabled or not
2. If Developer option is not enabled Goto File -> Option (Click the option)
3. After that Click the Customize Ribbon - > Developer (check or enable the check box) - ->
4 Goto Developer and Click the Record Macro to open Record Macro Window
5. In Record Macro window We can customize (1) Macro name and 2. Enter shortcut Key t
x Make sure your shortcut key does not affect the default excel shortcuts
Description is optional
6. After Click OK -> Then click Stop Recording
Click the Macros
Click the Step into option to view the VBA Coding APP
In VBA you can see your Macro name
Copy and paste the Code given in Code_ForMacro Excel sheet ans save
After save close the window Press your shortcut key when entered in creating macro
Example (Ctrl+Shift+B)
After clicking the shortcut key data will be filtered
Click the Visual Basic to see the Coding
is enabled or not
nable the check box) - -> OK (Click ok to complete)
cro Window
d 2. Enter shortcut Key to Exceute Macro and 3. select Personal Workbook
in creating macro
Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+Shift+B
'
' Set the desired table name
Dim outputTableName As String
outputTableName = "Table1"
' Scroll up in the active window
ActiveWindow.SmallScroll Down:=-15
' Clear the clipboard to avoid any previous copy/paste operations
Application.CutCopyMode = False
Application.CutCopyMode = False
Application.CutCopyMode = False
' Create a PivotTable from the specified source data
ActiveWorkbook.PivotCaches.Create(SourceType:=xlConsolidation, SourceData:= _
Array("'202401-03‰p‘SƒŒƒxƒ‹'!R3C1:R59C92"), Version:=8).CreatePivotTable _
TableDestination:="", TableName:="PivotTable1", DefaultVersion:=8
ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
ActiveSheet.Cells(3, 1).Select
' Adjust the position of the "Sum of Value" field in the PivotTable
ActiveSheet.PivotTables("PivotTable1").DataPivotField.PivotItems("Sum of Value" _
).Position = 1
ActiveWorkbook.ShowPivotTableFieldList = True
Range("A3").Select
' Navigate to the end of the data in the specified direction
Selection.End(xlDown).Select
Selection.End(xlToRight).Select
Selection.End(xlToRight).Select
' Show the detail of the selected cell
Range("CO61").Select
Selection.ShowDetail = True
' Set the name of the active sheet to "Output_Data"
ActiveSheet.Name = "Output_Data"
Columns("B:B").Select
Columns("B:B").EntireColumn.AutoFit
Selection.Cut
Columns("A:A").Select
Selection.Insert Shift:=xlToRight
Selection.NumberFormatLocal = "yyyy-mm-dd"
Columns("B:B").Select
Selection.NumberFormatLocal = "hh:mm"
' Check if the table already exists
=_
le _
e" _
