Last year I wrote two libraries to generate OOXML (Office OpenXML) ECMA-376 compliant files: wordprocessing (docx) and spreadsheet (xlsx).
Although I needed it, I always thought that was a useless work since Microsoft is working on the OOXML SDK that is currently in CTP for version 2. As a member of the Italian ISO commettee for JTC1/SC34 that recently approved ISO DIS29500, I hope that Microsoft Office suite and OOXML SDK will switch to the latter standard.
Next month I will speak at TechDays about this subject and im my opinion SDK 2 is too much tied to the XML format and too far from a real object model (and for this reason is not so easy to use). It contains extremely powerful tools but there are incredible lacks (ok, it's a CTP, I know).
So I decided to begin mixing SDK 2 with my own code. Let's go...
When I have to create a spreadsheet I expect to work in X,Y coordinates and not A1, B2, C3. In order to convert X.Y coordinates to Excel cell names (used in the ECMA and ISO standards too) the SDK 2 does not provide any help.
For this reason I wrote a class that provides bidirectional conversion (for example 1,3 to "C1" and vice versa).
The class provides both static and instance methods so that can be used to store the coordinates if necessary. Otherwise the static methods simply convert.
Privacy | Legal Copyright © Raffaele Rialdi 2009, Senior Software Developer, Consultant, p.iva IT01741850992, hosted by Vevy Europe Advanced Technologies Division. Site created by Raffaele Rialdi, 2009 - 2015 Hosted by: © 2008-2015 Vevy Europe S.p.A. - via Semeria, 16A - 16131 Genova - Italia - P.IVA 00269300109