paint-brush
Iyo yepamusoro Java Excel API Maraibhurariby@mesciusinc
464 kuverenga
464 kuverenga

Iyo yepamusoro Java Excel API Maraibhurari

by MESCIUS inc.11m2024/09/17
Read on Terminal Reader

Kurebesa; Kuverenga

Ongorora maraibhurari epamusoro eJava Excel API zvichienderana nezvaanoona.
featured image - Iyo yepamusoro Java Excel API Maraibhurari
MESCIUS inc. HackerNoon profile picture
0-item

Iyo yakakodzera Java Excel API raibhurari yeJava application ine ese maficha aunoda kuti uite Excel mashandiro sekunge uri kushandisa chinhu chaicho. Izvo zvakagadzirirwa kubvumira vanogadzira kuita mabasa makuru nechero shoma yebasa. Iyi positi inoongorora epamusoro Java Excel raibhurari nekuongorora zvinotevera maficha:


  • Gadzira, verenga, uye gadzirisa mafaira eXLSX
  • Yakakwana Excel-inoenderana charting
  • Sero uye siyana mashandiro
  • Kutarisira pepa rekushanda
  • Shandisa matemplate eExcel reporting
  • Kusefa uye nemamiriro ekufomatidza
  • Formulas uye mabasa
  • Kusunga data uye kuunza / kutumira kunze
  • Verenga uye nyora password-yakachengetedzwa XLSX uye XLSM mabhuku ebasa
  • Kuita uye kushanda zvakanaka
  • Kubatanidzwa neclient-side data viewer


Gwaro Mhinduro dzeExcel, Java Edition (DsExcel) naMESCIUS

Document Solutions yeExcel, Java Edition (DsExcel) iraibhurari yeJava Excel yakagadzirirwa kurerutsa kugadzirwa, kushandura, uye kugadzirisa mafaera eExcel mukati meJava application. Inopa vanogadzira intuitive API yekuverenga, kunyora, uye fomati Excel mafaera, kubvisa kudiwa kweMicrosoft Excel kana mamwe echitatu-bato raibhurari.


Gadzira, Verenga, uye Shandura Mafaira eXLSX

Unogona kugadzira, kurodha, kugadzirisa, uye kuchengetedza Excel XLSX maspredishiti.

Yakakwana Excel-Inoenderana Charting

DsExcel inotsigira kubatanidza marudzi akasiyana-siyana emachati mumapepa ekushanda uye inopa maitiro ekugadzirisa ezvinyorwa zvechati, ngano, nhepfenyuro yedata, nezvimwe. Iwe zvakare unokwanisa kuwedzera machati mune template marongero.

Sero uye Range Operations

Tora uye uise ese masitaira uye fomula marongero, pakati pezvimwe, pamaseru, mitsetse, kana makoramu muExcel zvinyorwa nerubatsiro rweRange pfuma yeIWorksheet interface inosanganisirwa muraibhurari yavo yeAPI.

Mashandiro eMapepa ekushanda

Kuburikidza nekushandiswa kwebhuku rebasa uye zvinhu zvepepa rebasa, unogona kugadzira, kuendesa kunze, kutumira kunze, kushandisa mapassword, kuwedzera mashizha, kucheka uye kukopa renji, kukopa uye kufambisa mapepa ekushanda, kumisa, kugadzirisa, kudzima, kudzivirira, uye kuwedzera maverengero ekudzokorora.

Automate Excel Mishumo Uchishandisa XLSX Matemplate

Vaka nyanzvi dzeExcel Reports Uchishandisa .XLSX Matemplate. Define Excel templates muJava kuti igadzirise uye ibudise mishumo yakazara .xlsx, yakadai semainvoice, marepoti ekutengesa, marisiti, mavara ekutumira, maodha ekutenga, nezvimwe, zvine syntax yakazara uye API yekubatanidza zviri nyore kumifananidzo uye kugadzira tsika yepamusoro uye yakaoma Excel. inoshuma.

Kusefa uye Conditional Formatting

