pandas read excel data type code example

Example 1: pandas read excel

import pandas as pd
pd.read_excel('tmp.xlsx’, sheet_name='Sheet1')

Example 2: pandas read from excel

import pandas as pd
pandas.read_excel(io, sheet_name=0, header=0, names=None,
                  index_col=None, usecols=None, 
                  squeeze=False, dtype=None, engine=None, 
                  converters=None, true_values=None, 
                  false_values=None, skiprows=None, 
                  nrows=None, na_values=None, 
                  keep_default_na=True, verbose=False, 
                  parse_dates=False, date_parser=None, 
                  thousands=None, comment=None, 
                  skipfooter=0, convert_float=True, 
                  mangle_dupe_cols=True, **kwds)

# Example
pd.read_excel('tmp.xlsx', index_col=0)

Example 3: excel reading

How do you do test using excel files in Java?
I use Apache POI libraries to read and write from excel file, 
I add the Apache POI dependencies to my pom file.
In order to connect I use following classes.
 	-FileInputStream from Java. it is used to create connection to the file.
    We pass the file path as constructor to it.
 	-WorkBook is a class that represents the excel file.  
    We create Workbook object using the FileInputStream object.
 	-Sheet represents a single sheet from the excel file.
    We create sheet using Workbook object. We can create 
    worksheet using the 0 based index.

   public String readExcel(String path, String sheetName, 
                                                 int rowNum, int colNum) {
        try {
            FileInputStream file = new FileInputStream(path);
            Workbook book = WorkbookFactory.create(file);
            Sheet sheet = book.getSheet(sheetName);
            Row row = sheet.getRow(rowNum);
	    	Cell cell = row.getCell(colNum);
            String cellData = cell.toString();
            return cellData;
        } catch (Exception e) {
            throw new RuntimeException(e);
        }
    }

How to get row and column numbers:
    int rowCount = sheet.getLastRowNum()+1; ==> why we add '+1'?
                                   Because row num starts from 0.
    int colCount = sheet.getRow(0).getLastCellNum();
    String sheetName = workSheet.getSheetName();