20.500.12556/DKUM-16161 VTIČNIK ZA SHRANJEVANJE EXCELOVIH PREGLEDNIC V RAZŠIRLJIV OZNAČEVALNI JEZIK PLUG-IN FOR SAVING EXCEL SPREADSHEETS IN EXTENDABLE MARKUP LANGUAGE Orodja za delo z elektronskimi preglednicami omogočajo enostavno upravljanje s podatki in njihovimi izračuni. Podatke pa včasih želimo uporabiti tudi v drugih programskih orodjih, zato je pomembno, v kakšni obliki so shranjeni. V ta namen se danes najpogosteje uporablja označevalni jezik XML, pri čemer priložen dokument DTD določa definicijo strukture podatkov, uporablja pa se tudi za vzorec ali za preverjanje pravilnosti zgrajenega dokumenta XML. Zaradi avtomatizacije postopkov in potrebe po prenosu podatkov preglednic med različnimi programskimi orodji, smo v tem diplomskem delu razvili vtičnik, ki podatke in njihovo obliko iz preglednice Excel shrani v dokument XML. Vtičnik pa omogoča tudi obraten postopek, in sicer prenos podatkov iz datoteke XML v preglednico Excel. V okviru tega diplomskega dela smo preučili zgradbo Excelovih preglednic in funkcij, ob tem pa smo naštudirali še pravila in zgradbo dokumentov XML in DTD. Vtičnik smo implementirali v programskem jeziku VBA, ki je vgrajen v orodje Excel. Rezultati testiranja so pokazali pravilnost delovanja našega vtičnika. Programming tools for spreadsheets allow easy management of data and their calculations. Sometimes we want to use this data also in other software tools; therefore, it is important in what format are they saved. The most commonly used for this aim is the XML markup language, whereat accompanied DTD document determines a definition of data structure; it is also used for patterns or to verify the correctness of the built XML document. To automate processes and need to transfer data from spreadsheets between different software tools, we developed in this diploma work, a plug-in, which saves the data and their format from Excel spreadsheet into the XML document. Moreover, this plug-in offers also a reverse procedure transferring the data from a XML document into the Excel spreadsheet. Within this diploma thesis, we acquainted with the form of Excel tables and functions, besides we also studied rules and forms of XML and DTD documents. We implemented this plug-in in VBA programming language that is embedded in the Excel. Test results pointed out that our plug-in is functioning correctly. Excel označevalni jezik XML programski jezik VBA vtičnik Excel mark-up language XML programming language VBA plug-in true true false [G. Graf] Slovenski jezik Angleški jezik Diplomsko delo/naloga 2010-10-03 15:26:32 2010-12-20 11:53:57 2022-04-13 07:55:23 2023-12-20 03:20:15 2010 0 Maribor 0 0000-00-00 NiDoloceno NiDoloceno NiDoloceno 0000-00-00 0000-00-00 0000-00-00 004.4'23:004.439(043.2) 14760470 URN:SI:UM:DK:CGHUBNYK VS_Graf_Goran_2010.pdf VS_Graf_Goran_2010.pdf 1 64E65756B3C6B2C1F470627530B0C3B2 5ffd204f1c119a7f25b52b937be61fd38d0db20183ae8f2b982b659279b457aa 94cd3a78-7c04-11eb-bb7a-00155d0001ca 20.500.12556/dkum/04a62dda-cce9-448f-9331-cd8d4c72d1e7 https://dk.um.si/Dokument.php?lang=slv&id=18164 Fakulteta za elektrotehniko, računalništvo in informatiko 0 0 0