Urupapuro rwo hejuru C # .NET

Ubushobozi bwurupapuro rwibikoresho bya .NET na porogaramu y'urubuga byabaye bisanzwe. Mugihe hariho byinshi C # .NET urupapuro rwerekana ibisubizo biboneka, ntabwo arimwe.

Ni ukubera iki Umuntu yakenera urupapuro rwerekana urupapuro?

Reba impamvu zimwe zigize urupapuro rwabigenewe:

• Imari ishingiye kumpapuro za Excel mubice byose byubucuruzi
• Kora uburyo bunoze butanga ubushobozi bwo kubara imbaraga, gusesengura ibintu, hamwe na bije
• Kora raporo nibibaho kugirango ushishoze mubucuruzi
• Koresha umutekano wambere hamwe nubushobozi bwibanga bitandukanye nibiboneka muri Excel
• Hindura uburambe bumenyereye kubakoresha Excel muri porogaramu zawe bwite
• Injira dosiye za Excel zihari mubidukikije bigenzurwa muri porogaramu zawe hanze ya Excel
• Emera abakoresha kwinjira no guhindura formulaire ukoresheje imikorere yuzuye ya moteri yo kubara

Muri iyi blog, tuzasuzuma urupapuro rwo hejuru C # .NET dusuzuma ibintu bikurikira:

• Urupapuro rwerekana urupapuro UI
• Ihuza rya dosiye ya Excel
• Imiterere y'utugari
• Imikorere n'imikorere
• Kwemeza amakuru
• Imbonerahamwe n'ibishushanyo
• Ubwoko Bwamakuru Bwuzuye
• Amahitamo yohereza hanze
• Gukemura ibyabaye
• Ubwoko bwakagari
• Abashushanya na Igishushanyo-Igihe Inkunga
• Kuba isi ihinduka / Kuba hafi

Gukwirakwiza.NET by MESCIUS

Urupapuro rwerekana urupapuro UI

Gukwirakwiza ibyuma bya WinForms bifasha imigenzo gakondo ya Excel imeze nkibikoresho byifashishwa hamwe na menus, kunoza uburyo bwo kubona amabwiriza ubitondekanya muri tabs no mumatsinda. Irabikora idatanze imiterere imenyerewe kandi isaba abakoresha kwiga isura nshya.

Ihuza rya dosiye ya Excel

Gukwirakwiza.NET ishyigikira ibikorwa byose byo gucunga dosiye ukeneye kuri XLSX, CSV, na TXT, harimo gukora, gusoma, no guhindura dosiye.

Imiterere y'utugari

Abakoresha barashobora gukoresha uburyo bwose bwo guhinduranya selile, harimo ingano, ingirabuzimafatizo, imiterere, imipaka, amabara, imyandikire, ingero n'ingero, nibindi byinshi.

Imikorere n'imikorere

Moteri yo kubara itanga ibikorwa birenga 500 byubatswe, kuruta ibindi byose .NET urupapuro rwerekana urupapuro. Gukwirakwiza.

Kwemeza amakuru

Urashobora kwemeza ibiri muri selile muburyo bwinshi, harimo guha abemeza selile no gushakisha ibyabaye kugirango ukore ibyemewe. Ukurikije ubwoko bwa selile, kwemeza birashobora no kuba byikora.

Imbonerahamwe n'ibishushanyo

Urashobora kwiyumvisha amakuru yawe hamwe na Spread yuzuye imbonerahamwe. Gukwirakwiza.NET itanga urutonde runini rwimbonerahamwe, harimo inkingi, umurongo, pie, akabari, histogramu, radar, hamwe nimbonerahamwe.

Ubwoko Bwamakuru Bwuzuye

Abakoresha ntibagarukira gusa kumurongo nimibare kubiciro byagaciro. Hano hari inkunga kubitekerezo, inyandiko zifatika, amashusho, hamwe ninyandiko ikungahaye, harimo abiyandikishije hamwe nibisobanuro.

Amahitamo yohereza hanze

Urashobora kohereza urupapuro rwakazi kuri Spread XML, PDF, Excel (XLSX, XLS), TXT, CSV, Ishusho, na format ya HTML.

