KaneAI - World’s First E2E Software Testing Agent.Book a Demo 
How to use createSheet method of com.testsigma.util.XLSUtil class
Best Testsigma code snippet using com.testsigma.util.XLSUtil.createSheet
Source:TestPlanResultService.java 
...206 if(isConsolidatedReport) {207 wrapper.getWorkbook().setSheetOrder("Consolidated Result Summary", 0);208 return;209 }210 wrapper.createSheet();211 }212 this.findConsolidatedResultByTestPlanId(testPlanResult);213 this.export(testPlanResult,wrapper,true);214 }215 private void findConsolidatedResultByTestPlanId(TestPlanResult testPlanResult) {216 TestPlanResult childResult = testPlanResult.getTestPlan().getLastRun();217 TestPlanResult tempChildResult = testPlanResult.getChildResult();218 setConsolidatedResults(testPlanResult,childResult);219 while (tempChildResult != null) {220 if(ReRunType.runFailedTestCases(tempChildResult.getReRunType())) {221 testPlanResult.setConsolidatedPassedCount(testPlanResult.getPassedCount() + tempChildResult.getPassedCount());222 }223 else {224 testPlanResult.setConsolidatedPassedCount(tempChildResult.getPassedCount());...
Source:XLSUtil.java
...42 *43 */44 public XLSUtil() {45 workbook = new SXSSFWorkbook(100);46 sheet = workbook.createSheet();47 createHelper = workbook.getCreationHelper();48 initStyles();49 }50 /**51 * creates, assigns value and apply styles to Cell52 *53 * @param headingRow54 * @param columnCount55 * @param value56 * @param colorStyle57 * @return Cell58 */59 public static Cell createColumn(Row headingRow, int columnCount, Object value, CellStyle colorStyle) {60 Cell sectionNameCell = setValue(headingRow, columnCount, value);61 sectionNameCell.setCellStyle(colorStyle);62 return sectionNameCell;63 }64 /**65 * Set cell value based on type66 *67 * @param row68 * @param index69 * @param value70 * @return Cell71 */72 private static Cell setValue(Row row, int index, Object value) {73 Cell cell = row.createCell(index);74 if (value != null) {75 if (value.getClass().equals(String.class)) {76 cell.setCellValue((String) value);77 } else if (value.getClass().equals(Integer.class)) {78 cell.setCellValue((Integer) value);79 } else if (value.getClass().equals(Long.class)) {80 cell.setCellValue((Long) value);81 } else if (value.getClass().equals(Double.class)) {82 cell.setCellValue((Double) value);83 } else if (value.getClass().equals(Date.class)) {84 cell.setCellValue((Date) value);85 } else if (value.getClass().equals(Float.class)) {86 cell.setCellValue((Float) value);87 }88 }89 return cell;90 }91 /**92 * Returns header style with Black background93 *94 * @param wrapper95 * @return CellStyle96 */97 public static CellStyle getTableHeaderStyle(XLSUtil wrapper) {98 CellStyle colorStyle = wrapper.getWorkbook().createCellStyle();99 //set background color black100 colorStyle.setWrapText(true);101 colorStyle.setFillForegroundColor(HSSFColor.BLACK.index);102 colorStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);103 //text color white and style bold104 Font font = wrapper.getWorkbook().createFont();105 font.setColor(HSSFColor.WHITE.index);106 font.setBoldweight(Font.BOLDWEIGHT_BOLD);107 colorStyle.setFont(font);108 font.setBold(true);109 //align center110 colorStyle.setAlignment(CellStyle.ALIGN_CENTER);111 colorStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);112 return colorStyle;113 }114 /**115 * Return vertical center align style116 *117 * @param wrapper118 * @return CellStyle119 */120 public static CellStyle getAlignStyle(XLSUtil wrapper) {121 CellStyle style = wrapper.getWorkbook().createCellStyle();122 style.setWrapText(true);123 style.setAlignment(CellStyle.ALIGN_LEFT);124 return style;125 }126 public static CellStyle getSecondAlignStyle(XLSUtil wrapper) {127 CellStyle style = wrapper.getWorkbook().createCellStyle();128 style.setWrapText(true);129 style.setAlignment(CellStyle.ALIGN_LEFT);130 Font font = wrapper.getWorkbook().createFont();131 font.setBoldweight(Font.BOLDWEIGHT_BOLD);132 style.setFont(font);133 return style;134 }135 /**136 *137 */138 public void initStyles() {139 if (workbook != null) {140 cellDateStyle = workbook.createCellStyle();141 cellDateStyle.setDataFormat(createHelper.createDataFormat().getFormat("mmm-yy"));142 }143 }144 /**145 * @return Row146 */147 public Row getHeaderRow() {148 Row row = this.getSheet().getRow(0);149 if (null == row) {150 row = this.getSheet().createRow(0);151 }152 return row;153 }154 public Row getDataRow(XLSUtil excel, int newRowIndex) {155 Row row = excel.getSheet().getRow(newRowIndex);156 if (null == row) {157 row = excel.getSheet().createRow(newRowIndex);158 }159 return row;160 }161 /**162 * @return CellStyle163 */164 public CellStyle getHeaderStyle() {165 CellStyle style = this.getWorkbook().createCellStyle();166 getHeaderRow().setRowStyle(style);167 Font font = this.getWorkbook().createFont();168 font.setFontHeightInPoints((short) 10);169 font.setFontName("Arial");170 font.setColor(IndexedColors.WHITE.getIndex());171 font.setBoldweight(Font.BOLDWEIGHT_BOLD);172 font.setItalic(false);173 style = getHeaderRow().getRowStyle();174 style.setFillPattern(CellStyle.SOLID_FOREGROUND);175 style.setFillBackgroundColor(IndexedColors.AQUA.getIndex());176 style.setAlignment(CellStyle.ALIGN_CENTER);177 style.setFont(font);178 style.setFillBackgroundColor(HSSFColor.GREY_25_PERCENT.index);179 return style;180 }181 /**182 * @return CellStyle183 */184 public CellStyle getCellDateStyle() {185 return cellDateStyle;186 }187 /**188 * @param dateStr189 * @return Date190 */191 public Date getDateType(String dateStr) {192 Date date = new Date();193 date.setTime(0);194 if (null != dateStr) {195 try {196 date = new SimpleDateFormat("MMM-yy", Locale.US).parse(dateStr);197 } catch (ParseException e) {198 try {199 date = new SimpleDateFormat("MMMMM yyyy", Locale.US).parse(dateStr);200 } catch (ParseException e1) {201 // TODO Auto-generated catch block202 e1.printStackTrace();203 }204 }205 }206 return date;207 }208 public String getRunDate() {209 SimpleDateFormat sdfDate = new SimpleDateFormat("MM/dd/yyyy");210 Date now = new Date();211 String strDate = sdfDate.format(now);212 return strDate;213 }214 public String getRunTime() {215 SimpleDateFormat sdfDate = new SimpleDateFormat("h:mm a");216 Date now = new Date();217 String strDate = sdfDate.format(now);218 return strDate;219 }220 public void evaluateAll() {221 if (createHelper != null) {222 FormulaEvaluator evaluator = createHelper.createFormulaEvaluator();223 evaluator.evaluateAll();224 }225 }226 /**227 * @return SXSSFWorkbook228 */229 public SXSSFWorkbook getWorkbook() {230 return workbook;231 }232 /**233 * @return Sheet234 */235 public Sheet getSheet() {236 return sheet;237 }238 /**239 * @param sheet240 */241 public void setSheet(Sheet sheet) {242 this.sheet = sheet;243 }244 /**245 * @param name246 * @return Sheet247 */248 public Sheet createSheet(String name) {249 this.sheet = this.getWorkbook().createSheet(name);250 return this.sheet;251 }252 public Sheet createSheet() {253 this.sheet = this.getWorkbook().createSheet();254 return this.sheet;255 }256 /**257 * @return int258 */259 public int getCurrentRow() {260 return row;261 }262 /**263 * @param rowNum264 */265 public void setCurrentRow(int rowNum) {266 this.row = rowNum;267 }...
createSheet
Using AI Code Generation
1package com.testsigma.util;2import java.io.File;3import java.io.IOException;4import java.util.ArrayList;5import java.util.List;6import org.apache.poi.ss.usermodel.Cell;7import org.apache.poi.ss.usermodel.Row;8import org.apache.poi.ss.usermodel.Sheet;9import org.apache.poi.ss.usermodel.Workbook;10import org.apache.poi.xssf.usermodel.XSSFWorkbook;11public class XLSUtil {12public static void main(String[] args) throws IOException {13String fileName = "D:\\test.xlsx";14File file = new File(fileName);15Workbook workbook = null;16if (file.exists()) {17workbook = new XSSFWorkbook(file);18} else {19workbook = new XSSFWorkbook();20}21Sheet sheet = createSheet(workbook, "TestSheet");22Row row = sheet.createRow(0);23Cell cell = row.createCell(0);24cell.setCellValue("Test");25workbook.write(file);26}27public static Sheet createSheet(Workbook workbook, String sheetName) {28Sheet sheet = workbook.getSheet(sheetName);29if (sheet == null) {30sheet = workbook.createSheet(sheetName);31}32return sheet;33}34}
createSheet
Using AI Code Generation
1package com.testsigma.examples;2import com.testsigma.util.XLSUtil;3public class CreateSheet {4 public static void main(String[] args) {5 XLSUtil xlsUtil = new XLSUtil();6 xlsUtil.createSheet("C:\\test\\Book1.xls", "Sheet2");7 }8}9package com.testsigma.examples;10import com.testsigma.util.XLSUtil;11public class CreateSheet {12 public static void main(String[] args) {13 XLSUtil xlsUtil = new XLSUtil();14 xlsUtil.createSheet("C:\\test\\Book1.xls", "Sheet1");15 }16}17package com.testsigma.examples;18import com.testsigma.util.XLSUtil;19public class CreateSheet {20 public static void main(String[] args) {21 XLSUtil xlsUtil = new XLSUtil();22 xlsUtil.createSheet("C:\\test\\Book1.xls", "Sheet1");23 }24}25package com.testsigma.examples;26import com.testsigma.util.XLSUtil;27public class CreateSheet {28 public static void main(String[] args) {29 XLSUtil xlsUtil = new XLSUtil();30 xlsUtil.createSheet("C:\\test\\Book1.xls", "Sheet1");31 }32}33package com.testsigma.examples;34import com.testsigma.util.XLSUtil;35public class CreateSheet {36 public static void main(String[] args) {37 XLSUtil xlsUtil = new XLSUtil();38 xlsUtil.createSheet("C:\\test\\Book1.xls", "Sheet1");39 }40}41package com.testsigma.examples;42import com.testsigma.util.XLSUtil;43public class CreateSheet {44 public static void main(String[] args) {45 XLSUtil xlsUtil = new XLSUtil();46 xlsUtil.createSheet("C:\\test\\Book1.xls", "Sheet1");47 }48}
createSheet
Using AI Code Generation
1import com.testsigma.util.XLSUtil;2import java.io.File;3import java.io.IOException;4public class 2 {5public static void main(String[] args) throws IOException {6XLSUtil xlsUtil = new XLSUtil();7File file = new File("C:/Users/Downloads/Book1.xlsx");8xlsUtil.createSheet(file, "Sheet2");9}10}11How to create a new excel file with a new sheet using createSheet() method of XLSUtil class?12import com.testsigma.util.XLSUtil;13import java.io.File;14import java.io.IOException;15public class 3 {16public static void main(String[] args) throws IOException {17XLSUtil xlsUtil = new XLSUtil();18File file = new File("C:/Users/Downloads/newBook.xlsx");19xlsUtil.createSheet(file, "Sheet1");20}21}22How to create a new sheet in an existing excel file using createSheet() method of XLSUtil class?23import com.testsigma.util.XLSUtil;24import java.io.File;25import java.io.IOException;26public class 4 {27public static void main(String[] args) throws IOException {28XLSUtil xlsUtil = new XLSUtil();29File file = new File("C:/Users/Downloads/Book1.xlsx");30xlsUtil.createSheet(file, "Sheet3");31}32}33How to create a new sheet in an existing excel file using createSheet() method of XLSUtil class?34import com.testsigma.util.XLSUtil;35import java.io.File;36import java.io.IOException;37public class 5 {38public static void main(String[] args) throws IOException {39XLSUtil xlsUtil = new XLSUtil();40File file = new File("
createSheet
Using AI Code Generation
1package com.testsigma.test;2import com.testsigma.util.XLSUtil;3public class TestXLSUtil {4public static void main(String[] args) {5XLSUtil xlsUtil = new XLSUtil();6xlsUtil.createSheet("C:\\Users\\testsigma\\Desktop\\test.xls", "TestSheet");7}8}9package com.testsigma.test;10import com.testsigma.util.XLSUtil;11public class TestXLSUtil {12public static void main(String[] args) {13XLSUtil xlsUtil = new XLSUtil();14xlsUtil.createSheet("C:\\Users\\testsigma\\Desktop\\test.xls", "TestSheet", 0);15}16}17package com.testsigma.test;18import com.testsigma.util.XLSUtil;19public class TestXLSUtil {20public static void main(String[] args) {21XLSUtil xlsUtil = new XLSUtil();22xlsUtil.createSheet("C:\\Users\\testsigma\\Desktop\\test.xls", "TestSheet", 0, 0);23}24}25package com.testsigma.test;26import com.testsigma.util.XLSUtil;27public class TestXLSUtil {28public static void main(String[] args) {29XLSUtil xlsUtil = new XLSUtil();30xlsUtil.createSheet("C:\\Users\\testsigma\\Desktop\\test.xls", "TestSheet", 0, 0, 0);31}32}33package com.testsigma.test;34import com.testsigma.util.XLSUtil;35public class TestXLSUtil {36public static void main(String[] args) {37XLSUtil xlsUtil = new XLSUtil();38xlsUtil.createSheet("C:\\Users\\testsigma\\Desktop\\test.xls", "TestSheet", 0, 0, 0, 0);39}40}41package com.testsigma.test;42import com.testsigma.util.XLSUtil;43public class TestXLSUtil {
createSheet
Using AI Code Generation
1import com.testsigma.util.XLSUtil;2{3public static void main(String[] args)4{5String xlsFile = "C:\\test.xls";6String sheetName = "Sheet1";7XLSUtil xlsUtil = new XLSUtil();8xlsUtil.createSheet(xlsFile, sheetName);9}10}11import com.testsigma.util.XLSUtil;12{13public static void main(String[] args)14{15String xlsFile = "C:\\test.xls";16String sheetName = "Sheet1";17String[] rowData = {"1", "2", "3"};18XLSUtil xlsUtil = new XLSUtil();19xlsUtil.addRow(xlsFile, sheetName, rowData);20}21}22import com.testsigma.util.XLSUtil;23{24public static void main(String[] args)25{26String xlsFile = "C:\\test.xls";27String sheetName = "Sheet1";28int rowNum = 0;29int cellNum = 0;30String cellValue = "A1";31XLSUtil xlsUtil = new XLSUtil();32xlsUtil.addCell(xlsFile, sheetName, rowNum, cellNum, cellValue);33}34}35import com.testsigma.util.XLSUtil;36{37public static void main(String[] args)38{39String xlsFile = "C:\\test.xls";40String sheetName = "Sheet1";41int rowNum = 0;42int cellNum = 0;43String cellValue = "A1";44XLSUtil xlsUtil = new XLSUtil();45xlsUtil.setCellValue(xlsFile, sheetName, rowNum, cellNum, cellValue);46}47}
createSheet
Using AI Code Generation
1import com.testsigma.util.XLSUtil;2public class 2 {3public static void main(String[] args) {4XLSUtil.createSheet("C:\\Users\\Desktop\\test.xls","Sheet1");5}6}7import com.testsigma.util.XLSUtil;8public class 3 {9public static void main(String[] args) {10XLSUtil.createSheet("C:\\Users\\Desktop\\test.xls","Sheet1","Sheet2");11}12}13import com.testsigma.util.XLSUtil;14public class 4 {15public static void main(String[] args) {16XLSUtil.createSheet("C:\\Users\\Desktop\\test.xls","Sheet1","Sheet2","Sheet3");17}18}19import com.testsigma.util.XLSUtil;20public class 5 {21public static void main(String[] args) {22XLSUtil.createSheet("C:\\Users\\Desktop\\test.xls","Sheet1","Sheet2","Sheet3","Sheet4");23}24}25import com.testsigma.util.XLSUtil;26public class 6 {27public static void main(String[] args) {28XLSUtil.createSheet("C:\\Users\\Desktop\\test.xls","Sheet1","Sheet2","Sheet3","Sheet4","Sheet5");29}30}31import com.testsigma.util.XLSUtil;32public class 7 {33public static void main(String[] args) {34XLSUtil.createSheet("C:\\Users\\Desktop\\test.xls","Sheet1","Sheet2
Automation Testing Tutorials
Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.
LambdaTest Learning Hubs:
- JUnit Tutorial
- TestNG Tutorial
- Webdriver Tutorial
- WebDriverIO Tutorial
- Protractor Tutorial
- Selenium 4 Tutorial
- Jenkins Tutorial
- NUnit Tutorial
- Jest Tutorial
- Playwright Tutorial
- Cypress Tutorial
- PyTest Tutorial
YouTube
You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.
Run Testsigma automation tests on LambdaTest cloud grid
Perform automation testing on 3000+ real desktop and mobile devices online.
Most used method in XLSUtil
- XLSUtil
- createColumn
- setValue
- getTableHeaderStyle
- getAlignStyle
- getSecondAlignStyle
- initStyles
- getHeaderRow
- getDataRow
- getHeaderStyle
- getCellDateStyle
- getDateType
- getRunDate
- getRunTime
- evaluateAll
- getWorkbook
- getSheet
- setSheet
- createSheet
- getCurrentRow
- setCurrentRow
- getNewRow
- incRow
- getStatus
- setStatus
- writeToStream
- getBrowserName
Try LambdaTest Now !!
Get 100 minutes of automation test minutes FREE!!
Was this article helpful?