Sefa maseru uchishandisa qualifiers, kusanganisira data, zvinyorwa, nhamba, ruvara, uye zvidhori. Iwe unogona zvakare kuratidza chaiyo data nekusimbisa humwe hunhu uchishandisa conditional fomati.

Formulas uye Mabasa

Iwe unogona kugadzira uye kushandisa mafomula kuverenga maseru kukosha. DsExcel inotsigirawo anopfuura 450 Excel mabasa . Iwe unogona kushandisa akavakirwa-mukati mabasa kana kugadzira ako akagadziridzwa mabasa.

Kusunga data uye Kupinza / Kutumira kunze

DsExcel inotsigira imwe-nzira inosunga data nesero, pepa rekushanda, uye tafura inosunga kune akasiyana dhata masosi kuti zvizadze nyore data rako otomatiki. Iwe unogona kushandisa akawanda masosi kuzadza iyo data. Kupinza nekukurumidza uye kwakanyatso shanda, unogona kupinza chete data kubva kuExcel mafaera pane iyo yese modhi yechinhu. Unogona kutumira data kune akasiyana mafomati, akadai .xlsx, PDF, .csv, HTML, JSON, nezvimwe.

Verenga uye Nyora Password-Yakachengetedzwa XLSX uye XLSM Workbooks

Iwe unogona kugadzirisa kuchengetedza kwebhuku rako rekushanda uchishandisa mapassword anodzivirira kudhindwa kwedata kana kushandura chimiro chebhuku rebasa nemahwindo. Iwe unogona zvakare kubvisa zvachose password yebhuku rebasa rekuchengetedza pakugadzirisa kusingabvumirwe.

Kuita uye Kubudirira

DsExcel inomhanya zvakapetwa kaviri sevamwe vakwikwidzi uye inoshandisa ndangariro shoma.

Batanidza neClient-Side Data Viewer


DsExcel inopa JavaScript Data Viewer , iyo inobvumira vanogadzira kuvaka muchinjika-chikuva chewebhu maapplication uye kurodha uye kuona magwaro edatha kune mutengi-kurutivi kumberi kwekupedzisira pamabhurawuza vachishandisa makuru eJavaScript masisitimu.


DsExcel Java is sophisticated spreadsheet API inoita kuti iwe ugadzire maspredishiti kanenge ipapo. Kana iwe uchitsvaga raibhurari-yakapfuma raibhurari iyo inokushongedzera iwe kuita yakakwirira-nhanho data manipulation uye yepamusoro mishumo chizvarwa, iyi ndiyo Java Excel API raibhurari yekushandisa.


Aspose.Masero eJava


Gadzira, Verenga, uye Shandura XLSX Mafaira

Aspose.Cells yeJava inotsigira XLS, XLSX, XLSM, XLSB, XLTX, XLTM, CSV, SpreadsheetML, uye ODS Excel mafomati.

Yakakwana Excel-Inoenderana Charting

Gadzira uye gadzirisa sarudzo yako yemarudzi akawanda emachati, akadai sepiramidhi uye silinda machati. Iwe unogona zvakare kugadzira uye kugadzirisa machati ane tsika fomati inosanganisa column, column stack, mutsara, uye pie machati. All Aspose.Masero machati anogona kuchinjirwa kune akasiyana mafomati emifananidzo.

Sero uye Range Operations

Iwe unogona kuwana nharembozha uchishandisa zvivakwa uye nzira dzakapihwa neBasa rekushanda kirasi yeAspose.Cells. Iwe unogona kugadzira marenji , kuseta zvimiro uye masitayipi, uye mamwe mashandisirwo kana manipulations uchishandisa "Range" chinhu.

Mashandiro eMapepa ekushanda

Mabasa anosanganisira kuwedzera, kubvisa, kukopa, uye kufambisa mashizha ebasa. Gadzira, shandura, kana bvisa zviratidziro kubva pamapepa ebasa, tarisa mapepa ebasa asina chinhu, uye kopira nekufambisa mapepa ebasa mukati nepakati pemabhuku ebasa.

Shandisa Matemplate eExcel Reporting

