Ephezulu C# .NET Excel API amathala eencwadi

AC# .NET ilayibrari ye-Excel ye-API sisixhobo esinokuzimela, sikubonelela ngezakhono ze-Excel kwizicelo ze-C# ngaphandle kokuxhomekeka ekufakeni amacandelo e-Microsoft kwiseva yakho. Unokwenza ngokwenkqubo yonke imisebenzi ebalulekileyo ye-Excel ekuvumela ukuba uvelise i-spreadsheets ozifunayo.

Maninzi amathala eencwadi e-API akhoyo, kodwa ngaba uyazi ukuba yeyiphi omele ukhethe?

Kule post, siza kuvavanya iC# .NET Excel API iilayibrari ezisekelwe kwezi mpawu zilandelayo:

• Yenza, funda, kwaye ulungise iifayile ze-XLSX
• Comprehensive Excel-ehambelanayo charting
• Iiseli kunye nemisebenzi yoluhlu
• Ulawulo lwamaphepha okusebenzela
• Sebenzisa iitemplates zengxelo ye-Excel
• Ukuhluza kunye nokufomatha okunemiqathango
• Iifomula kunye nemisebenzi
• Ukubophelela kwedatha kunye nokungenisa / ukuthumela ngaphandle
• Funda kwaye ubhale ii-password ezikhuselweyo ze-XLSX kunye ne-XLSM workbooks
• Ukusebenza kunye nokusebenza kakuhle
• Ukudityaniswa nomxhasi-kwicala lokujonga idatha

Izisombululo zoXwebhu ze-Excel, uHlelo lwe-NET

Yenza, Funda, Lungisa, kwaye Guqula iifayile zeXLSX

Izisombululo zeDocument for Excel, .NET Edition (DsExcel) yi-MESCIUS isekela yonke imisebenzi yolawulo lwefayile oyifunayo kwiifayile ze-XLSX, kuquka ukudala, ukufunda, ukuguqula nokuguqula.

Comprehensive Excel-Compatible Charting

I-DsExcel ixhasa ukudibanisa iindidi ezininzi zeetshathi kumaphepha okusebenzela kwaye ibonelela ngeempawu zokwenza ngokwezifiso izihloko zetshathi, iintsomi, uthotho lwedatha, kunye nokunye. Unako kwakhona ukongeza iitshathi kuyilo lwetemplate.

Imisebenzi yeeSeli kunye neeRange

Unokwenza imisebenzi eyahlukeneyo kwiiseli, iikholamu, kunye nemigca, kuquka ukufikelela, ukusika, ukukopa, ukufihla, ukufaka, ukucima, ukudibanisa, kunye nokunye.

Ulawulo lwePhepha lokusebenzela

Imisebenzi yencwadi yomsebenzi ibandakanya ukudala, ukuvula, ukugcina, ukukhusela, ukusika, ukukopa, ukutshintsha iimbono, kunye nokwenza okanye ukuvala injini yokubala.

Zizenzele iiNgxelo ze-Excel usebenzisa iSakhelo seXLSX

I-DsExcel ivumela abasebenzisi ukuba bachaze itemplates ze-Excel zesiko kwi-.NET usebenzisa i-syntax yolwimi olulula, ukuveliswa kweengxelo ze-.xlsx ngeetshathi, i-sparklines, kunye neetafile. Ngokubophelela idatha ngokuthe ngqo kwii-templates ze-XLSX, ilungelelanisa ukudalwa kweengxelo, njengama-invoyisi kunye neengxelo zokuthengisa, kunye nenkxaso ye-Windows, i-Linux, kunye ne-macOS, iqinisekisa ukusebenza okuphezulu kunye nokuzinza.

Uhluzo kunye nokuFomatha okuneMiqathango

Hlunga iiseli usebenzisa iindlela ezifana nedatha, umbhalo, inombolo, umbala, kunye ne-ayikhoni. Unokugqamisa amaxabiso athile edatha usebenzisa imithetho yokufomatha ngokwemiqathango esekelwe kwixabiso leseli, i-icon, ibha yedatha, kunye nomgaqo wemibala emithathu.

Iifomula kunye neMisebenzi

Unokwenza kwaye usebenzise iifomyula ukubala izibalo ezinzima ukuvelisa amaxabiso eseli. I-DsExcel ikwaxhasa ngaphezu kwe-450 Excel imisebenzi. Ungasebenzisa imisebenzi eyakhelwe-ngaphakathi okanye udale imisebenzi elungiselelwe ukwenza iifomula.