Gukemura ibyabaye

Ibyabaye birashobora kuzamurwa mukanda, guhitamo, kwinjiza amakuru, guhuza, imiterere, icapiro, nurupapuro rwurwego.

Ubwoko bw'utugari

Gukwirakwiza.NET itanga ubwoko 22 bwakagari, harimo BarCode, Picker y'amabara, ListBox, Hyperlink, na MultiOption. Ubwoko bwakagari burashobora gukoreshwa kuri selile imwe, umurongo, inkingi, ingirabuzimafatizo, nurupapuro rwakazi.

Abashushanya

Ikwirakwizwa ritanga nta-code, porogaramu ishushanya desktop, harimo na Spread Designer, kuri WinForms, WPF, na ASP.NET.

Kuba isi ihinduka / Kuba hafi

Hano hari inkunga yindimi 18, harimo icyongereza nkibisanzwe. Ikwirakwizwa ryururimi rwuzuye rurashobora kwerekana urupapuro rwerekana, Urupapuro rwerekana, ijambo ryibanze ryibanze, nizina ryimikorere. Urashobora kandi gukora izina ryimikorere yururimi rushya.

Kuri UI yayo, Ikwirakwizwa rya MESCIUS.NET ijya kure cyane kuruta izindi mpapuro zerekana urupapuro rutanga urwego rwo hejuru rwa Excel rusa nubushobozi. Ifite kandi ibikorwa byinshi byubatswe nubwoko bwakagari kuruta ibindi bisubizo.

Urupapuro rwerekana urupapuro

Urupapuro rwerekana urupapuro UI

Abakoresha bamenyereye uburambe bwa Excel bazabona DevExpress Spreadsheet igenzura byoroshye byoroshye kuyobora. Itanga imiterere isa na lente UI imiterere, itanga imiterere yumurongo, umurongo, imitwe, inkingi, urupapuro rwakazi, nibindi byinshi.

Ihuza rya dosiye ya Excel

DevExpress itanga inkunga yo gusoma no kwandika dosiye ya XLSX, XLS, XLTX, CSV, na TXT.

Imiterere y'utugari

Urashobora gukora selile kugirango uhuze ibyifuzo byawe. Amahitamo yo guhinduranya akagari arimo imiterere yinyandiko ikungahaye, imiterere yimiterere yimikorere ya selile, imiterere yo gushushanya API, nibindi byinshi.

Imikorere n'imikorere

Hariho ibikorwa birenga 400 byubatswe muri Excel-ihuza ibikorwa. DevExpress iragufasha kandi gukora ibikorwa byawe bwite bishobora gukoreshwa muburyo kandi buraboneka kumpapuro zose zibarwa.

Kwemeza amakuru

Urashobora gukoresha amategeko yo kwemeza amakuru kugirango wemeze ko abakoresha binjiza amakuru yemewe.

Imbonerahamwe n'ibishushanyo

Igenzura rya Spreadsheet ya DevExpress itanga amakuru yo kubona amashusho hamwe nurutonde rwa 2D na 3D, harimo inkingi, umurongo, hamwe nimbonerahamwe. Urashobora kandi kwerekana urupapuro rwakazi hamwe nishusho, harimo umurongo no gutatanya.

Ubwoko Bwamakuru Bwuzuye

Urashobora gucunga amakuru akungahaye nkibitekerezo. Urashobora kongeramo ibitekerezo kumurongo wurupapuro hanyuma ugasubiza kubitekerezo bihari. API itanga kandi inkunga ya hyperlinks. Inzitizi zimwe zirimo kubura inkunga yo gucapa cyangwa kohereza ibitekerezo byanditse kumiterere ya PDF kimwe no kubura ibice byabakoresha kugirango bayobore ibitekerezo.

Amahitamo yohereza hanze

Urashobora kohereza muri PDF na HTML.

Gukemura ibyabaye

DevExpress Spreadsheet itanga ibyabaye gucunga ibyabaye no gukurikirana ibikorwa byabakoresha, guhindura inyandiko, hamwe nimpinduka za code.

