package testingtest;
import java.io.File;
import java.io.IOException;
import java.util.HashMap;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
class testclass {
static String[][] getexceldatainArray;
static HashMap<String, String> dictionary;
public static void main(String[] args) throws IOException, BiffException {
// Create an array based on data in excel file
excelarrayclass tc = new excelarrayclass();
getexceldatainArray = tc.CreateArrayfromExcel("D:\\Testing.xls",
"testing");
for (int i = 0; i < getexceldatainArray.length; i++) {
dictionary = DataDictionaryFromArray(getexceldatainArray, i);
// the keys will be value in the header column
String username = dictionary.get("UserName");
/*
* Perform the required operation using the dictionary values
*/
System.out.println("UserName " + username);
}
}
public String[][] CreateArrayfromExcel(String WorkbookName, String SheetName)
throws BiffException, IOException {
String[][] arrTestDta;
Workbook workbk = Workbook.getWorkbook(new File(WorkbookName));
Sheet wrkSheet = workbk.getSheet(SheetName);
arrTestDta = new String[wrkSheet.getRows()][wrkSheet.getColumns()];
// Loop to get data from excel file into an array
for (int i = 0; i < wrkSheet.getRows(); i++) {
for (int j = 0; j < wrkSheet.getColumns(); j++) {
Cell cell = wrkSheet.getCell(j, i);
if (cell.getContents() != null) {
arrTestDta[i][j] = cell.getContents();
}
}
}
return arrTestDta;
}
public static HashMap<String, String> DataDictionaryFromArray(
String[][] arrayforDictionary, int iRow) {
// Create a hashmap to store the data as dictionary in key value form
HashMap<String, String> dictionary = new HashMap<String, String>();
// get the size of the array, assuming being used in data driven test,
// get the number of columns in the data file
int iColCnt = arrayforDictionary[0].length;
for (int i = 0; i < iColCnt; i++) {
// mark the header column values as key and current column value as
// key value pair
dictionary.put(arrayforDictionary[0][i],
arrayforDictionary[iRow][i]);
}
return dictionary;
}
}
I see you have all lower case letters, which is not very much readable. ex: excelarrayclass (You can have it s ExcelArrayClass)
ReplyDeleteThanks Moin for the observation. Will correct the code and update and totally agree that variable should be defined in Camel case instead of lower or upper case.
ReplyDeleteThanks a lot for contributing
awesome
ReplyDeletehttps://bayanlarsitesi.com/
ReplyDeleteManisa
Denizli
Malatya
Çankırı
PD2JOD
Malatya
ReplyDeleteKırıkkale
Aksaray
Bitlis
Manisa
04C
elazığ
ReplyDeletetekirdağ
kars
sakarya
antep
GPDQU4
görüntülüshow
ReplyDeleteücretli show
OS26
Kastamonu Lojistik
ReplyDeleteYozgat Lojistik
Çorlu Lojistik
Kırşehir Lojistik
Sinop Lojistik
JB3G6
kırklareli evden eve nakliyat
ReplyDeleteısparta evden eve nakliyat
istanbul evden eve nakliyat
ankara evden eve nakliyat
kırıkkale evden eve nakliyat
CKMP
7F5B5
ReplyDeleteDiyarbakır Şehirler Arası Nakliyat
Okex Güvenilir mi
MEME Coin Hangi Borsada
Bayburt Şehir İçi Nakliyat
Düzce Lojistik
Aion Coin Hangi Borsada
Malatya Parça Eşya Taşıma
Adana Parça Eşya Taşıma
Lbank Güvenilir mi
7E4AF
ReplyDeleteanapolon oxymetholone for sale
buy oxandrolone anavar
Silivri Çatı Ustası
buy steroids
order sustanon
Eskişehir Evden Eve Nakliyat
Balıkesir Evden Eve Nakliyat
Silivri Parke Ustası
Tekirdağ Çatı Ustası
24EB0
ReplyDelete%20 binance referans kodu
2EEBE
ReplyDeletebinance indirim
A51B7
ReplyDeleteShibanomi Coin Hangi Borsada
Lunc Coin Hangi Borsada
Coin Çıkarma
Görüntülü Sohbet
Binance Referans Kodu
Twitter Retweet Satın Al
Milyon Coin Hangi Borsada
Coin Nasıl Oynanır
Clubhouse Takipçi Hilesi
E7198
ReplyDeleteFacebook Beğeni Hilesi
Twitter Retweet Satın Al
Arbitrum Coin Hangi Borsada
Coin Nasıl Üretilir
Bitcoin Nedir
Aion Coin Hangi Borsada
Btcst Coin Hangi Borsada
Arg Coin Hangi Borsada
Parasız Görüntülü Sohbet
B9412
ReplyDeleteKwai Beğeni Hilesi
Parasız Görüntülü Sohbet
Satoshi Coin Hangi Borsada
Casper Coin Hangi Borsada
Görüntülü Sohbet
Binance Referans Kodu
Btcturk Borsası Güvenilir mi
Binance Hangi Ülkenin
Binance Nasıl Oynanır
F6673
ReplyDeleteBitcoin Para Kazanma
Bitcoin Kazanma
Likee App Beğeni Hilesi
Bitcoin Nedir
Binance Yaş Sınırı
Big Wolf Coin Hangi Borsada
Luffy Coin Hangi Borsada
Instagram Beğeni Satın Al
Coin Nasıl Kazılır
1D06E
ReplyDeleteAzero Coin Hangi Borsada
Lunc Coin Hangi Borsada
Bonk Coin Hangi Borsada
Kripto Para Üretme Siteleri
Onlyfans Beğeni Hilesi
Görüntülü Sohbet Parasız
Tiktok Beğeni Hilesi
Nexa Coin Hangi Borsada
Bitcoin Nasıl Para Kazanılır