Ukubophelela kwedatha kunye nokuNgenisa ngaphandle / ukuthumela ngaphandle

I-DsExcel ixhasa indlela enye yokudibanisa idatha kunye neeseli, ii-worksheets, okanye iikholamu zetafile kunye nokusebenzisa imithombo emininzi ukuqokelela idatha. Urhweba ngaphandle olukhawulezayo nolusebenzayo, ungasebenzisa i-ImportData () umsebenzi ukufumana kuphela idata kwiifayile ze-Excel endaweni yomfuziselo wento yonke. Ungakwazi nokuthumela ngaphandle iphepha lakho le-Excel ngokucwangcisiweyo kwezinye iifomati ezahlukeneyo, ezifana ne-.xlsx, .csv, PDF, HTML, JSON, kunye nokunye.

Funda kwaye ubhale i-Password-eKhuselweyo i-XLSX kunye ne-XLSM Workbooks

Ungalungisa ukhuseleko lweencwadi zakho zokusebenza ngokusebenzisa amagama ayimfihlo athintela ukuhlelwa kwedatha okanye ukutshintsha ulwakhiwo lwencwadi yomsebenzi kunye neefestile. Ungakwazi nokulususa ngokupheleleyo ukhuseleko lwegama lokugqitha lencwadi yomsebenzi ukulungiselela ukuhlela okungasikelwanga mda.

Ukusebenza kunye noKucikoza

I-DsExcel yilayibrari ye-API ene-memory footprint encinci kunye ne-high-performance factor. Inoyilo olukhaphukhaphu oluphucula ukusebenza kakuhle kwethala leencwadi. Unokusebenza kakuhle nge-Excel, ukunciphisa umgudu, ukusetyenziswa kwememori, kunye nexesha elithathayo ukuvelisa nokulawula i-spreadsheets.

Dibanisa kunye neClient-Side Data Viewer

I-DsExcel inikezela nge-cross-platform ye-JavaScript data viewer , i-Document Solutions Data Viewer, enokuhlanganiswa ngokulula kunye ne-DsExcel. Ivumela abasebenzisi bakho ukuba bavule kwaye bajonge i-XLSX, SJS, SSJSON, kunye namaxwebhu e-CSV ekupheleni kwawo kwizicelo zewebhu.

I-DsExcel yi-API esebenzayo kunye ne-user-friendly kuzo zonke iiprojekthi zakho ze-spreadsheet kwi-.NET. Inazo zonke iimpawu ozidingayo ukuze wenze ngokwenkqubo kwaye usebenzise amaxwebhu e-Excel ngokusebenza okuphezulu, nakwizinga. Unokusebenzisa iitemplates ukuququzelela ukuveliswa kwengxelo ye-Excel. I-DsExcel ikuvumela ukuba udibanise ngokulula kufuneka ube namandla, kubandakanywa ukubophelela kwedatha, iitshathi, ukufomatha okunemiqathango, iifomyula, kunye nemisebenzi, kumaxwebhu akho e-Excel.

Aspose.Cells for .NET Excel

Yenza, Funda, kwaye uguqule iiFayile zeXLSX

I-Aspose.Cells ixhasa ukusebenza kweefayile kwiifomathi ze-XLSX kunye ne-XLS, i-XLSB, i-XLT, i-XLTX, i-XLTM, i-XLSM, i-XML, kunye ne-OTS.

Comprehensive Excel-Compatible Charting

Kukho inkxaso epheleleyo yokudala kunye nokukhohlisa iintlobo ezininzi zeetshathi ngogxininiso olukhulu ekwenzeni ngokwezifiso kunye nesimbo. Unako kwakhona ukunika iitshathi njengemifanekiso kwaye usebenzise idatha yokuseta ngokuguqukayo ukuzihlaziya ngokuzenzekelayo.

Imisebenzi yeeSeli kunye neeRange

I-API ixhasa yonke imisebenzi ye-Excel eqhelekileyo oyifunayo ukuyidala, ukulawula, kunye nokufomatha iiseli kunye noluhlu.

Ulawulo lwePhepha lokusebenzela

Unokwenza, ukope, kwaye uhambise amaphepha okusebenzela. Izakhono ezongezelelweyo ziquka ukukhangela amaphepha okusebenzela angenanto, ukulawula iikhefu zephepha, kunye neepaneli zokukhenkcela.

