Mafi kyawun madadin Microsoft Excel don Linux

Ba asiri ba ne cewa maƙunsar bayanai suna da mahimmanci don gani da kuma nazarin bayanai a kowane matakai. Suna da buƙatu musamman a duniyar kasuwanci ta zamani amma masu amfani na yau da kullun kuma suna buƙatar su lokaci zuwa lokaci don ƙididdigewa mai sauƙi.

Idan ya zo ga ƙirƙira da gyara maƙunsar bayanai, Microsoft Excel tabbas shine mafi mashahuri shirin da zai iya yin komai daga maƙunsar kasafin kuɗi na gida zuwa rahoton gudanarwa na manyan kamfanoni. Koyaya, software ɗin Microsoft ba ta asali don Linux kuma farashinta na iya zama babban cikas ga masu amfani da yawa.

Hakanan kuna iya son: Top 5 Buɗe-Source Microsoft 365 Alternatives don Linux

Abin farin ciki, akwai wasu mafita na kyauta don Linux waɗanda ke samun ƙarin shahara. Wasu daga cikinsu ba su da ƙarfi kamar Microsoft Office amma aikinsu ya isa don sarrafawa da nazarin bayanai ta hanya mai amfani.

A cikin wannan labarin, zaku sami taƙaitaccen bayani na mafi kyawun hanyoyin Excel don Linux, duka akan layi da kuma amfani da layi.

A wannan shafi

• Sashe na 1: Buɗe-Source Desktop Spreadsheet Software don Linux
  1. LibreOffice Calc
  2. Gnumeric
  3. Sheets na Calligra
  4. Editan Maɓalli na OFFICE KAWAI
• Sashe na 2: Marufi na Desktop na Mallaki don Linux
  1. WPS Maɗaukaki
  2. FreeOffice PlanMaker
• Sashe na 3: Kayayyakin Rubutun Kan layi don Linux
  1. EtherCalc
  2. CryptPad
  3. Dokokin OFFICE KAWAI

Mu fara…

A cikin wannan kashi na farko, za mu tattauna mafi kyawun buɗaɗɗen tushen software na tebur na Linux.

Idan ka tambayi masu amfani da Linux da yawa game da abin da software na falle suke amfani da shi, yawancin zasu ambaci LibreOffice Calc. Wannan buɗaɗɗen aikace-aikacen yana samar da wani yanki na LibreOffice suite wanda ke ba da saitin editoci da kayan aikin samarwa.

LibreOffice cokali mai yatsu ne na aikin OpenOffice.org kuma Gidauniyar Takardu ce ke gudanarwa kuma ta haɓaka shi tare da tallafin babban al'umma na masu sha'awar sha'awa daga ko'ina cikin duniya.

LibreOffice Calc yana ba da duk mahimman abubuwan Excel, kamar tebur pivot, zane-zane, rubutu zuwa ginshiƙai, ƙira, da ƙari mai yawa. Hakanan ana samun zaɓuɓɓukan tsara tsarin salula kuma sun haɗa da abubuwan da ke juyawa, bayanan baya, samfuri, iyakoki, da sauransu. Idan ba ku saba da zaɓuɓɓukan ci-gaba na Calc ba, mayukan da aka gina a ciki zasu taimaka muku yin mafi yawansu cikin sauƙi.

LibreOffice Calc yana amfani da Buɗaɗɗen Takardu Format (.ods) kuma yana dacewa da fayilolin Microsoft Excel. Yana iya ma karanta fayilolin .xlsx da aka ƙirƙira tare da Microsoft Office don macOS, amma wani lokacin dacewa ba cikakke ba ne.

Tare da wannan shirin, zaku iya fitar da maƙunsar bayanai zuwa Tsarin Takardun Takaddun Maɗaukaki (.pdf). Har ma yana ba ku damar buɗe maƙunsar bayanai da aka ƙirƙira tare da tsoffin shirye-shirye kamar Microsoft Works da BeagleWorks.

LibreOffice Calc kuma yana ba da aikin haɗin gwiwa akan maƙunsar bayanai saboda tallafin mai amfani da yawa. Kuna buƙatar kawai raba maƙunsar rubutu tare da wasu masu amfani, kuma za su iya ƙara nasu bayanan. A matsayin mai maƙunsar bayanai, zaku iya haɗa sabbin bayanai a cikin dannawa kaɗan.