Ubwoko bw'utugari

Ubwoko bwa selile buboneka burimo ubusa, mubare, inyandiko, Boolean, namakosa, bimwe muribi biranga ubwoko bwinshi bwo kwerekana.

Abashushanya

Urupapuro rwerekana urupapuro rworoshya kwihitiramo ibintu byinshi mugihe cyagenwe. Urashobora guhitamo imiterere, imbonerahamwe, nibindi byinshi.

Kuba isi ihinduka / Kuba hafi

DevExpress igushoboza guha ibikoresho byawe hamwe nubushobozi bwindimi nyinshi kubiranga imiterere yihariye, nka masike yifaranga nitariki / igihe imiterere. Iragaragaza kandi ibikoresho byubatswe byateguwe mbere yubushobozi hamwe nubushobozi bwinyongera bwibanze binyuze muri Localizer Objects.

Hano harikintu gito cyo kwigira hamwe na DevExpress Spreadsheet ya UI kuko isa na Excel. Irashobora gukora imiterere myinshi ya dosiye, kandi ibikorwa byinshi hamwe na formula biri hafi yawe. Kugaragaza imikorere myinshi ya Excel nko kwemeza amakuru no gufata ibyabaye, ibikoresho bya DevExpress Spreadsheet igizwe no gukora no gutunganya ibishushanyo nishusho byoroshye.

Urupapuro rwerekana amakuru

Urupapuro rwerekana urupapuro UI

Igenzura rya infragistics ' ritanga ibintu byose bisanzwe bigaragara mumashusho ya Excel ifunguye, ntabwo rero ugomba gushingwa kwiga UI-shyashya. Ibigize birimo umurongo ninkingi imitwe, urupapuro rwakazi, utubari twa formula, buto yo kugera kumpapuro zabanjirije iyi, hamwe nububiko. Urashobora gushiraho intoki ibintu biboneka kugirango ubitunganyirize.

Ihuza rya dosiye ya Excel

Inkunga irahari kubikorwa byinshi bya dosiye kuri dosiye ya XLS, XT, XLSX, na XLSM. Urashobora kandi gucunga dosiye yicyitegererezo muburyo bwa XLTX, XLTM, na XLT.

Imiterere y'utugari

Urashobora guhindura selile ihuza, imyandikire, umubare werekana, imipaka, igicucu, nuburinzi.

Imikorere n'imikorere

Infragistics 'Spreadsheet ishyigikira formula zirenga 100.

Kwemeza amakuru

Inkunga yo kwemeza amakuru ikubiyemo buto yamanutse yerekana urutonde rwagaciro. Itegeko ryo kwemeza rishobora gushyirwaho amakuru, kuburira, cyangwa ubutumwa bwo guhagarika ikosa.

Imbonerahamwe n'ibishushanyo

Urashobora guhitamo muburyo burenga 36 bwimbonerahamwe kugirango ubone amakuru yawe. Ibi birimo agace, ibibyimba, n'ibicapo bitatanye. Nanone, imbonerahamwe ihita ivugurura iyo imbonerahamwe ya dataset ihindutse.

Ubwoko Bwamakuru Bwuzuye

Infragistics ituma urupapuro rwakazi hamwe na hyperlinks. Urashobora kandi kuzamura urupapuro rwakazi hamwe nishusho, amashusho, nibitekerezo bya selile.

Amahitamo yohereza hanze

Urashobora kohereza urupapuro rwakazi kuri PDF na HTML.

Gukemura ibyabaye

Urupapuro rw'ibikorwa rwa Infragistics rugufasha gukora no guhagarika ibyabaye bikakumenyesha niba inzira y'ibyabaye irimo gutunganywa.

Ubwoko bw'utugari

Ubwoko bwakagari burimo agasanduku, agasanduku, na agasanduku.

Abashushanya

Infragistics ntabwo itanga urupapuro rwuzuye-urupapuro rwihariye cyangwa igishushanyo mbonera. Ariko, abakoresha barashobora gukora interineti yihariye kugirango bongere ibintu bikenewe mubisabwa.