Sebenzisa iisakhelo sengxelo yeExcel

Unokwenza itemplates zakho ngokuvula itemplate ekhoyo ye-Excel okanye udale incwadi yokusebenza entsha ye-Excel, uyilungise ngokweemfuno zakho, uze uyigcine ngolwandiso lwe-.XLTX. Unokwenza kwakhona i-spreadsheet yakho yomyili-ifayile enofomatho olufakwe ngaphambili, olufana nethemplate-ukwenza iingxelo.

Uhluzo kunye nokuFomatha okuneMiqathango

Sebenzisa izihluzi ezizenzekelayo ukunceda ukwenza amaxwebhu okusebenzela atyebileyo e-Excel akunika ukuqonda okungcono kwedatha. Usenokufaka ufomato olunemiqathango ngokudala ukufomatha okunemiqathango ngexesha lokusebenza okanye usebenzisa i-spreadsheet yomyili.

Iifomula kunye neMisebenzi

I-Aspose.Iiseli zixhasa iifomyula zoluhlu kunye nemisebenzi eyakhelweyo kunye neyongezelelweyo. Ungasebenzisa phantse zonke iifomyula zeMicrosoft Excel ezisemgangathweni kunye nemisebenzi.

Ukubophelela kwedatha kunye nokuNgenisa ngaphandle / ukuthumela ngaphandle

Kufuneka usebenzise i-Aspose.Cells.GridDesktop okanye i-Aspose.Cells.GridWeb's Worksheets Designer kwimisebenzi yokubopha idatha. I-Aspose.Cells ikwaxhasa ukungenisa idatha kunye nokuthumela ngaphandle idatha kwiiseli. Unokungenisa kunye nokuthumela ngaphandle idatha phakathi kweencwadi zokusebenza ze-Excel kunye neeSeti zeDatha, iiTayibhile zeDatha, kunye neDathaGrids.

Funda kwaye ubhale i-Password-ekhuselweyo i-XLSX kunye ne-XLSM Workbooks

Ungavula i-password-ekhuselweyo yesakhiwo sencwadi yokusebenza yefayile ye-Excel, ufunde kwaye uhlele amaphepha okusebenzela, kwaye emva koko ugcine incwadi yomsebenzi kunye negama lokugqitha. Kukwakho igama lokugqitha lokuguqula ukhetho.

Ukusebenza kunye noKucikoza

Iiseli ze-Aspose zisebenza kakhulu kwaye zisebenza ngokukhawuleza. Nangona kunjalo, unokuhlangabezana nemiba yokusebenza xa ufunda okanye ubhala iincwadi zokusebenza ezineesethi ezinkulu zedatha okanye nawuphi na umsebenzi othatha isixa esikhulu se-RAM.

Dibanisa neClient-Side Data Viewer

I-Aspose.Cells ikuvumela ukuba uvelise ifayile ye-Excel okanye ingxelo kwaye uyithumele kwisikhangeli somthengi ngokugcina ifayile kwi-Response Object. Ungakwazi nokudibanisa i-Aspose.Cells.GridJs kwiprojekthi yakho ye-NET ukuvula nokuhlela i-Excel spreadsheets ngqo kwisicelo sakho.

I-Aspose.Cells yilayibrari eshinyeneyo kakhulu, ephezulu ye-Excel API C# ye-.NET ekuvumela ukuba ulandelele ngokukhawuleza imisebenzi ye-spreadsheet phantse kuyo yonke ifomati ye-MS Excel, kuquka iifayile ze-XLSX. Ngelixa kukho amathala eencwadi ahambele phambili kakhulu, i-Aspose.Cells iqinisekisa ukuba unokwenza uluhlu olubanzi lwemisebenzi ye-Excel esemgangathweni kunye nephezulu ngokwenkqubo phantse yonke imiba yokudala, ukuhlela, nokulawula i-spreadsheets.

Lilonke, ilayibrari ye-Aspose.Cells C# lukhetho oluluqilima lwendlela ye-Excel. Nangona kunjalo, khumbula ukuba ngelixa unokusebenzisa ithala leencwadi ukucubungula iiseti ezinkulu zedatha, ukufumana ukusebenza okuphezulu okulindeleyo kunokufuna ukulungiswa kakuhle kwicala lakho ukunciphisa ukusetyenziswa kwememori.

Injini ye-SpreadsheetGear ye.NET

Yenza, Funda, kwaye uguqule iiFayile zeXLSX

