Java File

SheetUpdate.java (text/plain), 2.51 KB, created by RatiKanata Pal on 2019-05-02 06:45:53 UTC

(hide)

Description: Java File

Filename:

MIME Type:

Creator: RatiKanata Pal

Created: 2019-05-02 06:45:53 UTC

Size: 2.51 KB

patch

obsolete

>import java.io.File; >import java.io.FileInputStream; >import java.io.FileOutputStream; >import java.text.FieldPosition; >import java.text.SimpleDateFormat; >import java.util.Date; >import java.util.Iterator; > >import org.apache.poi.openxml4j.opc.OPCPackage; >import org.apache.poi.ss.usermodel.Cell; >import org.apache.poi.ss.usermodel.Row; >import org.apache.poi.xssf.streaming.SXSSFSheet; >import org.apache.poi.xssf.streaming.SXSSFWorkbook; >import org.apache.poi.xssf.usermodel.XSSFSheet; >import org.apache.poi.xssf.usermodel.XSSFWorkbook; >import org.apache.poi.ss.usermodel.Name; > >public class SheetUpdate { > > public static void main(String[] args) { > > > // TODO Auto-generated method stub > File inpFile=null; > FileInputStream file=null; > OPCPackage pkg = null; > Row row = null; > try{ > > inpFile = new File("D:\\Temp\\26 Apr 2019\\TestTemplate.xlsx"); > > file = new FileInputStream(inpFile); > > pkg = OPCPackage.open(file); > > XSSFWorkbook workbook = new XSSFWorkbook(pkg); > SXSSFWorkbook workbook_sx = new SXSSFWorkbook(workbook, 1000); > workbook_sx.setCompressTempFiles(true); > > > > XSSFSheet vDataSheetXssf = workbook.getSheet("Sheet1"); > SXSSFSheet vDataSheetSxssf = (SXSSFSheet) workbook_sx.getSheet("Sheet1"); > > > Iterator<Row> rowIterator = vDataSheetXssf.iterator(); > int i=0; > while(true) > { > try{ > row=rowIterator.next(); > } > catch(Exception e) > { > break; > } > if(row==null) > { > break; > } > > if(i!=0){ > Cell cell =row.getCell(2); > cell.setCellValue("OD"+i); > System.out.println("Set"); > } > i++; > } > > > Name rangeName = workbook.getName("table1"); > rangeName.setRefersToFormula("Sheet1!$A$2:$C$10"); > > System.out.println(rangeName); > > SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMddHHmmss"); > StringBuffer vFormatedDate=new StringBuffer(""); > simpleDateFormat.format(new Date(), vFormatedDate, new FieldPosition(0)); > > StringBuffer fileDestination=new StringBuffer("D:\\Temp\\26 Apr 2019\\out\\TestTemplate_"+vFormatedDate+".xlsx");; > > file.close(); > File file2 = new File(fileDestination.toString()); > FileOutputStream outputStream = new FileOutputStream(file2); > workbook_sx.write(outputStream); > outputStream.close(); > workbook_sx.dispose(); > > System.out.println("Done"); > > }catch(Exception r) > { > r.printStackTrace(); > } > } > >} > View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]