#HOW TO PUT UNDERLINE IN EXCEL HOW TO#
#HOW TO PUT UNDERLINE IN EXCEL CODE#

I just realized I absolutely love coding. Step 10: Let’s open it to check if the String value “Age” has been punched into it or not: Step 9: Let’s navigate to the D: drive folder to check if the excel file has been created or not:

#HOW TO PUT UNDERLINE IN EXCEL CODE#

So now your entire code might look something like this: Step 7: You can either handle that too or simply replace the FileNotFoundException with its superset Exception like this: It is for another exception that you might encounter. When you will do so another red error underline might show up like this: Type the following for that in the try block itself: wb.write(fos) Step 6: Now we will use the write method of the XSSFWorkbook instance to actually start writing what we intended to write. You might have to import the following package for your JVM to understand the FileOutputStream Class: import java.io.FileOutputStream Īn error still might flare towards the right. Type the following: FileOutputStream fos = new FileOutputStream(file) We have put 0, 0 in them so it will populate the first cell. Step 4: Type the following to enter a String value in the first row and first column (A1) of your excel sheet: sh.createRow(0).createCell(0).setCellValue('Age') Īs you can see the parameters of createRow and createCell will be integers where you specify the row and column numbers. Then you can use any of the setCellValue methods to enter any data of your choice. Follow it up by createCell() method which identifies the column and locks a cell. How is a cell made? By rows and columns right? Time to use the above declared variable ‘sh’ for row creation first. Not writing anything will default it to Sheet0. You can choose to provide a name for the Sheet by simply typing the name of it in the parameter using double inverted commas like this: XSSFSheet sh = wb.createSheet('First Sheet') You might have to import the following package if not already imported: import .usermodel.XSSFSheet Type the following for creating a sheet: XSSFSheet sh = wb.createSheet() You might have to import the following package if not already imported: import .usermodel.XSSFWorkbook Type the following: XSSFWorkbook wb = new XSSFWorkbook() We will use the Apache POI class called XSSFWorkbook for that as we had seen in the previous tutorial. You need to specify the file format too, and hence the suffix of. Type the following: File file = new File('D:\output.xlsx') I am hoping it to show in my D: drive in a file called output. Step 1: Specify the file path where you wish the Excel Sheet to show. So now we have a method ready to take inputs in a class called Testing. Once that part is dealt with let’s focus on the coding bit.

How to do that? You can check out the previous chapter for it. Of course, if you haven’t already done it.

#HOW TO PUT UNDERLINE IN EXCEL HOW TO#

The first thing we gotta do while learning How to Write Data into Excel Sheet using Selenium Webdriver is to download and integrate Apache POI library files. How to Write Data into Excel Sheet using Selenium Webdriver The difference being just an Output Stream instead of an Input Stream, and maybe one write method that signals the JVM to start writing the data. If reading data from excel was simple for you, writing in one will be no different. We had learned how to read data from an Excel Sheet, now we are going to see how to write data into excel sheet using Selenium Webdriver.

How to put underline in excel