Olona hlaziyo lwamva nje, i-SpreadsheetGear 2023, lwandise ukuhambelana kwefomathi yethala leencwadi ukuquka i-XLSX, i-XLSM, i-XLS, i-CSV, kunye neefayile ze-TXT ze-Excel 2021 kunye neenguqulelo zamva nje ze-Excel ye-Microsoft 365.

Comprehensive Excel-Compatible Charting

Inkxaso yetshathi ibandakanya uluhlu olubanzi lweentlobo zeetshathi, ukunikezelwa kwetshathi, kunye nokukwazi ukwenza iitshathi zeetshathi kunye neetshathi ezinemifanekiso edibeneyo.

Imisebenzi yeeSeli kunye neeRange

Ungafikelela kwaye ulungise iiseli zephepha lomsebenzi ezinamaxabiso, iifomyula, iifomati zamanani, iifonti, imida, imibala yangasemva, iikhomenti zeeseli, iihyperlink, nokunye. Uluhlu lwemisebenzi lubandakanya ukukopa, ukuhlela, izihluzi ezizenzekelayo, ukhuseleko lweeseli, kunye neqela kunye nolwandlalo. Kukwakho nokudityaniswa okuphuculweyo kweeseli zoluhlu olude.

Ulawulo lwePhepha lokusebenzela

I-SpreadsheetGear ikuvumela ukuba wenze, uhambise, kwaye ukope amaphepha okusebenzela. Unokufumana iinketho ezahlukeneyo zokubonisa, uvavanye amaxabiso kwiifomyula, utshintshe umbala wephepha, kwaye usebenzise ukhuselo olwahlukileyo lwamaphepha okusebenzela.

Sebenzisa iisakhelo sengxelo yeExcel

Unokwenza iitemplates zengxelo ngokulawula ngokupheleleyo kwiimpawu zazo ukuvelisa naluphi na uhlobo lwengxelo ye-Excel oyifunayo.

Uhluzo kunye nokuFomatha okuneMiqathango

Iikhrayitheriya zokucoca ngokuzenzekelayo zingabandakanya imigaqo yesiko kwaye inokusetyenziswa kwimiyalelo emininzi, njengokufomatha iiseli, ukucima, kunye nokuzalisa. Isimbo sefomathi esinemiqathango sisekwe kwiifomyula eziqhelekileyo, abaqhubi abathelekisekayo abalula, kunye nemithetho ephambili.

Iifomula kunye neMisebenzi

I-SpreadsheetGear ijonge ukuba neyona njini ikhawulezayo yokubala i-Excel-ehambelanayo ekhoyo (ekuthiwa ikhawuleza kakhulu kune-Excel kwiimeko ezininzi). Inemisebenzi ehambelana ne-449 Excel, ukubala kwakhona ngemisonto emininzi, inkxaso yefomula yoluhlu, kunye nokunye.

Ukubophelela kwedatha kunye nokuNgenisa ngaphandle / ukuthumela ngaphandle

Ungahambisa idatha phakathi kweencwadi zokusebenza ze-Excel kunye neeSeti zeDatha, iiTayibhile zeDatha, kunye neeGridi zeDatha. I-SpreadsheetGear ayixhasi ukubophelela kwedatha.

Funda kwaye ubhale i-Password-eKhuselweyo i-XLSX kunye ne-XLSM Workbooks

I-SpreadsheetGear ixhasa ukufunda nokubhala ii-password ezikhuselweyo ze-XLS, XLSX, kunye ne-XLSM workbooks. Imiba ethile yephepha lokusebenzela isenokuvulwa xa ukhuseleko lwephasiwedi luvuliwe.

Unokwenza utshintsho lwenkqubo kwiphepha lomsebenzi xa likhuselwe, nangona ukhuseleko lwe-UI lusanyanzeliswa.

Ukusebenza kunye noKucikoza

I-SpreadsheetGear yi-API enesantya esiphezulu esinokunciphisa ixesha lokucubungula kwaye inike uphuhliso lwesicelo esiphezulu. Yenza ukusetyenziswa ngokufanelekileyo kwezixhobo zakho kwaye inokuphucula ukusebenza kwemveliso yespreadsheet.

Dibanisa neClient-Side Data Viewer

Ayiboneleli ngecala lomxhasi API onokuthi uyilungise. Nangona kunjalo, unokubonisa iifayile ze-Excel kwisiphequluli usebenzisa i-ASP.NET.

