| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font

Show document

Title:VTIČNIK ZA SHRANJEVANJE EXCELOVIH PREGLEDNIC V RAZŠIRLJIV OZNAČEVALNI JEZIK
Authors:Graf, Goran (Author)
Potočnik, Božidar (Mentor) More about this mentor... New window
Files:.pdf VS_Graf_Goran_2010.pdf (1,59 MB)
 
Language:Slovenian
Work type:Bachelor thesis/paper (mb11)
Organization:FERI - Faculty of Electrical Engineering and Computer Science
Abstract: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.
Keywords:Excel, označevalni jezik XML, programski jezik VBA, vtičnik
Year of publishing:2010
Publisher:[G. Graf]
Source:Maribor
UDC:004.4'23:004.439(043.2)
COBISS_ID:14760470 Link is opened in a new window
NUK URN:URN:SI:UM:DK:CGHUBNYK
Views:1430
Downloads:137
Metadata:XML RDF-CHPDL DC-XML DC-RDF
Categories:KTFMB - FERI
:
  
Average score:(0 votes)
Your score:Voting is allowed only for logged in users.
Share:AddThis
AddThis uses cookies that require your consent. Edit consent...

Hover the mouse pointer over a document title to show the abstract or click on the title to get all document metadata.

Secondary language

Language:English
Title:PLUG-IN FOR SAVING EXCEL SPREADSHEETS IN EXTENDABLE MARKUP LANGUAGE
Abstract: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.
Keywords:Excel, mark-up language, XML, programming language VBA, plug-in


Comments

Leave comment

You have to log in to leave a comment.

Comments (0)
0 - 0 / 0
 
There are no comments!

Back
Logos of partners University of Maribor University of Ljubljana University of Primorska University of Nova Gorica