Iwe unogona kugadzira yako wega mishumo matemplate. Shandisa template iripo yeExcel kana kugadzira bhuku rekushanda reExcel, riite zvinoenderana nezvaunoda, wobva warichengeta setemplate.

Kusefa uye Conditional Formatting

Aspose.Cells inotsigira zvizere Microsoft Excel's auto filter features, zvichikubatsira kuti unzwisise zviri nani data mune imwe siyana. Iwe unogona zvakare kuisa mafomati ezvimiso nekushandisa dhizaini redhizaini, uchishandisa nzira yekukopa, kana kugadzira mafomati anemamo panguva yekumhanya.

Formulas uye Mabasa

Aspose.Masero anotsigira akawanda eExcel's standard uye akavakirwa-mukati mafomula. Vagadziri vanogona kushandisa iyo formula yekuverenga injini kuverenga zvakare mafomula anounzwa kubva kune vanogadzira matemplate uye kuseta, kuverenga, uye kuverenga mhedzisiro yemafomu anotsigirwa uye mabasa.

Kusunga data uye Kupinza / Kutumira kunze

Zvishandiso zvekutarisira data zvinosanganisira kushandisa Aspose.Cells.GridDesktop kana Aspose.Cells.GridWeb's Worksheets Designer yekubatanidza data. Iyo API zvakare inotsigira kupinza data uye kutumira kunze. Pakupinza data kunze kwenyika, Aspose.Cells inongopinza data rese muExcel faira kana yavhurwa. Iyo zvakare inogamuchira kunze kwenyika kubva kuArray, ArrayList, ResultSet, uye JSON.

Verenga uye Nyora Password-Yakachengetedzwa XLSX uye XLSM Workbooks

Iwe unogona kuvhura iyo password-yakachengetedzwa bhuku rekushanda chimiro cheExcel faira, verenga uye gadzirisa mapepa ebasa, uye wozochengetedza bhuku rebasa nepassword.

Kuita uye Kubudirira

Raibhurari ine sarudzo dzakasiyana dzekuwana kuita kwakanyanya, kunyanya kana uchibata data hombe. Semuyenzaniso, kukurumidza, kushanda nesimba kugadzirisa, unogona kuderedza uye nekugadzirisa ndangariro kushandiswa.

Batanidza neClient-Side Data Viewer

Unogona kubatanidza Aspose.Cells.GridJs muchirongwa chako cheJava kuti uvhure uye ugadzirise maspredishiti eExcel zvakananga mukati mekushandisa kwako. Iyi sarudzo haitenderi kushandiswa kwedata sesefa kana kuronga.


Iyo Aspose.Masero eJava Excel API zvikamu zvine kukurumidza-kumhanya uye scalable. Iwe unogona kugadzira yako wega matemplate matemplate uye woshandisa mafomati epamusoro kune zvikamu zvespredishiti.


Apache POI

Gadzira, Verenga, uye Shandura XLSX Mafaira

Apache POI inopa yakaparadzana Java kuita. HSSF ndiyo POI Project's yakachena Java kuitiswa kweExcel 1997-2007 faira mafomati. Kugadzira, kuverenga, uye kugadzirisa mafaera eXLSX nedzimwe shanduro dzeExcel dzakaburitswa mushure megore ra2007, unofanira kushandisa XSSF. Kune zvakare SXSSF, iyo inofanirwa kushandiswa panzvimbo yeXSSF kana ichigadzira maspredishiti akakura kwazvo.

Yakakwana Excel-Inoenderana Charting

Raibhurari haina kudzika machati ekugona, ichipa rutsigiro rushoma kune mashoma ekutanga machati marudzi. Iyo zvakare kazhinji haigone kugonesa kugadziridzwa kwechati asi inokutendera iwe kuti ugadzire chati muExcel, shandisa HSSF kugadzirisa iyo chati data uye kugadzira nyowani spreadsheet. Iwe haugone kushandura machati. XSSF ine mashoma ekugadzirisa uye inoita kuti iwe uwedzere chete mutsara uye kuparadzira machati.