Kuba isi ihinduka / Kuba hafi

Infragistics itanga imiterere yihariye nururimi.

Infragistics 'Spreadsheet itanga byinshi mubintu wifuza niba ushaka kongeramo ubushobozi busa na Excel mubisabwa. Hano haramenyerewe UI lente, guhuza dosiye, hamwe nimbonerahamwe yagutse.

Nyamara, itangwa ryibintu byingenzi, nkibikorwa bihari nubwoko bwakagari, ni bike cyane ugereranije nibindi bisobanuro byerekana ibisubizo. Niba ushaka urupapuro rwerekana urupapuro rudafite ibikorwa byinshi bifatika, iki gisubizo kirashobora gukora kubisabwa.

Syncfusion WinForms Urupapuro rwinshi

Urupapuro rwerekana urupapuro UI

UI ya Syncfusion's Winforms Spreadsheet isa n'iya Excel. Itanga icyerekezo, cyihariye kigomba guhuza ibyifuzo byawe.

Ihuza rya dosiye ya Excel

Urashobora gukoresha urupapuro rwerekana urupapuro rwo gusoma, kwandika, no guhindura XLS, XLSX, XLSM, XLT, XLTX, na CSV.

Imiterere y'utugari

Urashobora gukora selile ukurikije ibisobanuro byawe ugaragaza ingano yimyandikire, umuryango wimyandikire, imiterere yimyandikire, guhuza, ibara ryimyandikire, no kuzuza ibara. Urashobora kandi kwifashisha ibyateganijwe mbere, byubatswe muburyo cyangwa gushiraho uburyo bwawe bwite. Niba ufite imiterere nuburyo byasobanuwe muri dosiye ya Excel, bizahita bitumizwa hanze.

Imikorere n'imikorere

Urashobora gukoresha formula zirenga 400 zo kubara muri Spreadsheet ya Syncfusion. Indangagaciro z'akagari zizahita zibarwa mugihe agaciro kambere kahinduwe. Hariho kandi inkunga yitiriwe urutonde muri formula.

Kwemeza amakuru

Koresha amakuru yemewe mugihe cyagenwe cyagenwe cyangwa urwego ukoresheje abakoresha, ubutumwa bwo kumenyesha, formulaire yihariye, na lisiti yamanutse.

Imbonerahamwe n'ibishushanyo

Hariho inkunga ya charts 35 yo kugereranya amakuru yerekanwe. Urashobora kandi gutumiza imbonerahamwe muri Excel. Mugihe cyo gushushanya, urashobora gukoresha imbonerahamwe ya Wizard kugirango ukore kandi utegure imbonerahamwe.

Ubwoko Bwamakuru Bwuzuye

Urupapuro rwerekana Syncfusion rugufasha kongeramo hyperlinks hamwe nibimenyetso. Urashobora kurushaho kuzamura urupapuro rwawe winjiza amashusho muri Excel, ukongeraho amashusho mugihe cyogukora, no guhindura no guhindura amashusho mugihe bibaye ngombwa. Hariho kandi imikorere yo gutumiza, kongeraho, guhindura, no gusiba ibitekerezo bya selile.

Amahitamo yohereza hanze

Urashobora kohereza hanze, kubika, no guhindura urupapuro rwawe muburyo butandukanye, harimo PDF na HTML. Urupapuro rwakazi rushobora guhindurwa muburyo butandukanye bwamashusho nka BMP, JPEG, na PNG.

Gukemura ibyabaye

Ibigize bikurura ibyabaye mugihe abakoresha bakora ibikorwa byihariye, nko gukuraho umurongo.

Ubwoko bw'utugari

Ubwoko bwakorewe mubwoko bwa selile burimo ButtonEdit Style, OLE, Calculator Textbox, Calendar Cell, ItarikiTimePicker, NumericUpDown, GridInCell, LinkLabel, PictureBox, IntegerTextBox, DoubleTextBox, na PercentTextBox.

Urashobora kandi kwandikisha ubwoko bwimikorere ya selile.

Abashushanya