I-SpreadsheetGear ixhasa imisebenzi emininzi yeenguqulelo ze-Excel nge-Excel 2021, kunye neenguqulelo zamva nje ze-Excel ye-Microsoft 365. Ine-interface ecocekileyo yomsebenzisi onokuyihamba ngokulula kunye nethala leencwadi le-API elikuvumela ukuba ulandele imisebenzi ye-Excel, ikunika ulawulo olupheleleyo kwi-Excel. inkqubo yokuvelisa ispredishithi.

Ezona nkcukacha ziqaphelekayo malunga ne-SpreadsheetGear isenokungabi ziimpawu ezinikelayo kodwa iimpawu engazinikiyo. Umzekelo, i-SpreadsheetGear ayizixhasi ii-arrays eziguqukayo, iitafile ze-Excel, okanye umsebenzi we-LAMBDA. Oku kunokuba yingxaki kuwe ukuba ufuna ukhetho olongezelelweyo lokuphatha iiseti zedatha ezinkulu kakhulu kunye nokwenza izibalo ezinzima.

Ithala leencwadi le-Syncfusion Excel (XlsIO).

Yenza, Funda, kwaye uguqule iifayile ze-XLSX

Iinguqulelo ze-Microsoft Excel ezihambelanayo ziquka iifayile ze-XLSX kunye nezinye nge-Excel 2019 kunye neefomathi ze-intanethi ze-Microsoft 365.

Comprehensive Excel-Compatible Charting

Kukho ngaphezu kwe-80 iintlobo zeetshathi ze-Excel ezixhaswa yi-XisIO. Iitshathi zinokuzinziswa ngaphakathi kwincwadi yomsebenzi okanye zenziwe njengephepha lomsebenzi letshathi. Iinketho zokwenza ngokwezifiso ziquka indawo yesakhiwo, intsomi, i-axis, kunye nokunye.

Imisebenzi yeeSeli kunye neeRange

Imisebenzi yeseli ibandakanya ukufumana kunye nokubuyisela, ukuhlela, ukuhluza, kunye namakhonkco. Unokwenza ngokuzenzekelayo imigca kunye neekholamu kwaye usebenzise umbala weseli, izitayile zefonti, useto lwemida, kunye nokunye.

Ulawulo lwePhepha lokusebenzela

Imisebenzi yephepha lokusebenzela ibandakanya ukushukuma, ukukopisha, ukufriza iipaneli, umboniso okanye ukufihla iikholamu, kunye nokuchaza iinketho zokuseta iphepha, njengokufaka yonke imiqolo kwiphepha elinye elishicilelweyo okanye ukufaka iphepha ngaphambi kokushicilela.

Sebenzisa iisakhelo sengxelo yeExcel

Essential XlsIO ikuvumela ukuba uthumele idatha kwitemplate ye-Excel usebenzisa iziphawuli zetemplate.

Uhluzo kunye nokuFomatha okuneMiqathango

Iimpawu zolawulo lwedatha zibandakanya ukuhluza ngokuzenzekelayo usebenzisa iintlobo zokucoca ngokuzenzekelayo, ezifana nesiko, phambili, i-icon, umbala, i-dynamic, indibaniselwano, kunye nezihluzo zesiko. I-XlsIO ikwaxhasa ukufomatha okunemiqathango yokufomatha ngokutshintshatshintshayo imixholo yeeseli ukuguqula inkangeleko yedatha.

Iifomula kunye neMisebenzi

I-XlsIO ixhasa zonke iifomyula ezixhaswa yi-Excel kunye nemisebenzi engaphezu kwama-400 e-Excel. Ungasebenzisa kwakhona imisebenzi yokongeza, iifomyula zangaphandle, kunye noluhlu lwefomula.

Ukubophelela kwedatha kunye nokuNgenisa ngaphandle / ukuthumela ngaphandle

Essential XlsIO ikuvumela ukuba ubophe izimakishi zetemplate kwidatha evela kwimithombo eyahlukeneyo, njengeDatha yedatha, izinto zoQokelelo, izinto eziqokelelweyo ezibekwe kwindlwane, kunye noluhlu. Ukungeniswa kwedatha eyenziwe ngokwezifiso kuyaxhaswa, kwaye ungathumela ngaphandle kwiiTayibhile zeDatha, izinto zokuQokelelwa, kunye neeklasi ezifakwe kwindlwane.

Funda kwaye ubhale i-Password-eKhuselweyo i-XLSX kunye ne-XLSM Workbooks