Sero uye Range Operations

Iwe unogona kuitisa maseru mashandiro, kusanganisira kugadzira, kubatanidza, kubatanidza, ruvara rwemashure, kufambisa mitsara kumusoro kana pasi, uye kushandisa seti imwe chete yemafomati emavara (ruvara, chimiro, font, nezvimwewo) kumaseru. Kuisa sitaira kune renji, iwe unofanirwa kuzviita kune yega yega sero zvakasiyana.

Mashandiro Ekushanda

Humwe hunyanzvi hunosanganisira kuseta nzvimbo yekudhinda, kuwedzera nhamba dzepeji yepasi, kukura kwe zoom, mapanera anoomesa nechando, uye kupatsanura mapaneru.

Shandisa Matemplate eExcel Reporting

Iwe unogona kuverenga nekunyorazve Excel report matemplate.

Kusefa uye Conditional Formatting

Apache POI inopa rutsigiro rwe autofilter mune ese maXLS uye XLSX faira mafomati. Iwe unogona zvakare kusevha mafomati ekusimbisa masero anoenderana nemafomula, maseru kukosha, zvinhu pane rondedzero, nezvimwe.

Formula uye Mabasa

Iwe uchawana tsigiro yemareferensi, maopareta, akavakirwa-mukati mabasa, ekuwedzera-mumabasa, array mafomula, uye dunhu vanoshanda. Raibhurari inocherekedza anopfuura 350 akavakirwa-mukati mabasa uye 280 anoongororwa mabasa. Iyo haigone kuverengera otomatiki, saka unogona kuita kuti Excel iverenge zvakare mafomula paunovhura bhuku rebasa.

Kusunga data uye Kupinza / Kutumira kunze

Apache POI inogona kupinza kubva uye kutumira kune akasiyana data masosi.

Verenga uye Nyora Password-Yakachengetedzwa XLSX uye XLSM Workbooks

Apache POI inotsigira kuburitsa data kubva password-yakachengetedzwa Office mafaera . Iwe unogona kupa password panguva yekuwana faira kuti uverenge zvirimo.

Kuita uye Kubudirira

Nekuda kwekushandiswa kukuru kwendangariro uye kugadzirisa mashandisiro emagetsi, kuita kweAPI kunogona kudzikisira. Apache POI inopa stream-based processing inokodzera mafaera makuru uye inoda kushoma ndangariro.

Batanidza neClient-Side Data Viewer

Raibhurari inopa hapana mutengi-parutivi data anoona.


Kuenzaniswa nemamwe maraibhurari eJava API eExcel, Apache POI inogona kunetsa kushandisa kana kuda kushanda nesimba. Iyo faira kuenderana haina kudzika sevamwe, sezvo ichingotsigira XLS uye XLSX mafomati. POI inowanzo shandisa huwandu hukuru hwendangariro kumashiti makuru. Zvakare, raibhurari ine yakanyanya kushomeka tsigiro yechati uye hapana mutengi-parutivi data anoona.


E-IceBlue (Spire.Xls yeJava)

Gadzira, Verenga, uye Shandura XLSX Mafaira

Raibhurari inopa rutsigiro rwekugadzira, kuverenga, uye kugadzirisa ese mafomati eExcel kuburikidza neExcel 2019 (.XLSX, .XLSB, uye .XLSM) pamwe neOpen Office fomati (.ODS.)

Yakakwana Excel-Inoenderana Charting

Unogona kushandisa machati mumapepa ako ebasa. Spire.XLS inotsigira kugadzira, kugadzirisa, uye kuchengetedza machati akawanda, anosanganisira scatter, pie, donut, line, bar, uye waterfall. Iwe unogona kugadzirisa machati aya nekuwedzera mifananidzo, kuviga gridlines, kuwedzera mavara mabhokisi, nezvimwe.

Sero uye Range Operations

Iwe unogona kunyorera akawanda eakajairwa eExcel mashandiro kumaseru uye mitsara, kusanganisira kuisa, kudzima, kubatanidza, kushandura kureba kwemutsara uye upamhi hwekoramu, kushandisa mafonti, kukopa fomati kubva kune rimwe masero kuenda kune rimwe, uye kuratidza mharadzano yemasero maviri.