Hano hari ibikoresho byoroshye, nka Chart Wizard, kugirango ushireho urupapuro rwerekana urupapuro mugihe cyagenwe.

Kuba isi ihinduka / Kuba hafi

Urupapuro rwerekana Syncfusion rutanga inkunga yo kwandikisha inyandiko ihagaze mugitabo hamwe nibiganiro kururimi urwo arirwo rwose. Urashobora gusaba kwimenyekanisha wongeyeho ibikoresho byumutungo cyangwa ugahindura imirongo yimiterere muri dosiye.

Igice cya Spincshe ya Syncfusion nikintu gishoboka kuri Excel. UI yayo irasa bihagije kubakoresha Excel basanzwe gutangira kuyikoresha ako kanya. Imikorere myinshi irashyigikiwe, kandi kurema no gutunganya ubwoko bwimbonerahamwe iboneka birashobora gukorwa byoroshye hamwe na Chart Wizard. Hariho kandi ubwoko butandukanye bwakagari burahari, bigatuma Syncfusion ihitamo neza kubikorwa byinshi.

Urupapuro rwitumanaho

Urupapuro rwerekana urupapuro UI

Urupapuro rwerekana UI rugaragaza imiterere ya Excel imenyerewe, harimo imirongo, inkingi, imitwe, urupapuro rwakazi, hamwe numurongo wumurongo.

Ihuza rya dosiye ya Excel

Urupapuro rwerekana amakuru rushyigikira gusoma, kwandika, no guhindura XLSX, XLS, PDF, CSV, TXT, hamwe nimbonerahamwe yamakuru muri WinForms na XLSM muri WPF.

Imiterere y'utugari

Uzasangamo uburyo busanzwe bwo guhinduranya selile, harimo ubwoko bwimyandikire, ingano, guhuza, gupfunyika inyandiko, imipaka, amabara yinyuma, hamwe namabara yimbere.

Imikorere n'imikorere

Urupapuro rwerekana amakuru arenga 200 yubatswe kandi igushoboza gukora imirimo yihariye.

Kwemeza amakuru

Urashobora kwerekana imipaka kubishobora kwinjizwa muri selire. Urashobora gushiraho ubwoko butatu bwimenyesha gutangwa mugihe amategeko yo kwemeza amakuru adakurikijwe: ubutumwa bwikosa, amahitamo yo guhagarika impinduka, cyangwa itangazo ryamakuru.

Imbonerahamwe n'ibishushanyo

Imbonerahamwe yimbonerahamwe ikubiyemo kurema, gukoresha, no kureba inkingi, umurongo, umurongo, gutatanya, bubble, pie, donut, nubwoko bwimbonerahamwe.

Ubwoko Bwamakuru Bwuzuye

Urashobora kongeramo ibitekerezo bya selile, imiterere, amashusho, hyperlinks, nubundi bwoko bukize bwamakuru.

Amahitamo yohereza hanze

Urashobora kohereza muri XLSX, XLS, CSV, inyandiko isanzwe, na dosiye ya PDF.

Gukemura ibyabaye

Urupapuro rwerekana urupapuro rushobora kumenyesha ibikorwa byihariye bijyanye na selire, umurongo, inkingi, igitabo cyakazi, urupapuro rwakazi, hamwe na RadWorksheetEditor ibyabaye .

Ubwoko bw'utugari

Ubwoko bwa RadSreadsheet selile zirimo Ubusa, Umubare, Boolean, Inyandiko, na formula. Imiterere yihariye nayo irahari.

Abashushanya

Telerik DevCraft yerekana inzira yo gukora no gutunganya urupapuro rwawe.

Kuba isi ihinduka / Kuba hafi

RadSreadsheet ishyigikira indimi zirindwi, harimo icyongereza. Kuri Winforms, ugomba guhindura icyongereza gisanzwe gitanga icyicaro. Kuri WPF, urashobora gukoresha uburyo bwubatswe muburyo bwo gushyiraho igenzura kururimi wifuza.