Kukho amagama ayimfihlo amabini ahlukeneyo onokuwasebenzisa ukuguqulela ngokuntsonkothileyo iincwadi zakho zokusebenza. I-password yofikelelo ikhusela ekujongweni okungagunyaziswanga, ngelixa igama lokugqitha libonelela abasebenzisi abathile ngogunyaziso lokuhlela kunye nokugcina idatha yencwadi yomsebenzi.

Ukusebenza kunye noKucikoza

I-Syncfusion inokusebenza ngokukhawuleza nokuba usebenza ngeefayile ezinkulu kwaye kufuneka iqhube inkqubo eninzi kwiifayile ngelixa usenza.

Dibanisa neClient-Side Data Viewer

Unokubonisa iifayile ze-Excel kwisikhangeli usebenzisa i-ASP.NET.

I-Syncfusion XlsIO licandelo elingeyo-UI ekulula kakhulu ukulisebenzisa. Inazo zonke iimpawu ozidingayo ukuze wenze kwaye ulawule iingxelo ezityebileyo ze-Excel. Ii-API ezibalulekileyo zeetshathi, iifomula, imisebenzi, kunye nokufomatha kukuvumela ukuba wenze wonke umsebenzi we-Excel owufunayo ngaphandle kokukhuphela i-Excel ngokwayo. I-Syncfusion inokusingatha iiseti zedatha enkulu kakuhle kwaye ibonelela ngeendlela zokuphucula ukusebenza, ukuba ziyimfuneko, njengokusebenzisa ujongano olunye phezu kolunye ukuphucula ukusebenza ngokwandisa imemori.

DevExpress Spreadsheet

Yenza, Funda, kwaye uguqule iifayile ze-XLSX

Ibonelela ngenkxaso yokuyila, ukufunda, kunye nokuguqula phantse zonke iifomathi zamaxwebhu e-Microsoft Excel, kuquka i-XLS, i-XLSB, i-XLSX, kunye ne-XLSM.

Comprehensive Excel-Compatible Charting

I-DevExpress Spreadsheet ibonelela ngolawulo lwetshathi kwiitshathi ezininzi ze-2D kunye ne-3D. Unokwenza, ufikelele, uguqule, okanye ususe iihistograms, iingxangxasi, iitshathi zefanitshala, kunye nokunye.

Imisebenzi yeeSeli kunye neeRange

Amaxabiso onokuwabela iiseli aquka iifomula, okubhaliweyo, amanani, amaxabiso engqiqo, kunye nemihla. Imixholo yoxwebhu, ebandakanya imibala, iifonti, kunye neziphumo zegraphic, zinxulunyaniswa nencwadi nganye yomsebenzi. Ungaphinda uhlele imibala yomxholo ochazwe kwangaphambili okanye wenze umxholo oqhelekileyo.

Ulawulo lwePhepha lokusebenzela

Unokwenza, ufikelele, uguqule, okanye ususe iincwadi zokusebenza, ii-worksheets, kunye namaphepha etshathi. Unako kwakhona ukufaka, ukukopa, ukufihla, umkhenkce, ulinganise, okanye ususe imiqolo kunye neentsika.

Sebenzisa iisakhelo sengxelo yeExcel

Sebenzisa iitemplates ukuvelisa i-spreadsheets ngeDevExpress Report Designer.

Uhluzo kunye nokuFomatha okuneMiqathango

Umsebenzi wokucoca okuzenzekelayo ikuvumela ukuba ucoce ngenani, ixabiso, okubhaliweyo, kunye nomhla. Umsebenzi wokufomatha okunemiqathango uya kuqaqambisa amaxabiso eseli okanye inqaku lentsingiselo ngaphakathi kweeseli usebenzisa iibar zedatha, ii-icon, kunye nemibala echazwe kwangaphambili.

Iifomula kunye neMisebenzi

I-API ine-injini ekhawulezayo, eyakhelwe-ngaphakathi yokubala ifomula enemisebenzi engaphezu kwama-400 e-Excel. Unokwenza iifomula zakho kunye nemisebenzi.

Ukubophelela kwedatha kunye nokuNgenisa ngaphandle / ukuthumela ngaphandle

