Skip to main content

Basic object detection in python using OpenCv and Numpy - by Dustbiin

1 comment

Add multiple sheets in an excel file in JAVA by using Apache POI. - Dustbiin

Adding multiple sheets in excel file-

multiple sheet

Create new workbook first-

XSSFWorkbook workBook = new XSSFWorkbook();

Add sheets in the workbook

Sheet sheet1 = workbook.createSheet("Sheet name 1");
Sheet sheet2 = workbook.createSheet("Sheet name 2");
Sheet sheet3 = workbook.createSheet("Sheet name 3");
Sheet sheet4 = workbook.createSheet("Sheet name 4");
Sheet sheet5 = workbook.createSheet("Sheet name 5");  
try (FileOutputStream outputStream = new FileOutputStream( "demo.xlsx" ))
{
    workbook.write( outputStream );
}
finally
{
    workbook.close();
}

Output - 
output
Output with five sheet int excel file
 
Labels:

Comments

Post a Comment

Popular posts from this blog

Custom cell color in Excel Apache POI - By Dustbiin

Create custom color for cell background by using java color class Create custom color- XSSFWorkbook workBook = new XSSFWorkbook (); IndexedColorMap colorMap = workbook.getStylesSource().getIndexedColors(); Font tableHeadOneFontStyle = workbook.createFont();  tableHeadOneFontStyle.setBold( true ); tableHeadOneFontStyle.setColor( IndexedColors.BLACK.getIndex() ); XSSFCellStyle tableHeaderOneColOneStyle = workbook.createCellStyle(); tableHeaderOneColOneStyle.setFont( tableHeadOneFontStyle ); tableHeaderOneColOneStyle.setFillForegroundColor( new XSSFColor( new java.awt.Color( 255, 231, 153 ), colorMap ) ); tableHeaderOneColOneStyle.setFillPattern( FillPatternType.SOLID_FOREGROUND ); tableHeaderOneColOneStyle = setLeftRightBorderColor( tableHeaderOneColOneStyle ); tableHeaderOneColOneStyle = alignCenter( tableHeaderOneColOneStyle );
Post a Comment
Read more

Create design by connecting dot's using opencv and numpy - by Dustbiin

Create basic design by using connecting dot's using your mouse- I have been create this by using mouse event check out the code below- use Python, OpenCv , NumPy import numpy as np import cv2 def click_event(event , x , y , flags , param): if event == cv2.EVENT_LBUTTONDOWN: print(x , " , " , y) font = cv2.FONT_HERSHEY_SIMPLEX strXY = str(x) + ' , ' + str(y) # cv2.putText(img,strXY, (x, y), font, .1, (255, 255, 0), 2) cv2.circle(img , (x , y) , 3 , ( 0 , 0 , 255 ) , - 1 ) points.append((x , y)) if len(points) >= 2 : cv2.circle(img , points[- 1 ] , 3 , ( 0 , 0 , 255 ) , - 1 ) # cv2.putText(img,strXY, points[-1], font, .1, (255, 255, 0), 2) cv2.line(img , points[- 2 ] , points[- 1 ] , ( 0 , 0 , 255 ) , 1 ) cv2.imshow( "Image" , img) points = [] img = np.zeros(( 512 , 512 , 3 )) cv2.imshow( "Image" , img) cv2.setMouseCallback( 'Image' ...
Post a Comment
Read more

Read data from .pfx file for Digita Signature - by Dustbiin

Their is many way to read data for data for digital signature but hear we discus reading data from .pfx file -  code for read .pfx file - import java.io.FileInputStream; import java.security.KeyStore; import java.security.cert.X509Certificate; import java.util.Date; import java.util.Enumeration; import javax.net.ssl.KeyManagerFactory; public class PdfDemo { public static void checkExpire() { try { KeyManagerFactory kmf = javax.net.ssl.KeyManagerFactory.getInstance( "SunX509" ); KeyStore keystore = KeyStore.getInstance( "PKCS12" ); char[] password = "123456".toCharArray(); keystore.load( new FileInputStream( "demo.pfx" ), password ); //keystore.load(new FileInputStream(certificate), password); kmf.init( keystore, password ); Enumeration<String> aliases = keystore.aliases(); while ( aliases.hasMoreElements() ) { ...
Post a Comment
Read more