Sending HTML Forwarding email Deleting email https://www.javatpoint.com/example-of-sending-attachment-with-email-using-java-mail-api next>> <<prev Sending email with attachment in Java For sending email with attachment, JavaMail API provides some useful classes like BodyPart, MimeBodyPart etc. For better understanding of this example, learn the steps of sending email using JavaMail API first. For sending the email using JavaMail API, you need… Continue reading Email with attachment
How to copy a row from existing excel sheet to a new excel sheet using Apache POI
source :http://stackoverflow.com/questions/22627691/how-to-copy-a-row-from-existing-excel-sheet-to-a-new-excel-sheet-using-apache-po public class RowCopy { public static void main(String[] args) throws Exception{ HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(“c:/input.xls”)); HSSFSheet sheet = workbook.getSheet(“Sheet1”); copyRow(workbook, sheet, 0, 1); FileOutputStream out = new FileOutputStream(“c:/output.xls”); workbook.write(out); out.close(); } private static void copyRow(HSSFWorkbook workbook, HSSFSheet worksheet, int sourceRowNum, int destinationRowNum) { // Get the source / new row HSSFRow… Continue reading How to copy a row from existing excel sheet to a new excel sheet using Apache POI
Insert into select sql in postgresql
INSERT into genit.mbudget2016a SELECT * from genit.mbudget;
Set all cell to text format in POI Apache
Here’s some example code : DataFormat fmt = workbook.createDataFormat(); CellStyle textStyle = workbook.createCellStyle(); textStyle.setDataFormat(fmt.getFormat(“@”)); worksheet.setDefaultColumnStyle(0, textStyle);
Delete From in Not In in Postgresql
command ini digunakan saat ingin delete table dengan kondisi yang disebut yang tidak didelete DELETE FROM otp.msection WHERE ssect NOT IN (‘4210’) and ssect NOT IN (‘4220’) and ssect NOT IN (‘4310’) and ssect NOT IN (‘4320’) and ssect NOT IN (‘4110’) and ssect NOT IN (‘4120’) and ssect NOT IN (‘4130’) and ssect NOT… Continue reading Delete From in Not In in Postgresql
XML parse file from HTTP
sumber : http://stackoverflow.com/questions/3058434/xml-parse-file-from-http ini adalahcara untuk ambil data xml dari url di internet kemudian dibuka file xml tersebut dan diurai diambil datanya. caranya seperti ini : private void start() throws Exception { URL url = new URL(“http://localhost:8080/AutoLogin/resource/web.xml”); URLConnection connection = url.openConnection(); Document doc = parseXML(connection.getInputStream()); NodeList descNodes = doc.getElementsByTagName(“description”); for(int i=0; i<descNodes.getLength();i++) { System.out.println(descNodes.item(i).getTextContent()); }… Continue reading XML parse file from HTTP
Print Area Dinamis di Macro Excel
Jika kita membuat macro dan kita ingin print area dinamis sesuai range yang kita inginkan kita bisa menggunakan code seperti di bawah ini : Dim totrw = 1 Do If Cells(totrw, 8).Value = ” (AUTHORISED SIGNATURE)” Then exit do totrw = totrw + 1 Loop totrw ada total row yang sudah kita looping sebelumnya Range(Cells(1,… Continue reading Print Area Dinamis di Macro Excel
Cara Membuat Tombol Run Macro di Excel 2010
Kalau kita sudah membuat program macro. kita ingin menaruhnya shortcutnya di bagian toolbar excel gimana caranya. 1. buka file excel –> Option 2.Dibagian kiri pilih command from Macros. bagian kanan pilih tab Developer –> New Group (jika ingin ditaruh di tab Developer) 3.Dibagian kiri ada list program-program macro yang bisa kita buat shortcutnya. dibagian kanan… Continue reading Cara Membuat Tombol Run Macro di Excel 2010
Menyimpan Macro di Startup Excel 2010
Kalau kita buat macro dan ingin terus terbuka otomatis saat kita membuka aplikasi excel. ini sangat mudah tinggal letakkan atau simpan file macro excel yang anda buat di xlstart. nah kadang bingung dimana sih xlstart itu kalo di excel 2010. disini letaknya teman-teman : C:\Users\lutvita\AppData\Roaming\Microsoft\Excel\XLSTART
Left Search di Excel 2010
Baru di kasih kasus ama temen kayak gini. di cell A1 ada data seperti ini 2RT 35T/7 60T/14 110T/20 100T/20 kemudian yang diperlukan cuma 2RT 35T. karakter selebihnya tidak dibutuhkan.masalahnya sebelum ‘/’ tidak pasti berapa karakter. pokoknya cari tanda ‘/’ kemudian pas ketemu langsung ambil semua karakter didepannya caranya mudah : logikannya kan rumusnya gini… Continue reading Left Search di Excel 2010
Filje Official Website 