projets / macros-openoffice.git / blame
| Commit | Line | Data |
|---|---|---|
| 4d9c5a11 P |
1 | #! |
| 2 | # -*- coding: utf-8 -*- | |
| 3 | """ | |
| 4 | Macro pour faciliter l'intégration des données d'une feuille de calcul | |
| 5 | vers un wiki MoinMoin. | |
| 6 | ||
| 7 | Copyright : Agence universitaire de la Francophonie | |
| 8 | Licence : GNU General Public Licence, version 2 | |
| 9 | Auteur : Jean Christophe André | |
| 10 | Date de création : septembre 2009 | |
| 11 | """ | |
| 12 | import uno | |
| 13 | import unohelper | |
| 14 | from com.sun.star.task import XJobExecutor | |
| 15 | from com.sun.star.beans import PropertyValue | |
| 16 | from com.sun.star.table.CellContentType import EMPTY, VALUE, TEXT, FORMULA | |
| 17 | from com.sun.star.table.CellHoriJustify import STANDARD, LEFT, CENTER, RIGHT | |
| fd5790fa P |
18 | from com.sun.star.table.CellVertJustify import STANDARD, TOP, CENTER as MIDDLE, BOTTOM |
| 19 | from com.sun.star.awt.FontWeight import DONTKNOW, NORMAL, BOLD | |
| 4d9c5a11 | 20 | |
| fd5790fa P |
21 | moinmoin_old_style = True |
| 22 | ||
| 23 | def getRangeSize(sheet, cursor): | |
| 24 | r = cursor.getRangeAddress() | |
| 25 | realRange = sheet.getCellRangeByPosition(r.StartColumn, r.StartRow, | |
| 26 | r.EndColumn, r.EndRow) | |
| 27 | return (realRange.Columns.Count, realRange.Rows.Count) | |
| 4d9c5a11 | 28 | |
| fd5790fa P |
29 | def getCellRealPosition(cursor, column, row): |
| 30 | r = cursor.getRangeAddress() | |
| 31 | return (r.StartColumn + column, r.StartRow + row) | |
| 32 | ||
| 33 | def cell2moin(cell): | |
| 34 | return cell.getString().replace('\n','<<BR>>') | |
| 35 | ||
| 36 | def calc2moin(ctx): | |
| 37 | data = list() | |
| 4d9c5a11 P |
38 | |
| 39 | # récupération du document en cours, vérification du type Spreadsheet | |
| 40 | smgr = ctx.ServiceManager | |
| 41 | desktop = smgr.createInstanceWithContext( | |
| 42 | "com.sun.star.frame.Desktop", ctx) | |
| 43 | curdoc = desktop.getCurrentComponent() | |
| 44 | if not curdoc.supportsService("com.sun.star.sheet.SpreadsheetDocument"): | |
| 45 | raise RuntimeError, u"Ce n'est pas un document de type Spreadsheet (Calc)." | |
| 4d9c5a11 P |
46 | controller = curdoc.getCurrentController() |
| 47 | sheet = controller.getActiveSheet() | |
| 48 | ||
| 49 | # localisation de la la zone déjà utilisée | |
| 50 | cursor = sheet.createCursor() | |
| 51 | cursor.gotoEndOfUsedArea(False) | |
| 52 | cursor.gotoStartOfUsedArea(True) | |
| fd5790fa | 53 | columns, rows = getRangeSize(sheet, cursor) |
| 4d9c5a11 | 54 | for row in range(rows): |
| fd5790fa P |
55 | row_data = list() |
| 56 | column = 0 | |
| 57 | while column < columns: | |
| 4d9c5a11 P |
58 | cell = cursor.getCellByPosition(column, row) |
| 59 | cell_type = cell.getType() | |
| 60 | cell_string = cell.getString() | |
| fd5790fa P |
61 | # calcul de l'étendue de la cellule courante |
| 62 | if cell.getIsMerged(): | |
| 63 | c, r = getCellRealPosition(cursor, column, row) | |
| 64 | cellRange = sheet.getCellRangeByPosition(c, r, c, r) | |
| 65 | cursor2 = sheet.createCursorByRange(cellRange) | |
| 66 | cursor2.collapseToMergedArea() | |
| 67 | cell_colspan, cell_rowspan = getRangeSize(sheet, cursor2) | |
| 68 | else: | |
| 69 | cell_colspan, cell_rowspan = 1, 1 | |
| 70 | # traitement des attributs et styles de la cellule | |
| 71 | cell_attributes = list() | |
| 72 | cell_styles = list() | |
| 73 | if cell_string and hasattr(cell, 'HoriJustify'): | |
| 4d9c5a11 P |
74 | horiJustify = cell.getPropertyValue('HoriJustify') |
| 75 | if horiJustify == LEFT: | |
| fd5790fa P |
76 | if cell_colspan > 1 or cell_rowspan > 1: |
| 77 | text_align = 'left' | |
| 78 | text_align_old = '(' | |
| 79 | else: | |
| 80 | text_align = '' # left par défaut si span == 1 | |
| 81 | text_align_old = '' | |
| 4d9c5a11 | 82 | elif horiJustify == CENTER: |
| fd5790fa P |
83 | if cell_colspan == 1 and cell_rowspan == 1: |
| 84 | text_align = 'center' | |
| 85 | text_align_old = ':' | |
| 86 | else: | |
| 87 | text_align = '' # center par défaut si span > 1 | |
| 88 | text_align_old = '' | |
| 4d9c5a11 P |
89 | elif horiJustify == RIGHT: |
| 90 | text_align = 'right' | |
| fd5790fa | 91 | text_align_old = ')' |
| 4d9c5a11 P |
92 | else: |
| 93 | if cell_type == TEXT: | |
| fd5790fa P |
94 | text_align = 'left' |
| 95 | text_align_old = '(' | |
| 4d9c5a11 P |
96 | elif cell_type != EMPTY: |
| 97 | text_align = 'right' | |
| fd5790fa P |
98 | text_align_old = ')' |
| 99 | if text_align: | |
| 100 | if moinmoin_old_style: | |
| 101 | cell_attributes.append(text_align_old) | |
| 102 | else: | |
| 103 | cell_styles.append('text-align: ' + text_align) | |
| 104 | if cell_string and hasattr(cell, 'VertJustify'): | |
| 105 | vertJustify = cell.getPropertyValue('VertJustify') | |
| 106 | if vertJustify == 1: #TOP(1) | |
| 107 | vertical_align = 'top' | |
| 108 | vertical_align_old = '^' | |
| 109 | elif vertJustify == 2: #MIDDLE(2) | |
| 110 | vertical_align = '' # middle par défaut | |
| 111 | vertical_align_old = '' | |
| 112 | else: #STANDARD(0), BOTTOM(3) | |
| 113 | vertical_align = 'bottom' | |
| 114 | vertical_align_old = 'v' | |
| 115 | if vertical_align: | |
| 116 | if moinmoin_old_style: | |
| 117 | cell_attributes.append(vertical_align_old) | |
| 118 | else: | |
| 119 | cell_styles.append('vertical-align: ' + vertical_align) | |
| 120 | if cell_string and hasattr(cell, 'CharWeight'): | |
| 121 | charWeight = cell.getPropertyValue('CharWeight') | |
| 122 | if charWeight == BOLD: | |
| 123 | if moinmoin_old_style: | |
| 124 | # FIXME: pas utilisé ensuite !! | |
| 125 | cell_string = "'''%s'''" % cell_string | |
| 126 | else: | |
| 127 | cell_styles.append('font-weight: bold') | |
| 128 | if cell_rowspan > 1: | |
| 129 | cell_attributes.append('|%d' % cell_rowspan) | |
| 130 | if cell_colspan > 1: | |
| 131 | cell_attributes.append('-%d' % cell_colspan) | |
| 132 | if hasattr(cell, 'CellBackColor'): | |
| 133 | color = cell.getPropertyValue('CellBackColor') | |
| 134 | if color >= 0: | |
| 135 | if moinmoin_old_style: | |
| 136 | cell_attributes.append('#%06x' % color) | |
| 137 | else: | |
| 138 | cell_styles.append('background: #%06x' % color) | |
| 139 | if hasattr(cell, 'CharColor'): | |
| 140 | color = cell.getPropertyValue('CharColor') | |
| 141 | if color >= 0: | |
| 142 | cell_styles.append('color: #%06x' % color) | |
| 143 | # compilation des styles de la cellule | |
| 4d9c5a11 | 144 | if cell_styles: |
| fd5790fa P |
145 | cell_attributes.insert(0, 'style="%s;"' % '; '.join(cell_styles)) |
| 146 | # ajout de la définition de la cellule à la ligne courante | |
| 147 | cell_data = list() | |
| 148 | if cell_attributes: | |
| 149 | cell_data.append('<' + ''.join(cell_attributes) + '>') | |
| 4d9c5a11 | 150 | if cell_string: |
| fd5790fa | 151 | cell_data.append(cell2moin(cell)) |
| 4d9c5a11 P |
152 | else: |
| 153 | cell_data.append(' ') | |
| 154 | row_data.append(''.join(cell_data)) | |
| fd5790fa | 155 | column += cell_colspan |
| 4d9c5a11 P |
156 | # display row's code |
| 157 | data.append('||' + '||'.join(row_data) + '||') | |
| 158 | ||
| 159 | # | |
| 160 | # création d'un document Writer pour écrire le code MoinMoin | |
| 161 | # | |
| 162 | # ouverture d'un document Writer caché | |
| 163 | hidden = PropertyValue() | |
| 164 | hidden.Name = "Hidden" | |
| 165 | hidden.Value = True | |
| 166 | doc = desktop.loadComponentFromURL( | |
| 167 | "private:factory/swriter", "_blank", 0, (hidden, ) ) | |
| 168 | text = doc.Text | |
| 169 | textcursor = text.createTextCursor() | |
| 170 | text.insertString(textcursor, '\n'.join(data) + '\n', 0) | |
| 171 | # on copie ça dans le presse papier | |
| 172 | dispatcher = smgr.createInstanceWithContext( | |
| 173 | "com.sun.star.frame.DispatchHelper", ctx) | |
| 174 | frame = doc.getCurrentController().getFrame() | |
| 175 | dispatcher.executeDispatch(frame, ".uno:SelectAll", "", 0, ()) | |
| 176 | dispatcher.executeDispatch(frame, ".uno:Copy", "", 0, ()) | |
| 177 | doc.close(True) | |
| 178 | ||
| 179 | ############################################################################## | |
| 180 | ||
| 181 | def copier(event=False): | |
| 182 | u"""Copier une feuille de calcul vers un wiki MoinMoin.""" | |
| 183 | ctx = uno.getComponentContext() | |
| 184 | calc2moin(ctx) | |
| 185 | return None | |
| 186 | ||
| fd5790fa P |
187 | # lists the scripts, that shall be visible inside OOo. Can be omited, if |
| 188 | # all functions shall be visible, however here getNewString shall be surpressed | |
| 4d9c5a11 P |
189 | g_exportedScripts = (copier, ) |
| 190 | ||
| 191 | ############################################################################## | |
| 192 | ||
| 193 | class CopierJob(unohelper.Base, XJobExecutor): | |
| 194 | def __init__(self, context): | |
| 195 | self._context = context | |
| 196 | ||
| 197 | def trigger(self, args): | |
| 198 | calc2moin(self._context) | |
| 199 | ||
| 200 | g_ImplementationHelper = unohelper.ImplementationHelper() | |
| 201 | g_ImplementationHelper.addImplementation( \ | |
| 202 | CopierJob, "org.auf.openoffice.calc2moin.Copier", \ | |
| 203 | ("com.sun.star.task.Job",),) |