JXL (API) - JXL (API)

JXL
Tuzuvchi (lar)Andy Khan, Eric H. Jung
Barqaror chiqish
2.6.12
YozilganJava
Operatsion tizimO'zaro faoliyat platforma
TuriAPI kirish uchun Microsoft Excel format
LitsenziyaGNU GPL v2[1]
Veb-saytjexcelapi.sourceforge.net

JXL API (boshq. Java Excel API) foydalanuvchilarga varaqlarni o'qish, yozish, yaratish va o'zgartirish imkonini beradi Excel (.xls) ishchi daftar ish vaqtida. .Xlsx formatini qo'llab-quvvatlamaydi.[2]

Microsoft Excel-ni qo'llab-quvvatlash

JXL API qo'llab-quvvatlaydi Excel Excel 95, 97, 2000, XP va 2003 versiyalariga ega hujjatlar. Ushbu hujjatlar .xls kengaytmasiga ega.[2]

Foydalanish

JXL API bilan keng qo'llaniladi Selen.

Misol

Excel fayliga yozish uchun namunaviy kod quyidagicha ko'rinishi mumkin:

Import java.io.Fayl;Import jxl.Ish kitobi;Import jxl.write.WritableSheet;Import jxl.write.WritableWorkbook;Import jxl.write.Label;Import jxl.write.WriteException;jamoat sinf Tafsilotli ro'yxat{    xususiy Ish daftarchasi wbook;    xususiy WritableWorkbook wwbCopy;    xususiy WritableSheet shSheet;    jamoat bekor o'qing()    {        harakat qilib ko'ring        {            wbook = Ish daftarchasi.getWorkbook(yangi Fayl("path / testSampleData.xls"));            wwbCopy = Ish daftarchasi.yaratishWorkbook(yangi Fayl("path / testSampleDataCopy.xls"), wbook);            shSheet = wwbCopy.getSheet(0);        }        ushlamoq (Istisno e)        {            e.printStackTrace();        }    }       jamoat bekor setValueIntoCell(Ip strSheetName, int iColumnNumber, int iRowNumber, Ip strData) uloqtiradi WriteException    {        WritableSheet wshTemp = wwbCopy.getSheet(strSheetName);        Yorliq labTemp = yangi Yorliq(iColumnNumber, iRowNumber, strData);                       harakat qilib ko'ring         {            wshTemp.addCell(labTemp);        }        ushlamoq (Istisno e)        {            e.printStackTrace();        }    }       jamoat bekor closeFile()    {        harakat qilib ko'ring         {            // Yoziladigan ish kitobini yopish            wwbCopy.yozmoq();            wwbCopy.yaqin();            // Asl ish kitobini yopish            wbook.yaqin();        }        ushlamoq (Istisno e)        {            e.printStackTrace();        }    }       jamoat statik bekor asosiy(Ip[] kamon) uloqtiradi WriteException    {        Tafsilotli ro'yxat ds = yangi Tafsilotli ro'yxat();        ds.o'qing();        ds.setValueIntoCell("varaq1", 5, 1, "PASS");        ds.setValueIntoCell("varaq1", 5, 2, "YO'Q");        ds.setValueIntoCell("varaq1", 5, 3, "PASS");        ds.closeFile();    }}

[3]

Shuningdek qarang

Adabiyotlar

  1. ^ "jxl". Sourceforge. Sourceforge. Olingan 1 fevral 2016.
  2. ^ a b Sams, P. (2015). Selenium Essentials. Birmingem: Packt nashriyot Ltd p. 133.
  3. ^ "Jxl yordamida ma'lumotlarni qanday qilib Excel varag'iga o'rnatish". Selenyum oson. Selenyum oson. Olingan 1 fevral 2016.

Tashqi havolalar