Gnumeric editan maƙunsar rubutu ne mai buɗewa wanda ke samar da wani ɓangare na yanayin tebur na GNOME kyauta. Tare da Abiword da wasu shirye-shirye, wani lokaci ana kiransa Gnome Office kuma ana gabatar da shi azaman madadin nauyi mai nauyi ga shahararrun ofishi na Linux kamar OpenOffice, LibreOffice ko KOffice.

Gnumeric galibi ana amfani dashi don sarrafawa da tantance bayanan lambobi. Tare da wannan software, ana yin nazarin bayanai a cikin nau'i na lissafi, kuma ana tsara dabi'u a cikin layuka da ginshiƙai, wanda ya sa ya fi sauƙi don yin ƙididdiga masu rikitarwa.

Gnumeric yana ba ku damar yin ayyuka da yawa da suka haɗa da lambobi, lokuta, sunaye, kwanan wata, ko wasu nau'ikan bayanai. Aikace-aikacen yana goyan bayan nau'ikan sigogi da zane-zane kuma ya haɗa da ayyuka da yawa.

Gnumeric yana iya shigo da bayanai da fitarwa ta nau'i-nau'i daban-daban, wanda ya sa ya dace da sauran shirye-shirye kamar Excel, Lotus 1-2-3, StarOffice, OpenOffice, da dai sauransu. Tsarin asalinsa shine XML, wanda aka matsa da gzip. Yana kuma shigo da fitar da nau'ikan rubutu iri-iri, kamar HTML ko rubutun waƙafi.

Calligra Sheets (wanda aka fi sani da Calligra Tables) ƙididdige tushe ne da aikace-aikacen falle wanda ke cikin aikin Calligra Suite, babban ɗakin ofis ɗin da aka tsara asali don yanayin tebur na KDE.

An tsara zanen gado don ƙirƙira da ƙididdige maƙunsar bayanai daban-daban masu alaƙa da kasuwanci amma kuma yana da kyau don amfanin mutum. Daga cikin abubuwan da Calligra Sheets ke bayarwa, akwai yuwuwar yin aiki tare da zanen gado da yawa a cikin takarda ɗaya.

