>Open link start.spring.io
> Select Maven
> Select Language Java
> Click on Add dependencies
> Add dependencies (My SQL driver, Spring Web , Spring boot dev tools, spring data JAP, Thymeleaf)
> And Click on Generate button
> Open this project in Intelli J (IDE)
ActiveCell.Copy
or
Sub Macro1()
ActiveCell.Copy
ActiveCell.EntireRow.Interior.Color = 5296274
End Sub
or
Sub Macro1()
ActiveCell.Copy
With ActiveCell.Row.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 5287936
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub
ref:- https://www.mrexcel.com/board/threads/vba-command-for-copying-active-cell-content-only.978747/
https://www.reddit.com/r/excel/comments/axgoth/vba_code_to_color_a_row_whole_up_until_a_certain/
>Open MY sql server
>Click on Server Menu
>Click on Data Import
> Click on Import from self-contained file
> Click on 3 dot and than select sql file
>Select Default Target Schema(Dropdown) and select blank database name
> Click on Start Import button
Table are also called relations.
Record is a row and also called tuple.
Table columns are also called attributes.
Add this line to console
document.addEventListener('contextmenu', event => event.stopPropagation(), true);
> Open google message app
> Click on profile icon and there is trash folder
>Reply the message(9355036914) in the Google Message app and you will see the message in Google Message App
or
If there is no profile icon visible in google message app
> Open any other app like "SMS Organizer" app from Microsoft and you will see all the messages.
Missing expression. (near "ON" at position 25)
MYSQL
SET FOREIGN_KEY_CHECKS = ON;
Sub Macro3()
Dim Rng As Range
Dim randomIdx As Long
' Set your target range
Set Rng = Range("K3:K4591")
' Initialize the random number generator
Randomize
' Generate a random index between 1 and the total number of cells
randomIdx = Int(Rnd * Rng.Cells.Count) + 1
' Select the cell at that index
Rng.Cells(randomIdx).Select
Selection.Copy
End Sub
Add this line in settings.php
$config['system.image']['toolkit'] = 'gd';
uncomment this line(for showing error log )
$config['system.logging']['error_level'] = 'verbose';
Customize below code
$databases['default']['default'] = array (
'database' => 'rni_web', //write data base that is blank, for new installation
'username' => 'root',
'password' => '',
'prefix' => '',
'host' => 'localhost',
'port' => '3307',
'namespace' => 'Drupal\\mysql\\Driver\\Database\\mysql',
'driver' => 'mysql',
'autoload' => 'core/modules/mysql/src/Driver/Database/mysql/',
);
1) write data base that is blank, for new installation ( 'database' => 'rni_web', )
2) after next , you will get errors of gd than see below link
https://kapooryash.blogspot.com/2026/04/error-while-starting-my-sql-or-appache.html
3) if drupal new install than use it with that database, if website already modified or given by some other person than change database name with backup database(replace ( 'database' => 'rni_web', ) with other database)
<style>
.css-3d-text {
text-shadow: 0px 0px 0 rgb(250,188,2),
1px 1px 0 rgb(245,183,0),
2px 2px 0 rgb(240,178,0),
3px 3px 0 rgb(235,173,0),
4px 4px 0 rgb(230,168,0),
5px 5px 0 rgb(225,163,0),
6px 6px 0 rgb(220,158,0),
7px 7px 0 rgb(215,153,0),
8px 8px 0 rgb(210,148,0),
9px 9px 0 rgb(205,143,0),
10px 10px 0 rgb(200,138,0),
11px 11px 10px rgba(0,0,0,0.6),
11px 11px 1px rgba(0,0,0,0.5),
0px 0px 10px rgba(0,0,0,.2);
}
</style>
<div class="css-3d-text">3D TEXT</div>
> Open regedit.exe
> click on Computer
> Click on HKEY_CURRENT_USER
>Click on Control Panel
>Click on Colors
>Double Click on WindowText
> and change the value from 0 0 0 to 255 0 0 for red color
====================================
For font smoothing , go to
Computer\HKEY_CURRENT_USER\Control Panel\Desktop
click on FontSmoothing and change ethe value to 1
=====================================
For font change in window 11, see below link
https://www.wisecleaner.com/think-tank/585-How-to-Change-the-Font-on-Windows-11.html
=================
Computer\HKEY_CURRENT_USER\Control Panel\Desktop\Colors
--------------------------
or you can use Winaero Tweaker or Microsoft PowerToys
https://webolute.com/blog/programming/this-may-be-due-to-a-blocked-port-missing-dependencies/
and for My sql, use below steps
Open the XAMPP Control Panel and click Config next to MySQL, then select my.ini.
Find the lines port=3306 (usually in two places) and change them to port=3307.
next step
If going to localhost:8000 get error than change the config.inc.php, enter the password in string $cfg['Servers'][$i]['password'] = 'root';
and change
$cfg['Servers'][$i]['controluser'] = 'pma'; to $cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '';$cfg['Servers'][$i]['controluser'] = 'root';
const outputElement = document.getElementById('output');
const textArray = ['First text message.', 'Second text message.', 'Third text message.'];
let currentIndex = 0;
function displayNextText() {
if (currentIndex < textArray.length) {
// Replace the entire content with the current text
outputElement.innerHTML = textArray[currentIndex];
currentIndex++;
// Schedule the next text to be displayed after a delay (e.g., 2 seconds)
setTimeout(displayNextText, 2000); // 2000 milliseconds = 2 seconds
}
}
// Start the display sequence
displayNextText();
for (let i = 0; i < 10; i--) {
// 'i' starts at 0 and keeps decreasing (0, -1, -2, ...),
// so the condition 'i < 10' is always true.
}
https://zerotomastery.io/cheatsheets/csharp-cheat-sheet/
var anon = new { Name = "John", Age = 25 };
var person = Tuple.Create("John", 25); // Creates a tuple with two items.
backdrop-filter: blur(0px);
-webkit-backdrop-filter: blur(0px);
or simple use, if above is not working
.element-to-blur {
filter: blur(0.2px); /* The radius value controls the intensity of the blur */
}
Note:- There are lot of property in filer property example contrast, brightnexx, saturate, hue etc.
<style>
.typing-effect {
overflow: hidden; /* Hide the full text initially */
border-right: .15em solid orange; /* Blinking cursor effect */
white-space: nowrap; /* Prevent text from wrapping */
margin: 0 auto; /* Center the text */
letter-spacing: .15em; /* Spacing between characters */
width: 0; /* Start with a width of 0 */
animation:
typing 30.5s steps(150, end) forwards, /* Typing animation */
blink-caret 0.5s step-end infinite; /* Blinking cursor animation */
}
/* Keyframes for the typing animation */
@keyframes typing {
from { width: 50 }
to { width: 100% }
}
/* Keyframes for the blinking cursor */
@keyframes blink-caret {
from, to { border-color: transparent }
10% { border-color: orange; }
}
</style>
<html>
<p class="typing-effect">Hello, world! This is a CSS typing effect.</p>
</html>
=======================
Typing with javascript
const element = document.getElementById('sequence');
const fullText = 'IT Solutions Professional Work Ethic';
let index = 0;
function typeText() {
if (index < fullText.length) {
// Use the addition assignment operator (+=) to append the next character
element.innerHTML += fullText[index]; //
index++;
// Schedule the next character to be added after a delay (e.g., 100ms)
setTimeout(typeText, 100);
}
}
// Start the sequence
typeText();
Note: for demo you can check CSS framework https://picocss.com/
DECLARE @i INT = 1; -- Declare a variable for the loop counter
DECLARE @max_value INT = 500; -- Set the loop limit
-- Start the WHILE loop
WHILE @i <= @max_value
begin
-- 3. The INSERT query inside the loop
SET @i = @i + 1;
INSERT INTO [dbo].[AgentMaster]
([AgentName])
VALUES
('test')
end
/****** Script for SelectTopNRows command from SSMS ******/
SELECT [AgentNo]
,[AgentName]
FROM [testdb].[dbo].[AgentMaster]
INSERT INTO new_registration
(
`Ownership_Category`,
`Is_Govt_Org`,
`Title_Category`,
`Nationality`,
`Owner_Name`,
`Owner_Pan_Card`,
`Upload_pan_card_Document`,
`Mobile_No`,
`Email_ID`,
`PinCode`,
`State`,
`District`,
`City`,
-- 1. Change the statement delimiter
DELIMITER $$
DROP PROCEDURE IF EXISTS insert_data_loop;
-- 2. Create the stored procedure
CREATE PROCEDURE insert_data_loop()
BEGIN
DECLARE i INT DEFAULT 1; -- Declare a variable for the loop counter
DECLARE max_value INT DEFAULT 50; -- Set the loop limit
-- Start the WHILE loop
WHILE i <= max_value DO
-- 3. The INSERT query inside the loop
SET i = i + 1;
INSERT INTO new_registration
(
`Ownership_Category`,
`Is_Govt_Org`,
`Title_Category`,
`Nationality`,
`Owner_Name`,
`Owner_Pan_Card`,
`Upload_pan_card_Document`,
`Mobile_No`,
`Email_ID`,
`PinCode`,
`State`,
`District`,
`City`,
`Address`,
`DOB`,
`Upload_DOB_Certificate`,
`GST_No`,
`Upload_GST_Certificate`)
VALUES
(
'Individual',
1,
'News Paper',
'Indian',
'Yash Kapoor','45YYH87Y','Documents/test1.jpg',
457851,'test@test.com',
110022,'Haryana',
'Sonepat','Sonepat','Jangpura, Delhi',
' 15/01/1945', 'Documents/test1.jpg' ,
'JHJDFHJDF8787DF',
'Documents/test1.jpg');
-- Increment the counter
END WHILE;
END $$
-- 4. Reset the delimiter
DELIMITER ;
-- 5. Call the procedure to run the insert loop
CALL insert_data_loop();
-- Optional: verify the results
SELECT * FROM new_registration;
Note:- You cannot use for loop without Creating stored procedure.
NOW()
CURRENT_DATE
CURRENT_TIMESTAMP
in Default/Expression Column
INSERT INTO `test`.`new_registration`
(
`Ownership_Category`,
`Is_Govt_Org`,
`Title_Category`,
`Nationality`,
`Owner_Name`,
`Owner_Pan_Card`,
`Upload_pan_card_Document`,
`Mobile_No`,
`Email_ID`,
`PinCode`,
`State`,
`District`,
`City`,
`Address`,
`DOB`,
`Upload_DOB_Certificate`,
`GST_No`,
`Upload_GST_Certificate`)
VALUES
(
'Individual',
1,
'News Paper',
'Indian',
'Yash Kapoor','45YYH87Y','Documents/test1.jpg',
457851,'test@test.com',
110022,'Haryana',
'Sonepat','Sonepat','Jangpura, Delhi',
' 15/01/1945', 'Documents/test1.jpg' ,
'JHJDFHJDF8787DF',
'Documents/test1.jpg');
Right Click on Table(New_Reg_Table)
>Click on Send to SQl Editor
> Click on Create Statement
> To install MY SQL, below link to install
https://dev.mysql.com/downloads/workbench/
Click on Go to download page
or click on below link
> Click on https://dev.mysql.com/downloads/windows/installer/8.0.html
<!DOCTYPE html>
<html>
<head>
<style>
div.ex1 {
direction: rtl;
unicode-bidi: bidi-override;
}
</style>
</head>
<body>
<h1>The unicode-bidi Property</h1>
<div>Some text. Default writing direction.</div>
<div class="ex1">Some text. Right-to-left direction.</div>
</body>
</html>
ref:- https://www.w3schools.com/cssref/tryit.php?filename=trycss_text_unicode-bidi
(function() {
let style = `<style>
.p-datatable .p-datatable-tbody>tr>td{
color: black;
}
</style>`;
document.head.insertAdjacentHTML("beforeend", style);
})();
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
.loader {
border: 16px solid #f3f3f3;
border-radius: 50%;
border-top: 16px solid blue;
border-bottom: 16px solid blue;
width: 120px;
height: 120px;
-webkit-animation: spin 1s linear infinite;
animation: spin 400ms linear infinite;
}
@-webkit-keyframes spin {
0% { -webkit-transform: rotate(0deg); }
100% { -webkit-transform: rotate(360deg); }
}
@keyframes spin {
0% { transform: rotate(0deg); }
100% { transform: rotate(360deg); }
}
</style>
</head>
<body>
<h2>How To Create A Loader</h2>
<div class="loader"></div>
</body>
</html>
-webkit-text-stroke: 0.2px;
text-shadow: #fff 0px 0.5px 0.5px;
HTML
<img src="https://ik.imagekit.io/ikmedia/css-image-effects/new-york_lbAbZZKZG.jpg" alt="new york" />
</br>
img {
width: 300px;
}
img:hover {
/* Start the shake animation and make the animation last for 0.5 seconds */
animation: vibrate 0.1s;
/* When the animation is finished, start again */
animation-iteration-count: infinite;
}
@keyframes vibrate {
0% { transform: rotate(0deg); }
10% { transform: rotate(-1deg); }
20% { transform: rotate(1deg); }
30% { transform: rotate(0deg); }
40% { transform: rotate(1deg); }
50% { transform: rotate(-1deg); }
60% { transform: rotate(0deg); }
70% { transform: rotate(-1deg); }
80% { transform: rotate(1deg); }
90% { transform: rotate(0deg); }
100% { transform: rotate(-1deg); }
}
OR
<p class="vibrating-text"> dfdf dfd ddfd df</p>
CSS
@keyframes vibratetext {
0% { transform: translate(0, 0); }
20% { transform: translate(-1px, 1px); }
40% { transform: translate(-1px, -1px); }
60% { transform: translate(1px, 1px); }
80% { transform: translate(1px, -1px); }
100% { transform: translate(0, 0); }
}
> Go to Inspect element (F12)
> In body tag
> Go to styles
> In element style paste -webkit-filter: grayscale(100%);
and if you use 10%, 20% color will be increase or decrease in Chrome website.
or you can use below extension for chrome to decrease or increase saturation or colors
https://chromewebstore.google.com/detail/web-color-filter/njnaggoebacjnbklkcccmbnpfmeagcmp
https://chromewebstore.google.com/detail/video-image-control-new-g/mdoelcifdkcimkdbfkjjnedabmjlkokc
https://chromewebstore.google.com/detail/chrome-font-super-enhance/ombebcdhklmmkcddekoplmobafpkolmd
A+ FONT SIZE CHANGER (FOR COLOR CHANGE)
or you can download video image control source code from below link and add extension to chrome.
#Note This first line is mandatory [void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")
# Start WinWord (if not already running)
Start-Process -FilePath "chrome.exe"
# Wait for WinWord to open and become active
Start-Sleep -Seconds 3
# Activate the WinWord window (adjust the title if necessary)
$wshell = New-Object -ComObject wscript.shell
#$wshell.AppActivate("Document1 - Word") # Or the actual document title
(New-Object -ComObject "wscript.shell").SendKeys('data:text/html, <title>Notepad</title><body contenteditable style="font-size:18px;line-height:1.6;font-family:sans-serif;">')
(New-Object -ComObject "wscript.shell").SendKeys("{ENTER}")
Start-Sleep -Seconds 1
(New-Object -ComObject "wscript.shell").SendKeys("{TAB}")
for ($k = 1; $k -le 10; $k++) {
for ($i = 1; $i -le 50; $i++) {
$j = [char](65 + $i)
(New-Object -ComObject "wscript.shell").SendKeys("$j")
}
[System.Windows.Forms.SendKeys]::SendWait("^{a}")
[System.Windows.Forms.SendKeys]::SendWait("^{c}")
[System.Windows.Forms.SendKeys]::SendWait("{RIGHT}")
[System.Windows.Forms.SendKeys]::SendWait("^{v}")
(New-Object -ComObject "wscript.shell").SendKeys("{Enter}")
}
For Sorting
> First Select the columns
> Click on Data Menu
> Click on Sort
> Select the Column (Sort By)
> Click on OK
==============================
For Unique Records
> First Select the column
> Click on Data
> Click on Advanced
> Check on Unique Records
> Click on OK
https://dac.indiapost.gov.in/mypincode/home
https://dmsouthwest.delhi.gov.in/std-pin-codes/
https://www.data.gov.in/datasets_webservices/datasets/6818292
https://www.pib.gov.in/PressReleasePage.aspx?PRID=2131707®=3&lang=2
Know Your DIGIPIN: https://dac.indiapost.gov.in/mydigipin/home
Know Your PIN Code: https://dac.indiapost.gov.in/mypincode/home
DIGIPIN GitHub Repository: https://github.com/CEPT-VZG/digipin
Georeferenced PIN Code data set: https://www.data.gov.in/catalog/all-india-pincode-boundary-geo-json
HTML
<body>
<canvas id="myCanvas" width="200" height="100" style="border:1px solid #d3d3d3;">
Your browser does not support the HTML5 canvas tag.
</canvas>
<script src="script.js"></script>
</body>
#Note This first line is mandatory [void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")
# Start WinWord (if not already running)
Start-Process -FilePath "chrome.exe"
# Wait for WinWord to open and become active
Start-Sleep -Seconds 3
# Activate the WinWord window (adjust the title if necessary)
$wshell = New-Object -ComObject wscript.shell
#$wshell.AppActivate("Document1 - Word") # Or the actual document title
(New-Object -ComObject "wscript.shell").SendKeys('data:text/html, <title>Notepad</title><body contenteditable style="font-size:18px;line-height:1.6;font-family:sans-serif;">')
(New-Object -ComObject "wscript.shell").SendKeys("{ENTER}")
Start-Sleep -Seconds 1
(New-Object -ComObject "wscript.shell").SendKeys("{TAB}")
for ($k = 1; $k -le 50; $k++) {
for ($i = 1; $i -le 77; $i++) {
$j = [char](45 + $i)
(New-Object -ComObject "wscript.shell").SendKeys("$j")
}
(New-Object -ComObject "wscript.shell").SendKeys("{Enter}")
}
> In Excel , Click on Cell, If scroll Lock is OFF than You can left and right the Cell.
> IF scroll Lock is ON than you can scroll Down or up scroll bars.
#Note This first line is mandatory
[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")
# Start WinWord (if not already running)
Start-Process -FilePath "notepad.exe"
# Wait for WinWord to open and become active
Start-Sleep -Seconds 3
Start-Process -FilePath "notepad.exe"
Start-Sleep -Seconds 3
# Activate the WinWord window (adjust the title if necessary)
[System.Windows.Forms.SendKeys]::SendWait("123")
Start-Sleep -Seconds 3
[System.Windows.Forms.SendKeys]::SendWait("^{a}")
Start-Sleep -Seconds 3
[System.Windows.Forms.SendKeys]::SendWait("^{C}")
Start-Sleep -Seconds 3
[System.Windows.Forms.SendKeys]::SendWait("%{TAB}")
Start-Sleep -Seconds 3
[System.Windows.Forms.SendKeys]::SendWait("^{v}")
Note: ctrl C and Ctrl v , c and v are in small letters.
https://www.npmjs.com/package/fireworks-js
> https://github.com/crashmax-dev/fireworks-js
https://stackblitz.com/edit/js-ubfdjg?file=style.css,package.json,index.js
https://codepen.io/mr__khushal/pen/yLobQEP
https://stackblitz.com/edit/js-ubfdjg?file=style.css,package.json,index.js
https://www.myprograming.com/how-to-add-crackers-animation-effect-to-my-html-page/
if (confirm("Press a button!")) {
txt = "You pressed OK!";
} else {
txt = "You pressed Cancel!";
}
> In excel, there are books.
> And In books there are sheets
------
> At the top, you have restore option.
> In View Menu, You have arrange all button. You can click on that button.
> You can also used split button
> Open Excel
> Click on Data Menu
> Select the columns in sequence, not using CNTL(Column 1,2,3,4) will be used for Multiple columns. (Columns 4,6,9) will not be used for Multiple Columns.
> Click on Filter
>
> In settings of Google Chrome
> Click on Accessibility
> Click on navigate pages with a text cursor
---------
Click on HIGHLIGHT ON FOCUS OBJECT
#Note This first line is mandatory [void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")
# Start WinWord (if not already running)
Start-Process -FilePath "notepad.exe"
# Wait for WinWord to open and become active
Start-Sleep -Seconds 3
# Activate the WinWord window (adjust the title if necessary)
$wshell = New-Object -ComObject wscript.shell
#$wshell.AppActivate("Document1 - Word") # Or the actual document title
Start-Sleep -Seconds 1
for ($k = 1; $k -le 25; $k++) {
for ($i = 1; $i -le 75; $i++) {
$j = [char](40 + $i)
(New-Object -ComObject "wscript.shell").SendKeys("$j")
}
(New-Object -ComObject "wscript.shell").SendKeys("{Enter}")
}