Mashandiro eMapepa ekushanda

Iwe unogona kushandisa huwandu hwekushanda kwepepa rebasa kuwedzera kana kubvisa mapepa ebasa, kuwana mazita epepa rebasa, kuomesa mitsara nemakoramu, kuviga kana kuratidza gridlines, kupatsanura mashizha ebasa kuita mafaera, nezvimwe.

Shandisa Matemplate eExcel Reporting

Spire.XLS inokutendera kuti utumire kunze data kune yakakosha Excel template kubva kuComprehensive Workbook Designer kuti uite mishumo.

Kusefa uye Conditional Formatting

Autofilter sarudzo dzinosanganisira kuwedzera kana kubvisa AutoFilter uye kuwedzera data sefa kune yakasarudzwa renji kuti uwane data ine chekuita nemazuva kana nguva. Iwe unogona kugadzira mafirita etsika zvichienderana nemamwe maitiro, senge mavara chaiwo kana manhamba. Iyo API zvakare inotsigira mamiriro ekugadzirisa.

Formula uye Mabasa

Formula nerutsigiro rwebasa rinokutendera kuti uise kana kuverenga mafomula nemabasa, bvisa mafomula uchichengeta hunhu papepa rebasa, nezvimwe.

Kusunga data uye Kupinza / Export

Spire.XLS inopa rutsigiro rwekusunga data. Iyo zvakare inobvumidza iwe kupinza data kubva uye kutumira kunze data kune akawanda masosi, kusanganisira Database, Datatable, Dataset, uye Datagridview. Iwe unogona kutumira data kune mapepa ekushanda uye kupinza uye kutumira kunze sarudza mitsara kana makoramu.

Verenga uye Nyora Password-Yakachengetedzwa XLSX uye XLSM Workbooks

Unogona kubvisa password yekudzivirira yeXLSX neXLSM mabhuku ebasa kuti ugadzirise uye wozochengeta faira nepassword yakadzokororwa.

Kuita uye Kubudirira

ClosedXML inokodzera zvikumbiro zvinoda chiyero pakati pekureruka kwekushandisa uye kuita kweExcel mashandiro.

Batanidza neClient-Side Data Viewer

Spire.XLS inopa hapana mutengi-divi rekuona data.


Spire.XLS yeJava inyanzvi yeJava Excel API inopa mabasa ekutanga. Unogona kugadzira, kubata, uye kugadzirisa Excel spreadsheets pasina kurodha Microsoft Excel. Raibhurari ndiyo inonyanya kufanira maapplication anoda zvakafanana mashandiro uye usability level asi isina mukana kune mutengi-parutivi data anoona.


EasyXLS Java

EasyXLS iJava Excel raibhurari yakagadzirirwa kufambisa kusikwa, kunyengera, uye kugadzirisa mafaera eExcel muJava application. Inopa vanogadzira iyo iri nyore kushandisa API yekuverenga, kunyora, uye fomati Excel mafaera pasina kuda Microsoft Excel kana mamwe echitatu-bato Excel maraibhurari.

Gadzira, Verenga, uye Shandura XLSX Mafaira

EasyXLS inotsigira akasiyana mafomati eExcel akadai seXLSX, XLSB, XLSM, XLS, CSV, uye nezvimwe kubva kuMS Excel 97 - 2024 uye Hofisi 365.

Yakakwana Excel-Inoenderana Charting

EasyXLS inotsigira gumi nerimwe marudzi emachati, anosanganisira scatter, mutsara, uye donut machati, ane akawanda ekugadzirisa sarudzo. Kune zvakare rutsigiro rwekuverenga mafaera eExcel ane machati uye kutora ruzivo rwechati.

Sero uye Range Operations

Raibhurari inopa ese akajairwa mafomati ekugonesa, achikubvumidza iwe kuti ugadzirise kurongeka, muganho chimiro uye ruvara, kuzadza marongero, nezvimwe. Cell comments inogona kushandiswa uye kunyorwa. Iwe unogona zvakare kutsanangura mazita ane mazita uye woashandisa mumafomula.

