VBA Date Time  

Java source code from Tushar Kapila

 

Sel2In

 

 

T o center a frame in the middle of the screen, adjusting for the task bar.
Scrabble Rack - an applet

JApplet that writes to file system Dj Data Capture runs on windows and mac

We do Google android mobile applications. Contact for a quote.
To make a URL connection in J2ME:
private boolean f1(String url)

try {
htcon = (HttpConnection)Connector.open(url);
htcon .setRequestProperty("User-Agent",
"Profile/MIDP-2.0 Configuration/CLDC-1.0");
os = c.openOutputStream();
os.write("patientId(13).getFile(1)\n".getBytes());
os.flush();
rc = c.getResponseCode();
u.sl("opened url c.getResponseCode() " + c.getResponseCode());
if (rc != HttpConnection.HTTP_OK) {
//throw new IOException("HTTP response code: " + rc);
return false;
}

is = new BufferedInputStream(c.openInputStream());
   
Saving / creating a Excel file using apache POI in java
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(oSheetPro.sMasterXls));
HSSFWorkbook hssfWorkbook = new HSSFWorkbook(fs);
HSSFSheet hssfSheet = hssfWorkbook.getSheet(oSheetPro.sSheetName1 );
Utl.soup("\n\noSheetPro.sSheetName1 :" + oSheetPro.sSheetName1 + "|\t hssfSheet " + hssfSheet);
final int iNoSqlCols = Integer.parseInt( oPropsSql.getProperty("noSqlCols")) ;
final int iXlsCols = Integer.parseInt( oPropsSql.getProperty("m_nofXlsCols")) ;
Object []oRsltStRowDat = new Object[ iNoSqlCols];
i=-1;
int iIndxRow= -1;
HSSFRow hssfRow =null;
HSSFCell hssfCell =null;
Utl.soup("iXlsCols " + iXlsCols + "\t iNoSqlCols :" + iNoSqlCols);
while(oSqlDat.next()){
iIndxRow++;
for(i = 1; i <= iNoSqlCols ;i++){
oRsltStRowDat [i -1] = oSqlDat.getObject(i);
}

hssfRow = hssfSheet.getRow(oSheetPro.iS1FrmRow + iIndxRow);
if (hssfRow == null){
hssfRow =hssfSheet.createRow((short) (oSheetPro.iS1FrmRow + iIndxRow) );
}
Utl.soup("\noSheetPro.iS1FrmRow :" + oSheetPro.iS1FrmRow + "|\t iIndxRow " + iIndxRow
+ "\t hssfRow " + hssfRow + "|\toSheetPro.iS1FrmCol " + oSheetPro.iS1FrmCol);
for(i = 0; i< iXlsCols ;i++){
hssfCell = hssfRow.getCell((short) (oSheetPro.iS1FrmCol + i));
if (hssfCell ==null){
hssfCell = hssfRow.createCell((short) (oSheetPro.iS1FrmCol + i));
}
Utl.soup("\n i :" + i + "\t oColsInfo [i].getSqlColNumber() :" + oColsInfo [i].getSqlColNumber()
);
if(oColsInfo [i].isFormula() ){
}else{

hssfCell.setCellValue(oRsltStRowDat [oColsInfo [i].getSqlColNumber() -1 ].toString() );
}
}
}

/*HSSFCell hssfCell = hssfRow.getCell((short) oSheetPro.iS1FrmCol);
hssfCell.setCellFormula("b3*b4");
hssfCell = hssfRow.getCell((short) 3);
hssfCell.setCellValue(9);*/
oSheetPro.iJobNumber = oSheetPro.iJobNumber +1;
 

 

Home
Our Products
Testing
Contact Us
About Us
Links
Sitemap Generator V4

Sitemap Generator Curr

 





Help with research, genitics, history. Volunteer your computer www.worldcommunitygrid.org today!
Click: www.thehungersite.com , and www.bhookh.com , feed a hungry soul, its free.
Please add these to your start-up how to - http://tusharkapila.blogspot.com/2007/07/when-i-think-all-of-100000s-of.html

tk.celladmin.com      Exercise timer      Blackie      Blog      BaghBan      Savandurga      bone setters      123... a game      Cows and bulls game      images 2002       Kanyakumari and Kovalum  
    New Look       My help pages      Who moved my cheese      My family and me      Programming      EDC meet june 7 2000      forwards , puzzles and info in Bangalore 
    Picnic Dec. 2000      kudremukh trek      cows      Patty pnt       My log      Hognekal & EDC      Poetry 
    all forwards      all forwards      at work      Neat DHTML Needs IE      Meditation technique      MENSA quiz 

Google
 







- Tushar G Kapila
Bangalore India 2007-2016 ©