Ukubophelela kwedatha kuyindlela-mbini ngokuzenzekelayo. Ungabophelela uluhlu lweeseli okanye itafile kwiphepha lomsebenzi kumthombo wedatha okanye usebenzise uluhlu lweeseli njengomthombo wedatha. Kukho inkxaso yokurhweba ngaphandle kwedatha kwiiseli zamaphepha okusebenzela ukusuka kuluhlu, uluhlu, kunye neeseti zedatha. I-API ikwanayo nelayibrari yokuThumela ngaphandle kwe-Excel, eyenzelwe ngokukodwa ukuphatha ukuthunyelwa ngaphandle kwaye ilungele ukunciphisa ukusetyenziswa kwememori xa ivelisa ubuninzi bamaxwebhu kwicala lomncedisi.

Funda kwaye ubhale i-Password-eKhuselweyo i-XLSX kunye ne-XLSM Workbooks

I-API ikuvumela ukuba ukhusele i-password-ukukhusela amaphepha okusebenzela kunye neencwadi zokusebenza ukukhusela ukufikelela okungagunyaziswanga kunye nokuguqulwa.

Ukusebenza kunye noKucikoza

Ngokutsho kwewebhusayithi yayo, ithala leencwadi laphuhliswa ukusika ukusetyenziswa kwememori kunye nokuphucula kakhulu ukusebenza ngelixa livelisa i-spreadsheets.

Dibanisa neClient-Side Data Viewer

I-Document Viewer licandelo elibonisa kuphela iiNgxelo ze-DevExpress kwi-.NET izikhokelo zophuhliso, njenge-ASP.NET Core kunye ne-Blazor platforms. Umsebenzisi unokujonga, aprinte, kwaye athumele ngaphandle uxwebhu lwe-Excel. Zonke izenzo eziyimfuneko zenziwa kwicala lomncedisi.

I-DevExpress inegama lokuba sisisombululo esinamandla se-Excel esineempawu eziphambili. I-APIs yayo ingasetyenziselwa ukuphuhlisa izicelo eziphezulu zokusebenza. Inika ukhetho olwaneleyo lokwenza iitshathi kunye nokufomatha iiseli kunye namaphepha okusebenzela ukuqinisekisa ukuba ungabonisa idatha ngendlela ofuna ngayo. Kananjalo inamandla okubophelela idatha, okwenza ukuvelisa iingxelo ze-Excel zibe lula ngeetemplates zoMyili weNgxelo. Ukuthatha ithuba lezi mpawu kunokufuna inzame eyongezelelekileyo kunamanye amathala eencwadi, njengoko iDevExpress inomjikelo wokufunda.

IronSoftware IronXL

Yenza, Funda, kwaye uguqule iifayile ze-XLSX

I-IronXL iyahambelana neefomathi ze-XLS, XLSX, XLST, XLSM, CSV, kunye ne-TSV Excel. Ungasebenzisa ilula kakhulu kwaye kulula ukuyikhumbula imisebenzi ukwenza, ukufunda, kunye nokuhlela amaxwebhu.

Comprehensive Excel-Compatible Charting

I-IronXL ixhasa ikholamu, ukusasaza, umgca, ipayi, ibha, kunye neetshathi zendawo. Nangona kunjalo, ukwenza ngokwezifiso kulinganiselwe xa kuthelekiswa namanye amathala eencwadi, njengoko unokuhlela kuphela isihloko setshathi kunye nendawo yentsomi.

Imisebenzi yeeSeli kunye neeRange

Uyakwazi ukwenza isimbo iiseli ngokukhankanya ifonti, ubungakanani, umda, ulungelelwaniso, ipateni yangasemva, kunye nofomato olunemiqathango. Kukwakho imisebenzi emininzi yokulawula uluhlu lweeseli, kubandakanywa ukuhlela, ukunquma, ukucacisa, ukukopisha, ukufumana kunye nokubuyisela, i-hyperlink, kunye nokudibanisa kunye nokungadibanisi iiseli.

Ulawulo lwePhepha lokusebenzela

I-IronXL ikuvumela ukuba wenze, uhlele, kwaye ugcine amaphepha okusebenzela. Ungaphinda ulungelelanise inani lemiqolo kunye neekholamu kunye nobukhulu bazo. Izenzo ezongezelelweyo ziquka ukongeza imifanekiso kunye nokuphindaphinda, ukudibanisa, kunye nokwahlula amaqela okusebenzela.

Sebenzisa iisakhelo sengxelo yeExcel

Unokulayisha iitemplates zeengxelo ze-Excel okanye uzenzele eyakho kwaye uyigcine njengefayile ye-XLTX.

