List of usage examples for org.apache.poi.xssf.usermodel XSSFSheet getRow
@Override public XSSFRow getRow(int rownum)
From source file:controller.application.employee.ViewEmployeController.java
private void toExcel(ArrayList<ToExcelEmployee> lst, ArrayList<RFIDTimestamp> times, File file, Timestamp from, Timestamp to) throws IOException { try {//from ww w .ja va2 s .co m XSSFWorkbook workbook = new XSSFWorkbook(); XSSFSheet spreadsheet = workbook.createSheet("Total arbetad tid " + file.getName()); XSSFRow row = spreadsheet.createRow(0); XSSFCell cell; cell = row.createCell(0); cell.setCellValue("Frnamn:"); cell = row.createCell(1); cell.setCellValue("Efternamn:"); cell = row.createCell(2); cell.setCellValue("Anstllningsnummer:"); cell = row.createCell(3); cell.setCellValue("Individuell tid (h) from.: " + (from.toString() + " tom.: " + to.toString()) .replaceAll("(\\s)((\\p{Digit}{2}:){2}\\p{Digit}{2})\\..", "")); Double totAllTime = 0.0; for (int i = 1; i <= lst.size(); i++) { row = spreadsheet.createRow(i); cell = row.createCell(0); cell.setCellValue(lst.get(i - 1).surname); cell = row.createCell(1); cell.setCellValue(lst.get(i - 1).lastname); cell = row.createCell(2); cell.setCellValue(lst.get(i - 1).id); cell = row.createCell(3); cell.setCellValue(lst.get(i - 1).time); totAllTime += lst.get(i - 1).time; if (i == lst.size()) { row = spreadsheet.createRow(i + 1); cell = row.createCell(3); cell.setCellValue("Sammanstllning:"); row = spreadsheet.createRow(i + 2); cell = row.createCell(3); cell.setCellValue(totAllTime); } } XSSFSheet spreadsheetTimes = workbook.createSheet("Tider"); row = spreadsheetTimes.createRow(0); cell = row.createCell(0); cell.setCellValue("RFID"); cell = row.createCell(1); cell.setCellValue("IN/UT"); cell = row.createCell(2); cell.setCellValue("Datum/Tid"); for (int i = 1; i <= times.size(); i++) { row = spreadsheetTimes.createRow(i); cell = row.createCell(0); cell.setCellValue(times.get(i - 1).getRFID().toString()); cell = row.createCell(1); cell.setCellValue(times.get(i - 1).getInOut()); cell = row.createCell(2); cell.setCellValue(times.get(i - 1).getTime()); } for (int k = 0; k < spreadsheet.getRow(0).getLastCellNum(); k++) { spreadsheet.autoSizeColumn(k); } for (int j = 0; j < spreadsheetTimes.getRow(0).getLastCellNum(); j++) { spreadsheetTimes.autoSizeColumn(j); } try (FileOutputStream out = new FileOutputStream(file)) { workbook.write(out); } System.out.println(file.getName() + " written successfully"); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } }
From source file:controller.DAORequest.java
public void saveRequest() { XSSFSheet sheet = workbook.getSheetAt(0); sheet.getRow(0).createCell(10).setCellValue("Id solicitante"); sheet.getRow(0).createCell(11).setCellValue("Nombre solicitante"); sheet.getRow(0).createCell(12).setCellValue("Estado de solicitud"); sheet.getRow(0).createCell(13).setCellValue("Num de Resolucion"); int rowI = 1; for (Object o : School.getInstance().selectAllRequests()) { Request r = (Request) o; Row row = sheet.createRow(rowI); ////from w w w .j a v a 2 s . c om Cell cellDate = row.createCell(0); cellDate.setCellValue(r.getDate()); CellStyle styleCreationDate = workbook.createCellStyle(); XSSFDataFormat dfCreationDate = workbook.createDataFormat(); styleCreationDate.setDataFormat(dfCreationDate.getFormat("d/m/yy")); cellDate.setCellStyle(styleCreationDate); // Cell cellCarnet = row.createCell(1); cellCarnet.setCellValue(r.getAffected().getId()); CellStyle styleCreationInt = workbook.createCellStyle(); XSSFDataFormat dfCreationInt = workbook.createDataFormat(); Cell cellName = row.createCell(2); cellName.setCellValue(r.getAffected().getName()); Cell cellEmail = row.createCell(3); cellEmail.setCellValue(r.getAffected().getEmail()); Cell cellPhone = row.createCell(4); cellPhone.setCellValue(r.getAffected().getPhone()); Cell cellPeriod = row.createCell(5); cellPeriod.setCellValue(r.getGroup().getPeriod()); Cell cellCourse = row.createCell(6); cellCourse.setCellValue(r.getGroup().getCourse().getCode()); Cell cellNumGroup = row.createCell(7); cellNumGroup.setCellType(Cell.CELL_TYPE_NUMERIC); cellNumGroup.setCellValue(r.getGroup().getNumber()); Cell cellInc = row.createCell(8); cellInc.setCellValue(transformInconsistencieToSpanish(r.getInconsistencie())); Cell cellDescription = row.createCell(9); cellDescription.setCellValue(r.getDescription()); Cell cellIdReq = row.createCell(10); cellIdReq.setCellValue(r.getRequester().getId()); Cell cellNameReq = row.createCell(11); cellNameReq.setCellValue(r.getRequester().getName()); Cell cellReqState = row.createCell(12); cellReqState.setCellValue(transformReqStatetoSpanish(r.getRequestState())); if (r.getRequestState() == ERequestState.PROCESSED) { Cell cellNumReso = row.createCell(13); cellNumReso.setCellValue(Integer.toString(r.getResolution().getId())); } rowI++; } // Save to excel file try { FileOutputStream out = new FileOutputStream(new File("src//files//DatosFormulario.xlsx")); workbook.write(out); workbook.close(); out.close(); saveResolution(); } catch (FileNotFoundException ex) { Logger.getLogger(DAORequest.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(DAORequest.class.getName()).log(Level.SEVERE, null, ex); } }
From source file:controller.DAORequest.java
public void saveResolution() { XSSFWorkbook reqWB = new XSSFWorkbook(); XSSFSheet sheet = reqWB.createSheet(); Row rowZ = sheet.createRow(0);/*from w w w .j a v a2s. c o m*/ sheet.getRow(0).createCell(0).setCellValue("Id"); sheet.getRow(0).createCell(1).setCellValue("Attention"); sheet.getRow(0).createCell(2).setCellValue("Title"); sheet.getRow(0).createCell(3).setCellValue("Intro"); sheet.getRow(0).createCell(4).setCellValue("Result"); sheet.getRow(0).createCell(5).setCellValue("Resolve"); sheet.getRow(0).createCell(6).setCellValue("Notify"); sheet.getRow(0).createCell(7).setCellValue("Considerations"); ArrayList<Resolution> resolutions = new ArrayList<>(); for (Object o : School.getInstance().selectAllRequests()) { Request r = (Request) o; if (r.getResolution() != null) { resolutions.add(r.getResolution()); } } int rowI = 1; for (Resolution r : resolutions) { Row row = sheet.createRow(rowI); // Cell cellId = row.createCell(0); cellId.setCellValue(r.getId()); Cell cellAttention = row.createCell(1); cellAttention.setCellValue(r.getAttention()); Cell cellTitle = row.createCell(2); cellTitle.setCellValue(r.getTitle()); Cell cellIntro = row.createCell(3); cellIntro.setCellValue(r.getIntro()); Cell cellResult = row.createCell(4); cellResult.setCellValue(r.getResult()); Cell cellResolve = row.createCell(5); cellResolve.setCellValue(r.getResolve()); Cell cellNotify = row.createCell(6); cellNotify.setCellValue(r.getNotify()); Cell cellCons = row.createCell(7); cellCons.setCellValue(r.getConsider()); rowI++; } // Save to excel file try { FileOutputStream out = new FileOutputStream(new File("src//files//DatosResolucion.xlsx")); reqWB.write(out); reqWB.close(); out.close(); } catch (FileNotFoundException ex) { Logger.getLogger(DAORequest.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(DAORequest.class.getName()).log(Level.SEVERE, null, ex); } }
From source file:controller.ExcelConsultant.java
static ArrayList<String> getUnrepeatableDataOfACollum(File inputFile, int col) { ArrayList<String> collection = new ArrayList<>(); try {// w w w.j a va 2 s. c om FileInputStream fis = new FileInputStream(inputFile); XSSFWorkbook myWorkBook = new XSSFWorkbook(fis); XSSFSheet sheet = myWorkBook.getSheetAt(0); int nRows = sheet.getPhysicalNumberOfRows(); for (int i = 1; i < nRows; i++) { String item = sheet.getRow(i).getCell(col).getStringCellValue(); String delim = " "; String[] separatedWords = item.split(delim); for (String word : separatedWords) { word = word.replaceAll(",", ""); word = word.replaceAll(" ", ""); if (!collection.contains(word)) { collection.add(word); } } } } catch (Exception e) { e.printStackTrace(); } collection.sort(null); return collection; }
From source file:controller.ExcelConsultant.java
public static ArrayList<Result> makeConsult(File inputFile, String trade, String area) { ArrayList<Result> result = new ArrayList<>(); try {/*from w w w.j av a2 s . c o m*/ FileInputStream fis = new FileInputStream(inputFile); XSSFWorkbook myWorkBook = new XSSFWorkbook(fis); XSSFSheet sheet = myWorkBook.getSheetAt(0); int nRows = sheet.getPhysicalNumberOfRows(); for (int i = 1; i < nRows; i++) { Row actualRow = sheet.getRow(i); if (actualRow.getCell(1).getStringCellValue().contains(trade) && actualRow.getCell(5).getStringCellValue().contains(area)) { String name = actualRow.getCell(0).getStringCellValue(); String tradeName = actualRow.getCell(2).getStringCellValue(); String person = actualRow.getCell(3).getStringCellValue(); String number = actualRow.getCell(4).getStringCellValue(); String notes = actualRow.getCell(6).getStringCellValue(); Result r = new Result(name, tradeName, person, number, notes); result.add(r); } } } catch (Exception e) { e.printStackTrace(); } return result; }
From source file:controller.ExcelConsultant.java
static void logResult(ArrayList<Result> result, File outputFile, String name) { try {// w ww . j av a 2s . c om FileInputStream fis; fis = new FileInputStream(outputFile); XSSFWorkbook myWorkBook = new XSSFWorkbook(fis); XSSFSheet sheet = myWorkBook.getSheetAt(0); int nRow = sheet.getPhysicalNumberOfRows(); if (nRow == 0) { sheet.createRow(nRow); sheet.getRow(nRow).createCell(0).setCellValue("Timestamp"); sheet.getRow(nRow).createCell(1).setCellValue("Name"); sheet.getRow(nRow).createCell(2).setCellValue("Trade Name"); sheet.getRow(nRow).createCell(3).setCellValue("Number"); sheet.getRow(nRow).createCell(4).setCellValue("Person"); sheet.getRow(nRow).createCell(5).setCellValue("Notes"); nRow++; } for (Result res : result) { sheet.createRow(nRow); Date date = new Date(); sheet.getRow(nRow).createCell(0).setCellValue(date.toString()); sheet.getRow(nRow).createCell(1).setCellValue(name); sheet.getRow(nRow).createCell(2).setCellValue(res.getTradeName()); sheet.getRow(nRow).createCell(3).setCellValue(res.getNumber()); sheet.getRow(nRow).createCell(4).setCellValue(res.getPerson()); sheet.getRow(nRow).createCell(5).setCellValue(res.getNotes()); nRow++; } //important to close InputStream fis.close(); //Open FileOutputStream to write updates FileOutputStream output_file = new FileOutputStream(outputFile); //write changes myWorkBook.write(output_file); //close the stream output_file.close(); } catch (Exception ex) { ex.printStackTrace(); } }
From source file:courtscheduler.persistence.CourtScheduleIO.java
License:Apache License
public List<Team> readXlsx(String filename, CourtScheduleInfo info) throws Exception { File file = new File(filename); if (!file.exists()) { return null; }/* w w w . ja v a2 s.com*/ FileInputStream fis = new FileInputStream(file); XSSFWorkbook wb = new XSSFWorkbook(fis); // Get worksheet by index XSSFSheet sh = wb.getSheetAt(0); rowNumber = 2; Integer rowCount = sh.getLastRowNum(); if (Main.LOG_LEVEL >= 1) { System.out.println(new java.util.Date() + "[INFO] Worksheet Name: " + sh.getSheetName()); System.out.println(new java.util.Date() + "[INFO] Worksheet has " + (rowCount - 1) + " lines of data."); } while (rowNumber <= rowCount) { Row currentRow = sh.getRow(rowNumber); if (currentRow != null && currentRow.getLastCellNum() > 0) { Team nextTeam = processRow(currentRow, info); if (nextTeam != null && nextTeam.getTeamId() != null) { teamList.add(nextTeam); } else break; } rowNumber += 1; } if (Main.LOG_LEVEL >= 1) { /*for (int x = 0; x < teamList.size(); x++) { System.out.println(teamList.get(x)); }*/ System.out.println(new java.util.Date() + " [INFO] Input parsed. Constructing possible matches..."); } return teamList; }
From source file:courtscheduler.persistence.CourtScheduleIO.java
License:Apache License
public short getColumnWidth(File file) throws Exception { FileInputStream fis = new FileInputStream(file); XSSFWorkbook wb = new XSSFWorkbook(fis); // Get worksheet by index XSSFSheet sh = wb.getSheetAt(0); short columnWidth = 0; Integer rowCounter = 0;/*from w w w . j a va2 s .com*/ Integer rowCount = sh.getLastRowNum(); while (rowCounter <= rowCount) { Row currentRow = sh.getRow(rowCounter); short columnCount = currentRow.getLastCellNum(); if (columnCount > columnWidth) columnWidth = columnCount; } return columnWidth; }
From source file:coverageqc.functions.MyExcelEditor.java
public static void excelFormator(XSSFSheet currentSheet, File variantTsvFile, String tsvHeadingLine) throws IOException { String[] headingsArray = tsvHeadingLine.split("\t"); HashMap<String, Integer> headings = new HashMap<String, Integer>(); for (int x = 0; x < headingsArray.length; x++) { headings.put(headingsArray[x].substring(0, headingsArray[x].indexOf("_")), x); }//from ww w .j a v a 2s.com XSSFPrintSetup printSetup = (XSSFPrintSetup) currentSheet.getPrintSetup(); File xslxTempFile = new File(variantTsvFile.getCanonicalPath() + ".coverage_qc.xlsx"); currentSheet.getHeader().setLeft(xslxTempFile.getName()); currentSheet.getHeader().setRight("DO NOT DISCARD!!! Keep with patient folder."); //in Dr. Carter's VBA was set at points 18 which is .25 inches currentSheet.setMargin(Sheet.RightMargin, .25); currentSheet.setMargin(Sheet.LeftMargin, .25); printSetup.setOrientation(PrintOrientation.LANDSCAPE); //NOTE: setFitWidth doesn't work for columns, ie can't setFitToPageColumns, this //is the best workaround I can do, it will only looked cramped for those with a lot of calls printSetup.setFitWidth((short) 1); printSetup.setFitHeight((short) 3); currentSheet.setRepeatingRows(CellRangeAddress.valueOf("1")); currentSheet.setFitToPage(true); //making it by default not print the fellow's interp currentSheet.getWorkbook().setPrintArea(0, 1, currentSheet.getRow(0).getPhysicalNumberOfCells(), 0, currentSheet.getLastRowNum()); for (int x = 0; x < currentSheet.getRow(0).getPhysicalNumberOfCells(); x++) { currentSheet.autoSizeColumn(x); } currentSheet.setColumnWidth(0, 10000); currentSheet.setColumnWidth(1, 10000); currentSheet.setColumnWidth(headings.get("Consequence").intValue() + 2, 3500); currentSheet.setColumnHidden(headings.get("Classification").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Inherited From").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Allelic Depths").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Custom Annotation").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Custom Gene Annotation").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Num Transcripts").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Transcript").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("cDNA Position").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("CDS Position").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Protein Position").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Amino Acids").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Codons").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("HGNC").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Transcript HGNC").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Canonical").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Sift").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("PolyPhen").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("ENSP").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("HGVSc").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("HGVSp").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("dbSNP ID").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Ancestral Allele").intValue() + 2, true); currentSheet.setColumnHidden(headings.get("Allele Freq").intValue() + 2, true); //everything beyond this is hidden for (int x = headings.get("Global Minor Allele").intValue() + 2; x < currentSheet.getRow(0) .getPhysicalNumberOfCells(); x++) { currentSheet.setColumnHidden(x, true); } }
From source file:coverageqc.functions.MyExcelGenerator.java
public void excelFormator(String sheetName, File variantTsvFile) throws IOException { // String[] headingsArray = tsvHeadingLine.split("\t"); // HashMap<String, Integer> headings = new HashMap<String, Integer>(); // for(int x = 0; x < headingsArray.length; x++) { // headings.put(headingsArray[x].substring(0, headingsArray[x].indexOf("_")), x); // }/*from www. j a va 2 s .co m*/ XSSFSheet currentSheet = this.workbookcopy.getSheet(sheetName); XSSFPrintSetup printSetup = (XSSFPrintSetup) currentSheet.getPrintSetup(); File xslxTempFile = new File(variantTsvFile.getCanonicalPath() + ".coverage_qc.xlsx"); currentSheet.getHeader().setLeft(xslxTempFile.getName()); currentSheet.getHeader().setRight("DO NOT DISCARD!!! Keep with patient folder."); //in Dr. Carter's VBA was set at points 18 which is .25 inches currentSheet.setMargin(Sheet.RightMargin, .25); currentSheet.setMargin(Sheet.LeftMargin, .25); printSetup.setOrientation(PrintOrientation.LANDSCAPE); //NOTE: setFitWidth doesn't work for columns, ie can't setFitToPageColumns, this //is the best workaround I can do, it will only looked cramped for those with a lot of calls printSetup.setFitWidth((short) 1); printSetup.setFitHeight((short) 3); currentSheet.setRepeatingRows(CellRangeAddress.valueOf("1")); currentSheet.setFitToPage(true); //making it by default not print the fellow's interp currentSheet.getWorkbook().setPrintArea(0, 2, 20, 0, currentSheet.getLastRowNum()); for (int x = 0; x < currentSheet.getRow(0).getPhysicalNumberOfCells(); x++) { currentSheet.autoSizeColumn(x); if (x > 33) { currentSheet.setColumnHidden(x, true); } } currentSheet.setColumnWidth(0, 10000); currentSheet.setColumnWidth(1, 10000); currentSheet.setColumnWidth(2, 10000); // currentSheet.setColumnWidth(this.tsvRearrangeConversion.get(this.originalHeadings.get("Consequence"))+3, 3500); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Gene"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Variant"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Chr"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Coordinate"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Type"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Genotype"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Exonic"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Filters"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Quality"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("GQX"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Alt Variant Freq"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Read Depth"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Alt Read Depth"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Consequence"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Sift"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("PolyPhen"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Allele Freq Global Minor"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Classification"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Inherited From"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Allelic Depths"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Custom Annotation"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Custom Gene Annotation"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Num Transcripts"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Transcript"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("cDNA Position"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("CDS Position"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Protein Position"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Amino Acids"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Codons"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("HGNC"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Transcript HGNC"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Canonical"))+3, true); // //currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Sift"))+3, false); // //currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("PolyPhen"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("ENSP"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("HGVSc"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("HGVSp"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("dbSNP ID"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Ancestral Allele"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Global Minor Allele"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Allele Freq Amr"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Allele Freq Asn"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Allele Freq Af"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Allele Freq Eur"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Allele Freq Evs"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("EVS Coverage"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("EVS Samples"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Conserved Sequence"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("COSMIC ID"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("COSMIC Wildtype"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("COSMIC Allele"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("COSMIC Gene"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("COSMIC Primary Site"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("COSMIC Histology"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("ClinVar Accession"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("ClinVar Ref"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("ClinVar Alleles"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("ClinVar Allele Type"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("ClinVar Significance"))+3, false); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Alternate Alleles"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("Google Scholar"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("PubMed"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("UCSC Browser"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("ClinVar RS"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("ClinVar Disease Name"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("ClinVar MedGen"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("ClinVar OMIM"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("ClinVar Orphanet"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("ClinVar GeneReviews"))+3, true); // currentSheet.setColumnHidden(this.tsvRearrangeConversion.get(this.originalHeadings.get("ClinVar SnoMedCt ID"))+3, true); }