Mashandiro Ekushanda

Iwe unogona kubata mapepa ekushanda zviri nyore nekugona kugadzira nekuabvisa. Iwe unogona kugadzirisa mashizha ebasa, kuomesa uye kupatsanura mapaneru, sarudza tebhu ruvara, nezvimwe.

Shandisa Matemplate eExcel Reporting

Easy XLS haitsigire matemplate.

Kusefa uye Conditional Formatting

Iwe unogona kuwedzera autofilter kune akasiyana maseru kana kushandisa yako wega sefa. Iwe unogona zvakare kunyorera mafomati ezvimisikidzo kumarenji uye kutsanangura font uye muganho masitaera, kumashure uye epamberi sarudzo, uye misoro.

Formulas uye Mabasa

Sarudzo dzekuverenga dzeFormula dzinosanganisira kushandisa mabasa kutsanangura mafomula uye kurodha Excel matemplate ane akafanotsanangurwa mafomula. Iyo injini yekuverenga inotsigira ese Excel-anotsigirwa mabasa.

Kusunga data uye Kupinza / Kutumira kunze

Iko kune rutsigiro rwekupinza / kutumira kunze dhatabhesi tafura data kuenda kana kubva kuExcel mafaera. Iwe unogona kuunza data kubva kune inotsigirwa Excel uye mameseji mafaera pamwe neakananga data zvimiro, kusanganisira Rondedzero, DataSet, uye ResultSet. EasyXLS haitsigire data kusunga.

Verenga uye Nyora Password-Yakachengetedzwa XLSX uye XLSM Workbooks

EasyXLS inokutendera iwe kuti ugadzire, uverenge, uye unyore password-yakachengetedzwa XLSX uye XLSM mafaera, pamwe nekuverenga password-yakachengetedzwa Excel mafaera.

Kuita uye Kubudirira

EasyXLS kazhinji inokurumidza uye inoshanda; zvisinei, kuita mabasa pamaspredishiti makuru kunogona kukanganisa kushanda kweraibhurari, kunyanya kana yakaoma. Iwe unofanirwa kutora matanho ekuwedzera kudzivirira kurodha faira rese reExcel. Pane kudaro, verenga chete data inodiwa, kana zvichibvira.

Batanidza neClient-Side Data Viewer

EasyXLS haina mutengi-divi rekuona data.


Zvinoenderana nepepa rayo rekutsanangura , nepo EASYXLS iri raibhurari yeAPI yekugadzira columnar kana machati mishumo, inogona zvakare kushandiswa kugadzira akapusa eExcel maspredishiti. Iraibhurari inokurumidza, iri nyore kushandisa asi inogona kunge isina kunyatsokodzera kubata mahombe eExcel mafaera pasina kusvibisa kuita uye kugona. Zvakadaro, kugona kwayo kwechati kunovimbisa kuti iwe unogona kugadzira yakanyanya kutsanangurwa machati. Unewo maoperation ese aunoda kuti utarise zvakanaka nekugadzirisa maseru, mapepa ebasa, uye mabhuku ebasa kunenge yega yega mafomati eExcel akaburitswa kubva 1997 kusvika 2024. Zvakadaro, hapana mutengi-divi rekuona data rinosanganisirwa.


Mhedziso

Ese maraibhurari eJava-based Excel API ataurwa pamusoro ane maficha akafanana, asi mamwe anoita zvirinani pane mamwe. Pamusoro pezvo, akawanda emaraibhurari haasanganisi akajairwa kumberi-kumagumo, mutengi-parutivi data rekuona kuratidza iyo data. Kana iwe uchitsvaga raibhurari ine akanakisa epasirese (inokurumidza, yakazara-inoratidzwa gwaro API backend ine nyanzvi yekuona data kumberi-kumagumo), saka sarudzo inonyanya kunzwisisika ndeye Document Solutions yeExcel, Java. Edition.