Uhluzo kunye nokufomatha okuneMiqathango

I-IronXL ixhasa ukongeza, ukukhupha, kunye nokususa ukufomatha okunemiqathango. I-IronXL ayikuxhasi ukuhluzwa kweeseli.

Iifomula kunye neMisebenzi

Nge-IronXL, unokuvula i-Excel, uhlele iifomyula ezikhoyo, kwaye ufumane isiphumo kwifomula. Nanini na xa naliphi na iphepha lokusebenzela lihlelwa, iifomula zibalwe ngokutsha ngokuzenzekelayo ukuqinisekisa iziphumo ezichanekileyo. Ukwafumana inkxaso kwimisebenzi ye-Excel engaphezu kwe-165.

Ukubophelela kwedatha kunye nokuNgenisa ngaphandle / ukuthumela ngaphandle

Ungathumela idatha ye-Excel kwiifomathi ezahlukeneyo, ezifana ne-JSON okanye i-HTML, kwaye ukhuphe idatha kwiifayile ze-Excel. I-IronXL ayikuxhasi ukubophelela kwedatha.

Funda kwaye ubhale i-Password-eKhuselweyo i-XLSX kunye ne-XLSM Workbooks

I-API ixhasa ukuhlela nokugcina iincwadi zokusebenza ezikhuselwe ngegama eliyimfihlo.

Ukusebenza kunye noKucikoza

Ngokutsho kwe-IronSoftware, i-IronXL iphucule kakhulu ukusetyenziswa kwememori kwimisebenzi efana nokuvavanya iipropathi zoluhlu lweeseli, ukusebenza kweeseli ezingaqhelekanga, kunye nokususa ukusebenza komqolo omkhulu, konke oku kusetyenziswa imemori encitshisiweyo. I-IronXL iphuculwe kakhulu, inika amandla ukusebenza kwe-Excel enokuthi isetyenziswe kuyo yomibini imisebenzi elula kunye nentsonkothileyo.

Dibanisa neClient-Side Data Viewer

Abaphuhlisi banokwenza i-ASP.NET Excel viewer usebenzisa i-IronXl. Ungabonisa, uhlele, kwaye ujonge kwiifayile ze-Excel ngqo kwiphepha lakho lewebhu.

I-IronXL ayinayo izakhono eziphambili, ezifana nokubophelela kwedatha, esisixhobo esiyimfuneko sokuhlaziya ngokufanelekileyo amaxabiso e-spreadsheet. Kananjalo ayikuxhasi ukuhluzwa, umsebenzi onokuphucula amandla akho ohlalutyo lwedatha.

Ezinye zeempawu ze-IronXL enazo azibanzi njengoko kufanele ukuba zibe njalo. Umzekelo, kukho iinketho ezimbalwa kakhulu zokwenza itshathi ngokwezifiso. Kwakhona, inani lemisebenzi exhaswayo liphantsi kakhulu, ngakumbi xa lithelekiswa namanye amathala eencwadi esiwakhankanyileyo.

Akunyanzelekanga ukuba ube ngumphuhlisi oyingcali ukuze usebenzise i-IronXL—i-API inokuba lula ukuyisebenzisa. Nangona kunjalo, nangokusebenza kwe-API ephuculweyo ye-IronXL, ukulungelelaniswa, kunye nezinye iimpawu ezibonelela ngazo, unokufuna ukuvavanya ezinye iindlela ngaphambi kokuba uzibophelele kwiprojekthi enkulu yespredishithi.

Ukuqukumbela

Ukunciphisa ukusetyenziswa kwememori kunye nenkqubo yeenyawo, ngakumbi xa iiseti zedatha ezinkulu zisetyenzwa, ngumba oqhelekileyo kuwo onke amathala eencwadi. Ukongeza, uninzi lwamathala eencwadi aneempawu ezifanayo. Ezinye iingongoma eziphambili ekufuneka ziqwalaselwe ngumgangatho weesampulu okanye iidemos ezikhoyo ezisebenzisa ilayibrari ye-API kwaye, ukuba iyasebenza kwimeko yakho yokusetyenziswa, zeziphi iinketho zangaphambili zombukeli ezikhoyo kwilayibrari ye-API. Xa i-factoring in those variables, Document Solutions for Excel, .NET Edition igqamile njengelayibrari yeC # .NET Excel ebanzi eya kwenza amava akho ophuhliso lwespredishithi agudileyo kangangoko kunokwenzeka.