Har ila yau, aikace-aikacen yana da kayan aikin tsarawa daban-daban kuma yana dacewa da yalwar ƙira da ayyuka. Tarin ginannun shaci yana ba ka damar ƙirƙirar takardu daban-daban (rancen, zanen ma'auni, da sauransu) a cikin sakan. Sheets kuma suna goyan bayan ginshiƙi, hanyoyin haɗin kai, rarraba bayanai, da rubutu ta amfani da shahararrun yarukan shirye-shirye, kamar Python, JavaScript, da Ruby.

Tsarin asali na Sheet ya kasance XML amma tun daga sigar 2.0 yana amfani da Tsarin Buɗe Takaddun Takaddun shaida. Yana iya shigo da takaddun wasu nau'ikan, gami da Microsoft Excel, Applix Spreadsheet, Corel Quattro Pro, CSV, OpenOffice Calc, Gnumeric, da TXT.

ONLYOFFICE Editan Faɗakarwar Fayil ɗin wani ɓangare ne na ONLYOFFICE giciye-dandamali na ofishin suite wanda kuma ya haɗa da sarrafa kalma da kayan aikin gabatarwa. Da farko, aikin ONLYOFFICE yana ba da editocin kan layi kawai don ƙirƙira da gyara takaddun rubutu, maƙunsar bayanai, da gabatarwa, amma masu haɓakawa kuma sun fitar da ƙa'idar tebur kyauta kuma sun sanya shi buɗe tushen.

Aikace-aikacen Desktop ONLYOFFICE ya dogara ne akan tsarin OOXML, don haka kayan aikin maƙunsar bayanai ya dace da asali tare da fayilolin Microsoft Excel (XLSX). Hakanan yana goyan bayan fayilolin XLS, ODS, da CSV da fitarwa zuwa PDF. Abubuwan da aka shafi shirin yana da hankali sosai kuma yana kama da zamani.

Editan yana ba da duk abubuwan da muke son gani a madadin Excel. Kuna iya amfani da ayyuka da dabaru sama da 400, zaɓi daga samfuran samfuri daban-daban, saka sigogi daban-daban da zane-zane gami da tsarawa da tace bayanai yadda kuke so. Hakanan zaka iya gudanar da macros na JavaScript don sauƙaƙe ayyukan yau da kullun da amfani da plugins na ɓangare na uku (misali Google Translator, Telegram, ko bidiyon YouTube).

Ana iya haɗa Editan Desktop KAWAI zuwa ga dandamalin girgije kamar ONLYOFFICE, Nextcloud, ownCloud, ko Seafile don ba da damar yin haɗin gwiwa akan layi. Da zarar an haɗa app ɗin zuwa gajimare, za ku iya raba tare da daidaita maƙunsar bayanai a cikin ainihin lokaci tare da sauran masu amfani.

[ Hakanan kuna iya son: Yadda ake Sanya Editocin Desktop KAWAI a Linux]

A cikin wannan kashi na biyu, za mu tattauna mafi kyawun kayan masarufi na tebur na Linux.

Wani aikace-aikacen falle na mallakar mallaka wanda ya cancanci ambaton shine WPS Spreadsheets. Nasa ne na Ofishin WPS, cikakken ofishi daga China don Windows, macOS, da Linux. Baya ga maɓalli, babban ɗakin ya haɗa da gabatarwar WPS, WPS Writer, da editan PDF.

Babban fa'idar WPS Spreadsheets shine babban dacewarsa tare da fayilolin Excel saboda yana goyan bayan XLS, XLSX, da CSV. Ana fitar da maƙunsar bayanai zuwa PDF amma fayil ɗin fitarwa zai ƙunshi alamar ruwa, wanda shine iyakancewar sigar kyauta don amfani.

Idan ya zo ga gyarawa, Maɗaukakin rubutu yana ba da ingantaccen tsarin fasali. Ka'idar tana goyan bayan ɗaruruwan ƙididdiga da ayyuka waɗanda nau'ikan ke tsarawa, saboda haka zaka iya samun dabarar da ake buƙata cikin sauƙi don bincika hadaddun bayanai.

Har ila yau, maƙunsar bayanai cikin sauƙi suna ba ku damar gabatar da bayanai ta amfani da ginanniyar tarin tebur da salon salula da kayan aikin tsara iri-iri. Siffofin da za a iya ƙera su, allunan pivot, da kayan aikin ƙira suna sauƙaƙa sarrafa bayanai da yin hasashe.

FreeOffice PlanMaker kayan aiki ne na falle wanda ke samar da wani yanki na SoftMaker FreeOffice suite, software na samar da ofis daga Jamus. Suite ɗin ya dace da tsarin Microsoft Office kuma yana samuwa ga masu amfani da Windows, Mac, da Linux.

PlanMaker an ƙera shi don yin ƙididdiga masu rikitarwa da takaddun aiki na kowane nau'i. Kamar kowane madadin Excel, PlanMaker yana ba da abubuwa masu amfani da yawa don ba da damar aiwatarwa da tantance bayanai.

Amfani da wannan kayan aikin, zaku iya saka zane, hotuna, firam ɗin rubutu, 2D da 3D Chars. Fiye da ayyuka 430, tebur pivot, da sauran fasalulluka na bincike suna ba ku damar samun sakamako mai sauri da madaidaici.

PlanMaker ya dace da tsarin Microsoft Excel (XLS da XLSX) da fitar da maƙunsar bayanai zuwa PDF. Koyaya, sigar kyauta ta rasa wasu mahimman abubuwan ci gaba, waɗanda zasu iya zama babbar matsala ga ƙwararrun masu amfani. Don samun cikakken damar yin amfani da duk ayyukan, yakamata ku sayi lasisin dindindin ko biyan kuɗi na ɗan lokaci.

A cikin wannan kashi na uku, za mu tattauna mafi kyawun kayan aikin maƙunsar bayanai na kan layi don Linux.

EtherCalc kayan aiki ne na buɗaɗɗen tushen yanar gizo wanda ke samuwa kyauta kuma an tsara shi don aikin haɗin gwiwa. Yana ba ku damar ƙirƙirar sabon maƙunsar rubutu ko loda wanda yake daidai a cikin mazuruftan ku ba tare da rajista ba. Da zarar an ƙirƙira, za a iya raba maƙunsar rubutu tare da wasu mutane, kuma zaku iya fara daidaita shi tare.

EtherCalc's interface yayi kama da kowane aikace-aikacen maƙunsar tebur, kuma shirin da kansa yana da wasu daidaitattun fasalulluka na tebur, kamar tsara tantanin halitta, ayyuka, hotuna, da sauransu.

Koyaya, kar ku yi tsammanin da yawa daga EtherCalc. Yana da kyau don yin amfani da maɓalli mai sauƙi da haɗin gwiwar kan layi, amma idan kuna buƙatar yin ƙididdiga masu rikitarwa kuma kuna buƙatar fasalulluka na gyare-gyare, zai fi kyau ku zaɓi ɗaya daga cikin zaɓuɓɓukan da ke sama.

Akwai muhimmin abu daya da ya kamata a tuna. EtherCalc yana amfani da URL ɗin da aka ƙirƙira ba da izini ba waɗanda ba su da sauƙin tunawa. Idan kun manta URL ɗin maƙunsar bayanan ku na kan layi, ba za ku iya dawo da shiga ba. Abin da ya kamata ka fara yi ke nan kafin ka fara gyarawa.

CryptPad babban buɗaɗɗen haɗin gwiwar kan layi ne wanda ya haɗa da ɗimbin kayan aiki: Rubutun Maɗaukaki, Rubutun Labarai, Lambobi/Markdown, Kanban, Slides, Whiteboard, da Polls. Kowane aikace-aikacen yana sanye take da saitin fasalulluka na haɗin gwiwa (tattaunawa, lambobin sadarwa, sharhi tare da ambato) don ba da damar daidaita haɗin gwiwar daftarin aiki a cikin ainihin lokaci. Yin amfani da ƙa'idar da ta dace, zaku iya ƙirƙira da shirya maƙunsar rubutu akan layi.

CryptPad yana mai da hankali kan sirrin bayanai kuma yana amfani da algorithm na ɓoye-zuwa-ƙarshe. Dukkan abubuwan da ke cikin ku ana rufaffen su ta atomatik kuma ana ɓoye su a cikin mazuruftan ku, kuma babu wanda zai iya samun damar maƙunsar bayanan ku. Ko da masu kula da dandamali ba za su iya ba.

CryptPad yana amfani da Editan Faɗakarwa na ONLYOFFICE don ƙyale masu amfani da shi don sarrafa bayanai, don haka aikace-aikacen maƙunsar bayanai na CryptPad yana da nau'i iri ɗaya kuma yana ba da ayyuka iri ɗaya. Duk abin da za ku iya yi a cikin KAWAI ana iya yin shi a CryptPad.

Kuna iya amfani da wannan sabis ɗin ba tare da suna ba ba tare da yin rajista da raba bayanan ku ba ko ƙirƙirar asusu kyauta tare da 1GB na ajiya. Idan kuna buƙatar ƙarin sararin ajiya, zaku iya siyan biyan kuɗi da aka biya.

ONLYOFFICE Docs sigar kan layi ne na Editocin Desktop KAWAI wanda aka gina akan injin guda. Saboda haka, yana da nau'in dubawa iri ɗaya kuma yana ba da kusan ayyuka iri ɗaya. Yin amfani da wannan aikace-aikacen, zaku iya ƙirƙirar maƙunsar bayanai na XLSX da shirya fayilolin Excel akan layi ba tare da wasu batutuwan dacewa ba tare da raba su tare da sauran masu amfani ta hanyar hanyar haɗi.

KAWAI Docs an tsara su don haɗin gwiwar kan layi, don haka yana ba da ƙarin fasali don gyara haɗin gwiwa na gaske fiye da aikace-aikacen tebur. Misali, lokacin raba maƙunsar rubutu tare da wasu, zaku iya zaɓar izinin samun dama na musamman da ake kira Filter Custom. Wannan fasalin yana ba ku damar ɓoye bayanan da ba ku son nunawa, kuma masu haɗin gwiwar ku ba za su iya canza tacewa ba.

KAWAI Docs shine mafita mai sarrafa kansa wanda aka yi niyya don haɗawa tare da wasu dandamali na raba fayil ko tsarin sarrafa takardu. Jerin zaɓuɓɓukan haɗin kai da ake da su sun haɗa da owCloud, Nextcloud, Seafile, Alfresco, SharePoint, PowerFolder, Confluence, HumHub, da sauransu.

Idan ba kwa son shigar da wani abu, akwai sigar kyauta ta masu gyara kan layi mai suna ONLYOFFICE Personal. Yana da ONLYOFFICE akan layi wanda aka haɗe tare da tsarin sarrafa fayil mai sauƙi. Kuna buƙatar ƙirƙirar asusun kawai don samun damar gyara maƙunsar bayanai akan layi.

Wannan shine jerin sunayen mafi kyawun madadin Microsoft Excel, duka tebur da kan layi. Menene aikace-aikacen da kuka fi so? Kada ku yi shakka don barin sharhi a kasa!