UI ya Telerik iramenyerewe kandi yoroshye gukoresha kuri WinForms na WPF, kandi inkunga ya virtualisation yo kunoza imikorere ya UI nikintu cyingenzi. Uzasangamo ibintu byinshi ukeneye kugirango ubone ibikoresho byawe hamwe nubushobozi bwurupapuro rwifuzwa.

Niba ushaka ibintu byinshi byateye imbere, ariko, urashobora gushaka ubundi buryo. Umubare wimirimo iboneka urashobora kugabanya imbaraga zo kubara kwawe.

Urupapuro rwerekana ibikoresho bya .NET

Urupapuro rwerekana urupapuro UI

SpreadsheetGear ntabwo itanga interineti ya UI ubushobozi.

Ihuza rya dosiye ya Excel

SpreadsheetGear itanga inkunga kuri XLSX, XLSM, XLS, CSV, na TXT.

Imiterere y'utugari

Hariho urutonde rwimiterere yimikorere. Urashobora guhitamo ibyo ukunda kumiterere yimibare, imyandikire, imipaka, guhuza, amabara yibitekerezo, selile yimbere imbere, nibindi byinshi.

Imikorere n'imikorere

Isomero ritanga imirimo 449 ihuza Excel, inkunga ya formulaire yingirakamaro, kubara inshuro nyinshi , hamwe nuburyo bwo gukoresha formulaire nibikorwa bisa na Excel. Bimwe mubishobora kugaragara harimo kubura inkunga yingirakamaro hamwe nibikorwa bya LAMBDA.

Kwemeza amakuru

Iyemezwa ryamakuru kuri selile ririmo abakora, ubutumwa bwo kumenyesha, uburyo bwo kumenyesha, formulaire yihariye, na lisiti yamanutse.

Imbonerahamwe n'ibishushanyo

Urashobora gukora no guhindura imbonerahamwe, harimo ibishushanyo mbonera, muburyo butaziguye kurupapuro rwakazi. Hano hari inkunga kubice, akabari, inkingi, umurongo, pie, ububiko, XY ikwirakwiza, radar, hamwe nimbonerahamwe. Hariho ubundi buryo bwo gushushanya kugirango utange ubwoko nyabwo bwimbonerahamwe ushaka.

Ubwoko Bwamakuru Bwuzuye

Urashobora kongeramo ubwoko bwamakuru nkamashusho, ibintu byanditse, kugenzura ifishi, ibitekerezo bya selile, hamwe na AutoShapes kurupapuro rwakazi.

Amahitamo yohereza hanze

Shira kuri Excel na format ya PDF.

Gukemura ibyabaye

SpreadsheetGear ikubiyemo abayobora ibyabaye.

Ubwoko bw'utugari

SpreadsheetGear iranga inkunga yubwoko bwakagari nkibisanduku, ibitonyanga, hamwe nurutonde.

Abashushanya

Igishushanyo-gihe cyo gushyigikira kirimo WorkbookDesigner, WorkbookExplorer, RangeExplorer, ChartExplorer, na ShapeExplorer.

Kuba isi ihinduka / Kuba hafi

Urashobora kwerekana ururimi kubitabo bishya byakazi.

Niba ushaka urupapuro rwerekana urupapuro rworoshye rutanga umubare woroheje wo gusaba kwawe, SpreadsheetGear irashobora kuba yujuje ibisabwa. Mugihe itanga umubare utari muto wimirimo iboneka, ntabwo itanga ubushobozi bwa UI ubushobozi.

Umwanzuro

Gukwirakwiza.NET na MESCIUS yibanze ku kwemeza ko abayikoresha bafite amahitamo menshi yo gucunga no kwerekana amashusho. Urashobora gukoresha intera nini yubwoko butandukanye. Hariho amakuru menshi akungahaye ashobora gukoreshwa kumurongo wagaciro. Ufite kandi ubushobozi bwo kwaguka kugera kurupapuro rwawe rusesuye ukoresheje uburyo bwo kwimenyekanisha.

Niba ukeneye urupapuro rwuzuye rwibisubizo hamwe nibintu byateye imbere byoroshye gukoresha, ndetse no kurupapuro rworoshye, Ikwirakwizwa rya MESCIUS.NET ni amahitamo yawe meza.